Creating infrastructure objects from stored procedures

Question

When using Entity Framework 4, how do you create a single entity from a stored procedure?

Answer 1

After adding the stored procedure to the model from the Model Browser, right-click the stored procedure in the Storage node and select "Add Import Function". In this dialog box, specify which object should be created:

Then you can use this stored procedure as follows:

Artist a = ctx.SelectArtist(id).SingleOrDefault(); 

Edit

Based on comments, it sounds like you want to use stored procedures to perform insertions, updates, and deletes. If you right-click on an object in the model’s browser and select “Storage of stored procedures”, you will get a window in which you can specify which stored procedures to use. MSDN has a walkthrough on how to do this.

NTN