Edmx does not autogenerate the return result class of a stored procedure

Jump to: navigation, search

Edmx may not auto-generate the return result class of a stored procedure. If you view the model browser and attempt to manually generate you will get the following error: The selected stored procedure returns no columns This occurs when your sp result returns a temp table. The workaround is to add the following line to your sp when you are adding it to the edmx SET FMTONLY OFF

See also

Use your Android as a Genie garage door opener remote

Personal tools