Click here to Skip to main content
11,479,486 members (47,111 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MVC3
hi,
i am new to mvc 3.so can some one tell me how to use the sql server store procedure in mvc 3 razor.i am not using the linq to sql (.dbml) class and ado.net entity data model. I am simply using the connectionstring in the web.config file. and the use the DbContext class in model.if possible than pls send me a demo application or any source code.
Thanks,
Naveen Sharma
Posted 15-Dec-11 22:50pm
Edited 15-Dec-11 23:48pm
v4

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Data access implementation has nothing to do with MVC3 razor. It is designed to display the content in the web pages. to There are different options you can use for data access including the following:

ADO.NET
LINQ to SQL
NHibernate
Entity Framework


See the following link for more details on seleting different options with MVC3

http://stackoverflow.com/questions/6239894/mvc-3-using-stored-procedure-vs-entity-framework-4[^]

To retreive data using SP, check the following article:

http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx[^]
  Permalink  
Comments
RaviRanjankr at 16-Dec-11 15:26pm
   
Nice answer, My 5+

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

  Print Answers RSS
0 OriginalGriff 255
1 Sergey Alexandrovich Kryukov 215
2 F-ES Sitecore 175
3 Richard MacCutchan 120
4 Frankie-C 104
0 Sergey Alexandrovich Kryukov 7,890
1 OriginalGriff 7,441
2 Sascha Lefèvre 3,064
3 Maciej Los 2,491
4 Richard Deeming 2,335


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 16 Dec 2011
Copyright © CodeProject, 1999-2015
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