How do I use LINQ on a store procedure with a Select Statment?

Question

Hi there,

How do I use LINQ on a store procedure with a Select Statment? I know how can I use store procedure to execute some procedure for me, however, if I want to return some data from a store procedure? How do I do that?

Regards

Answer 1

Scott Guthrie has a fairly detailed blog post about this. Normally I believe you'd call a stored procedure as a separate method - if you want to include it in a select clause, you should probably use a user-defined function (UDF) instead. These are covered in the same blog post.

If you've already read this and it doesn't help, could you give details of which part isn't working for you?