Click here to Skip to main content
15,301,841 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi i am new to asp.net mvc3
how can i call a stored procedure in asp.net mvc3
if anybody knows plz give suggestion


[EDIT - moved from solution 2]
i'm doing it with linq to sql method, but didn't get how to call a stored procedure
[/EDIT]
Posted
Updated 16-Feb-13 2:51am
v2
Comments
Syed Salman Raza Zaidi 15-Feb-12 5:26am
   
I am using NHibernate its easy to call stored procedure in it :)
sajan064 15-Feb-12 5:28am
   
plz tell how to use NHibernate and give me some links through which i can learn to call stored procedure
Syed Salman Raza Zaidi 15-Feb-12 5:37am
   
check my updated solution

MVC is not responsible for the way you access your data. There are many technologies that you can use including

Plain old ADO.NET
LINQ to SQL
NHibernate
Entity Framework


NHibernate with SP[^]

NHibernate[^]

More[^]
   
v2
Comments
adee.sidz 15-Feb-12 5:46am
   
5up!
i want to insert the data into database plz suggest how to insert using stored procedure
   
Hi There,
You can have a linq class to execute your stored procedure..

Try with LINQ class..

Go Ahead.. :)
   
Comments
sajan064 15-Feb-12 5:21am
   
can you explain me the process how to call the store procedure ?
Hi,

Please check this link for executing SP in C# using LINQ

Thanks
-amit.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900