Raman Ghantiyala
how to use stored procedure in Asp.net MVC3
Posted by Raman Ghantiyala in ASP.NET Programming on Sep 04, 2012
  • 0
  • 1
  • 2979
Do you know the answer for this question? Post it below.
Posted by Parthiv Pandya on Sep 11, 2012
  • 0

Hi Raman,

Suppose you are working with Linq to sql then drag and drop your stored procedure to right side window of dbml and build the project.
then you use it like a method in your project.
Ex: if you are creating Datacontext Object then use that Object to retrieve your stored procedure.
DataContext db=new DataContext();
if parameter is available then pass into it.