Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Entity Framework 6 Cannot build after adding stored procedures to data model

I just downloaded entity framework 6 and created a brand new project to test it. We currently use EF 5.

After adding all my tables and stored procedures, I tried to build the project but I get errors:

Value of type 'System.Data.Objects.ObjectParameter' cannot be converted to 'System.Data.Entity.Core.Objects.ObjectParameter'.

Value of type 'System.Data.Entity.Core.Objects.ObjectResult(Of DataLibrary.MyStoredProc_Result)' cannot be converted to 'System.Data.Objects.ObjectResult(Of DataLibrary.MyStoredProc_Result)'.

I cannot figure out why this will not work out-of-the-box

EF 5 had so such issues.

I am using VS 2012. .Net 4.5 Vb.net (also tried with a C# project... same issue)

Any ideas?

EDIT:

The answer was to install EF6 Tools for VS 2012. I did not know I had to do this since I thought that was installed when I added the Entity Framework package.

like image 457
Eric Avatar asked Oct 29 '13 14:10

Eric


People also ask

Can we use stored procedure in entity Framework?

You can use stored procedures either to get the data or to add/update/delete the records for one or multiple database tables. EF API creates a function instead of an entity in EDM for each stored procedure and User-Defined Function (UDF) in the target database.

Can we use stored procedure in entity Framework Core?

You can execute SP using FromSql method in EF Core in the same way as above, as shown below.


1 Answers

You can overcome this scenario by replacing:

using System.Data.Objects; 

With:

using System.Data.Entity.Core.Objects; 

You may need to update the using statements in your T4 templates, like your Context.tt file, so that auto-generated files continue to work when re-generating.

Before

enter image description here

After

enter image description here

like image 59
Chris Schiffhauer Avatar answered Sep 21 '22 01:09

Chris Schiffhauer