error, issue, RnD, notes for my colleagues ... anything related with my job. A good programmer should be a good and fast reader. This log just to cut the costs of my RnD. Nothing personal :)
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment