Call Procedure from asp.net MVC

Question

create or alter procedure select_profile_data @id int as begin select COUNT (*) from Table1 where U_ID=@id select COUNT (*) from Table2 where U_ID=@id end ; I want to use the data individually from both of these select statements. So how can I call this procedure from my ASP MVC action and how to implement the data that return from the procedure?

Nilesh Shah · Answer

in the SP you need two output parameters create or alter procedure select_profile_data @id int  @count1 int OUTPUT  @count2 int OUTPUT as begin select @count1 = COUNT (*) from Table1 where U_ID=@id select @count2 = COUNT (*) from Table2 where U_ID=@id end ; I suggest you create a seperate project for dealing with data not directly from controller. In your C# code when you call the SP get the value of output parameter like: SqlParameter outputVal = new SqlParameter( @count1  SqlDbType.Int); outputVal.Direction = ParameterDirection.Output; command.Parameters.Add(outputVal); note: above is just a sample code use your own code here. once you have values use it like any normal variable to show in view.

Ashwani Bakshi · Answer

https://stackoverflow.com/questions/39587606/how-to-call-and-execute-stored-procedures-in-asp-net-mvcc