Cannot implicitly convert type System.Data.Entity.Core.Objects.ObjectResult to System.Data.Objects.ObjectResult

Question

I am trying to update an EDMX Stored Procedure and I am getting this error:

Cannot implicitly convert type System.Data.Entity.Core.Objects.ObjectResult<X> to System.Data.Objects.ObjectResult<X>

I am using Visual Studio 2012.

Answer 1

I had the error and none of these solutions worked (I was already using System.Data.Entity.Core.Objects, it was also in the context.tt, etc).

I eventually realised the problem lay between the keyboard and the chair. The stored proc finished with a select, but I was trying:

MyStoredProc_Result r = dbcontext.MyStoredPoc();

Instead of

MyStoredProc_Result r = dbcontext.MyStoredPoc().FirstOrDefault();

Answer 2

Open the context.tt file in XML mode and change

using System.Data.Objects;

to

using System.Data.Entity.Core.Objects;