[How Do I:] LINQ to SQL: Using Stored Procedureshttp://asp.netTue, 20 Apr 2010 08:49:49 GMTumbracoComments for [How Do I:] LINQ to SQL: Using Stored ProceduresenComment Posted by przemeklachhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresTue, 25 Mar 2008 00:51:16 GMT00000000-0000-0000-000000006805Hi,

Couple questions:

It seems like you can make powerful queries without using stored procedures, at what point do you decided to use stored procedures?

Does using LINQ break the MVC model? It seems like you are mixing parts of the controller with the model.

Thanks

]]>Comment Posted by grimristhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresThu, 10 Jul 2008 14:20:19 GMT00000000-0000-0000-000000006806I use stored procedures mainly because we have them created already. I would imagine only using stored procedures if they are available and are at your disposal. Why reinvent the wheel when they are already there for you.

Myself on the otherhand, likes to reinvent the wheels.

]]>Comment Posted by cv_vikramhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresMon, 18 Aug 2008 10:56:20 GMT00000000-0000-0000-000000006807thanks....

]]>Comment Posted by iscotthttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresThu, 28 Aug 2008 01:52:39 GMT00000000-0000-0000-000000006808The major reason for using stored procedures is that they execute quicker that the equivalent in-line query. This is because SQL Server has the opportunity to work out the best execution plan ahead of the time when the stored procedure will be called by the application.

]]>Comment Posted by S.Pirashanthhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresThu, 28 Aug 2008 05:05:07 GMT00000000-0000-0000-000000006809Many thanks for the great videos

]]>Comment Posted by vinzhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresFri, 17 Oct 2008 17:51:24 GMT00000000-0000-0000-000000006810Great video! Thank you!

]]>Comment Posted by djibril_chimere_DIAWhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresFri, 24 Oct 2008 07:43:02 GMT00000000-0000-0000-000000006811Thanks! Jërëjëf!

]]>Comment Posted by alexchrhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresTue, 28 Oct 2008 17:15:54 GMT00000000-0000-0000-000000006812hi,

6:45 : The return values is a collection of Produt objects...

so instead of using

foreach(var p in q) which works anyway

you can use

foreach(product p in q)...  

thanx for the videos and source codes, nice place to start from!

]]>Comment Posted by rami_nassarhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresTue, 09 Dec 2008 11:57:01 GMT00000000-0000-0000-000000006813thats what i was seeking for

]]>Comment Posted by agrawalbshttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresWed, 28 Jan 2009 15:17:02 GMT00000000-0000-0000-000000006814trying to download for last two days but not able to do it.

]]>Comment Posted by prolingua.geohttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresMon, 09 Feb 2009 10:42:32 GMT00000000-0000-0000-000000006815thanks for the video

]]>Comment Posted by uniquesaifulhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresSun, 22 Feb 2009 05:43:23 GMT00000000-0000-0000-000000006816Cool video. Thanks

]]>Comment Posted by vvphanhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresWed, 25 Feb 2009 15:46:31 GMT00000000-0000-0000-000000006817Thanks

]]>Comment Posted by sisiekohttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresFri, 13 Mar 2009 23:34:49 GMT00000000-0000-0000-000000006818I am not comfortable with the idea of hard coding sql statements on my aspx pages, i think stored_procedures are best way to go.

]]>Comment Posted by amin_pucithttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresFri, 24 Apr 2009 12:57:54 GMT00000000-0000-0000-000000006819nice work!

]]>Comment Posted by DotNetXenonhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresFri, 04 Sep 2009 19:01:47 GMT00000000-0000-0000-000000006820Thanks for the great video!!!

]]>Comment Posted by NaoufelBellalihttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresTue, 22 Dec 2009 16:01:12 GMT00000000-0000-0000-000000006821but i have a small problem when i retrive data from database

it can't detect modification

i must regenerate all the model or what ??

thanks

]]>Comment Posted by asus3000http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresTue, 29 Dec 2009 20:03:23 GMT00000000-0000-0000-000000006822The three main reasons for using stored procedures: Stored procedures only require parameters passed instead of queries (fast), they're pre-compiled and optimized (fast), and the code is stored separately (organization).

Stored procs can get to be quite large and off-loading all the tasks to the SQL Server is far better than going back and forth between servers.

There are other benefits but these are the main ones that come to mind first.

]]>Comment Posted by vvvvvdevhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-using-stored-proceduresTue, 20 Apr 2010 08:49:49 GMT00000000-0000-0000-000000006823thanx..carry on

]]>