Wednesday 13 July 2016

Fixed: The selected stored procedure returns no columns

Hi johnjohn123123, The problem maybe caused by your stored procedures may contain: Dynamic queries Temporary tables While EF doesn't support importing stored procedures above. The reason is that to import the procedure EF must execute it. Such operation can be dangerous because it can trigger some changes in the database I suggest you add following code in the start of your stored procedure SET FMTONLY OFF then save the Stored Procedure, Update the model and retry. Hope it can help you. Best Regards, Kevin Shen.

No comments: