>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?

Hi,
Sounds like there's really two questions in there:

(a) Given the option is it better to avoid SP's when using EF ?
and
(b) If you don't have the option then how well does EF handle them?

I suspect the answer to (a) is 'Yes' - and given that, until now at least, I've been able to take that option I don't really have an opinion on (b) :-}

I'm looking at it from a 'simplicity of coding' viewpoint - there may be good arguments to use SPs sometimes from a performance POV?