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

Hi Viv,

Interesting topic now even more so. Now that I think about this, the consistency with Store Procedures might be enhanced, but the simplicity is somewhat lost. I don't as of yet have enough experience with EF to draw any real conclusions on how well it performs with or without SP's. Thank you for your comments, that helps to begin thinking about what things to consider.
Tim