ASP.NET MVC data accessing using Linq to sql prodecure
HI Experts,
I am using ASP.NET MVC for my website and trying to get data from database. I have already created SQL procedure on SQL Server 2005 and I would like to use Linq to sql procedure to get data and display on web site.
Thank you
I am using ASP.NET MVC for my website and trying to get data from database. I have already created SQL procedure on SQL Server 2005 and I would like to use Linq to sql procedure to get data and display on web site.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://msdn.microsoft.com/en-us/magazine/cc500645.aspx
Hi,
See if this helps you
http://aspalliance.com/1604_Building_a_Simple_Blog_Engine_with_ASPNET_MVC_and_LINQ__Part_3
http://www.asp.net/(S(pdfrohu0ajmwt445fanvj2r3))/learn/mvc/tutorial-10-cs.aspx
Thanks and regards,
Venki
See if this helps you
http://aspalliance.com/1604_Building_a_Simple_Blog_Engine_with_ASPNET_MVC_and_LINQ__Part_3
http://www.asp.net/(S(pdfrohu0ajmwt445fanvj2r3))/learn/mvc/tutorial-10-cs.aspx
Thanks and regards,
Venki
Hi saloj;
If you have not already created a OR/M, Object Relational Model yet you will needed to create one. In Solution Explorer right click on the project name and select Add -> New Item and from the Add New Item dialog box select Linq to SQL Classes give the model a name and click Add button. Once the design surface opens drag the tables and the Stored Procedure from the Server Explorer window on to the design surface and save your work. At this point you are now ready to write Linq to SQL queries.
Fernando
If you have not already created a OR/M, Object Relational Model yet you will needed to create one. In Solution Explorer right click on the project name and select Add -> New Item and from the Add New Item dialog box select Linq to SQL Classes give the model a name and click Add button. Once the design surface opens drag the tables and the Stored Procedure from the Server Explorer window on to the design surface and save your work. At this point you are now ready to write Linq to SQL queries.
Fernando