2
Answers

Call Procedure from asp.net MVC

Amit Kumar

Amit Kumar

7y
603
1
  1. create or alter procedure select_profile_data  
  2. @id int  
  3. as  
  4. begin  
  5. select COUNT(*) from Table1 where U_ID=@id,  
  6. select COUNT(*) from Table2 where U_ID=@id  
  7. 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?
Answers (2)