How to retrieve an int from Stored Procedure using EF ???

Question

Hi,   im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data. after setting i should recive an int id of the record that was created. my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int... How to retrieve an int from Stored Procedure using EF ???

vikas_jk · Accepted Answer

A possible solution to your question can be as it appears that Entity Framework gets confused as to what should be returned by the procedure. The solution I've come across is to add this at the top of the sproc:

SET FMTONLY OFF

It may resolve your issue.

Another possible solution can be:

Move to your .edmx
At Model Browser, Window/Function Imports find your procedure then double click it
Change the return type to you want
Save .edmx and check the return type again.

Check Link for Details

How to retrieve an int from Stored Procedure and not an objectResult using EF ???

Related Articles

Subscribe Now

Related Questions