I'm converting a stored method into a complicated type using the Entity Framework (EF). The stored method was modified recently (additional return values were added). The complicated type that corresponds to this stored method needs to be updated. Does this even exist, and if so, how? Currently, I delete my complicated type and function import whenever a stored procedure changes, which is probably not the best course of action.
Without erasing the complicated type, I was able to do this in another method. Your Complex Type may be updated, and Visual Studio will add any modified columns. This is how:
That ought should do it.
Look at SO for a simpler method to do that: here. The stored procedure receives certain meta data additions that the EF utilizes to provide the proper return type for you.
The stored procedure's meta information section just provides information about the columns and datatypes it returns; it is not actually run.