How to define multiple procedure in MVC

Question

Hi Friends i am display the data on table in mvc here i am using 2 procedures i know how to dfeine single procedure like command.CommandText = PROCEDURER_UPDATE_DATA ; Know I want to call multiple procedure so how to define

Nitin Sontakke · Answer

You cannot. All you can do is write a wrapper stored procedure and call that one. The wrapper stored procedure in turn will call two different stored procedures you want to call. Pass all the parameters required by two stored procedures to this single wrapper stored procedure. Hope it helps!