Stored Procedures returning Scalar Values

Question

I discovered recently that the current version of the Entity Framework does not generate code when you perform a function import for a stored procedure that returns a scalar result.

We did a workaround for this by coding our own function, in which we utilised a DataReader and then returned the first field in the DataReader as the result.

Are there any other possibilities?

Answer 1

Hi,
I wrote a post about this situation in EF1.
You can read it here:
http://blogs.microsoft.co.il/blogs/gilf/archive/2009/04/03/supporting-stored-procedures-that-return-primitive-types-in-entity-framework.aspx

I hope it will help you.

---

Gil Fink

Answer 2

Thanks Gil.

Your article was very useful.