Entity Framwork now supports stored procedures that return data

The new version of the Entity Framework in VS 2010 can now automatically create entities from select stored procedures which return data. Prior to this release it only supported mapping to insert and update stored procedure although L2S did.

Simply goto the designer model and right click then Add then Function Import. Select the stored procedure name and get columns names. This will create an entity class to hold all the data returned by the stored procedure.