Using Stored Procedures with Entity Framework

ByTrent Jones

Using Stored Procedures with Entity Framework

Yesterday i was attempting to use a stored procedure with the Entity Framework through the “function import” features and couldn’t get the auto-gen feature to expose the function on the Context.  The stored procedure was returning a scalar value which at this point doesn’t seem to be supported through auto-gen.  Choosing an Entity, however works fine. Further digging this morning led me to this article on the ADO.NET team blog explaining the issues with return types and stored procedures in Entity Framework.  The article also links to another great article showing how to return custom types two ways:  one way through the entity framework itself, the other through the use of extension methods.

ADO.NET Entity Framework Extensions

About the Author

Trent Jones administrator