>>>Hi all,
>>>
>>>In thinking about the use of Linq for retrieving data from SQL Server or in paticular via the Entity Framework, I have been wondering about the role of stored procedures. It has been my thinking for quite some time that using stored procedures was a best practice and often a requirement. Now with Linq, how is this practice affected?
>>>Thanks
>>>Tim
>>
>>Using Stored Procedures are often overkill when using ORMs, unless you have a crazy DBA who requires it.
>
>Hi Mike,
>
>Can you elaborate on that? Stored Procedures are often required but in addition they were considered Best Practice for other reasons such as SQL injection attacks and limiting access to the data. What I am wondering is, if these considerations have changed when using Linq or Entity Framework.
>
>Crazy DBA's. I would probably do the same if I was the DBA and had data that was sensitive and my job required me to maintain data integrity. They probably say "Crazy Developers do crazy things to jeopradize the integrity of my data".
------------------

SPs are great for heavy lifting. SPs are overkill for CRUD operations.

If Transactions are needed then SP is needed.

YMMV