Creating Entity Framework Objects from Stored Procedures
When using Entity Framework 4, how do you create a single entity from a stored procedure?
After you add the stored procedure to the model, from the Model Browser right-click the stored procedure under the Store node and select 'Add Function Import'. In that dialog, indicate what entity should be created:
You can then use that stored procedure like this:
Artist a = ctx.SelectArtist(id).SingleOrDefault();
Based on the comments, it sounds like you want to use stored procedures to perform inserts, updates, and deletes. If you right-click on the entity in the model browser and select 'Stored Procedure Mapping', you'll get a window that lets you specify which stored procedures to use. MSDN has a walkthrough on how to do this.