CODEWITHSUNDEEP
c#asp.netentity-frameworkentity-framework-5edmx
John John
John John

Reputation: 1

unable to map stored procedure to my .EDMX file. The selected stored procedure or function return no columns

I am working on an asp.net mvc 4 web application , and i am using EF version 5, with data base first approach. now i created a stored procedure inside sql server 2008 r2, but when i tried to map the stored procude inside my .edmx file i will get the following error :-

The selected stored procedure or function return no columns

enter image description here

Upvotes: 0

Views: 169

Answers (1)

COLD TOLD
COLD TOLD

Reputation: 13579

If your stored procedure does not return any data, as it what the EF thinks then instead of selecting complex you need to select None.

Upvotes: 1

Related Questions