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.
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.
You can execute SP using FromSql method in EF Core in the same way as above, as shown below.
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
After
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With