>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
SP's is a best practice or not is another debate. If you ask to SQL DBA it is. If you ask me, let me think about it:)
You can however use SPs with Linq to SQL or EF. When it is EF, it is not as direct as with L2S but still you can. You may want to get a quick peek at this fresh article:
http://msdn.microsoft.com/en-us/data/ff707264.aspxPS: L2S is easier. However MS is enhancing EF.
Cetin