Entity Framework 4 Mapping a Stored Procedure
Update the Model from the database by selecting the Stored Procedure and including it in the model.
Right click on the design surface and choose Add Function Import, select the stored procedure from the list and click Get Column Information, then click the Create New Complex Type button so that there’s an entity to map to.
http://weblogs.asp.net/kencox/archive/2009/11/25/using-a-stored-procedure-in-entity-framework-4.aspx
