Need a simple CRM and Project Management system?
Check out JobNimbus - CRM for Contractors and Service Professionals.

stored procedure

Using Stored Procedures in the Entity Framework with Scalar Return Values

Submitted by Ben Hodson on Thu, 05/20/2010 - 16:50

Although stored procedures may be on their way out (see post here: http://stackoverflow.com/questions/216569/are-the-days-of-the-stored-procedure-numbered), they are still supported in Entity Framework and can be used relatively easily. There are many tutorials on how to use a stored procedure in the Entity Framework to return a set of data and bind it to an Entity. But I had a little more trouble figuring out how to call a stored procedure that returns a scalar value.