The solution for this write this line "SET FMTONLY OFF" in begin part of your Stored Procedure but it will not work in selecting data from another database.
Example : Create procedure SPname
as
SET FMTONLY OFF
Wednesday, September 19, 2012
The selected stored procedure returns no columns
The reason was, selecting from a temp table and EF can’t figure out the shape of the results at design time.
The solution for this write this line "SET FMTONLY OFF" in begin part of your Stored Procedure but it will not work in selecting data from another database.
Example : Create procedure SPname
The solution for this write this line "SET FMTONLY OFF" in begin part of your Stored Procedure but it will not work in selecting data from another database.
Example : Create procedure SPname
Subscribe to:
Post Comments (Atom)
-
I spent plenty of time for delving into this problem' depths. I can summarize the solution as follows: 1. Create The Entity Class (e.g...
-
Image upload with CKEditor. My latest issue was how to integrate CKFinder for image upload in CKEditor. Here the solution. 1. Download C...
-
I installed MVC4 latest version, but my app is using MVC3.0. The problem was on MVC version. Check MVC version of your app. Thanks Learn...
No comments:
Post a Comment