After some research I found out that in some circumstances it is necessary to add the following two statements at the beginning of the stored procedure:
SET NOCOUNT OFF; SET FMTONLY OFF;
After that everything worked as expected.
Monday, March 12, 2012
Entity Framework no columns when mapping stored procedure
Recently I had the problem that I wanted to map a stored procedure with the Entity Framework. As soon as I clicked on "Get column information" no columns showed up despite I knew that the stored procedure returns a table with some columns.
After some research I found out that in some circumstances it is necessary to add the following two statements at the beginning of the stored procedure:
After that everything worked as expected.
After some research I found out that in some circumstances it is necessary to add the following two statements at the beginning of the stored procedure:
After that everything worked as expected.
Subscribe to:
Posts (Atom)