Refreshing a stored procedure in entity framework 3.5

I’ve seen two problems with updating a Stored Procedure after adding it to the entity framework:

• The Function Import created to call the SPROC wasn’t updated (incorrect, out-of-date parameters)
• The Complex Type created for the SPROC’s result set wasn’t updated (incorrect, out-of-date fields)

Updating EDMX model (function import)

1. Open the .edmx file (in the GUI designer).
2. Right-click in some open space and select “Update Model from Database”.
3. Click Finish (when able) on the pop-up window. Your SPROC’s signature should be updated (along with any Function Imports).

Updating stored procedure complex type

1. open the “Model Browser” window while you have the .edmx open.

2. Expand the ContentModel, EntityContainer: …, and then Function Imports nodes. Look for the function import for your stored procedure and double click it. The same window you used to create it will open, but now populated with its data.

3. Click the Get Column Information button (look at the grid below the button to see what will be changed).

4. Click the Update button next to the “Complex” radio button choice.

5. Click OK, and the Complex Type for your result set should be updated.