Click here to Skip to main content
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 280
1 Sergey Alexandrovich Kryukov 279
2 CPallini 205
3 Maciej Los 197
4 Afzaal Ahmad Zeeshan 160
0 OriginalGriff 5,635
1 DamithSL 4,496
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 16 Dec 2011
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