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

Personal tools
Namespaces
Variants
Views
Actions
Navigation