Re: Confused about proc vs. dynamic SQL vs LINQ

Jon Skeet [C# MVP] wrote:

See http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx for
more details "against" stored procs.

For a more clearer overview:
http://weblogs.asp.net/fbouma/archive/2006/05/26/Yay_2100_-A-new-Stored-
Proc-vs.-Dyn.-Sql-battle_2100_.aspx

The 'procs are bad, m'kay?' article was a bit tongue in cheek as well,
so please read
http://www.theserverside.net/news/thread.tss?thread_id=31953#158113
which is more serious.

Procs aren't all bad of course, Jon gave a great example when they're
useful:
" 2) When the stored proc needs to do a lot of work with the data but
doesn't actually need much of the data to come out of the other end,
thus vastly reducing network traffic."

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
.