Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# MVC3 ASP.NET4.0
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 14-Feb-12 23:15pm
Edited 16-Feb-13 2:51am
Maciej Los136.7K
v2
Comments
Syed Salman Raza Zaidi at 15-Feb-12 5:26am
   
I am using NHibernate its easy to call stored procedure in it :)
sajan064 at 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 at 15-Feb-12 5:37am
   
check my updated solution
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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[^]
  Permalink  
v2
Comments
adee.sidz at 15-Feb-12 5:46am
   
5up!
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Hi There,
You can have a linq class to execute your stored procedure..
 
Try with LINQ class..
 
Go Ahead.. Smile | :)
  Permalink  
Comments
sajan064 at 15-Feb-12 5:21am
   
can you explain me the process how to call the store procedure ?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

Hi,
 
Please check this link for executing SP in C# using LINQ
 
Thanks
-amit.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 6

i want to insert the data into database plz suggest how to insert using stored procedure
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.140926.1 | Last Updated 16 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100