Hello,
we create project with model in EF5 now we upgrade model to EF6. Most functionality works fine but some queries generate wrong SQL select. I create sample solution with two project one with EF5 model and one with EF6. Both models has same entities and connect to same DB. EF5 project get data from DB but EF6 generate exception.
What is wrong in EF6 project?
Thanks
http://1drv.ms/1EYVIfD
Bad SQL select generated after upgrade from EF5 to EF6
Re: Bad SQL select generated after upgrade from EF5 to EF6
It looks like problem with EF 6.1.2 http://forums.devart.com/viewtopic.php?f=1&t=31133 when I downgrade EF to 6.1.1 queries run successfully.
Re: Bad SQL select generated after upgrade from EF5 to EF6
That is correct. Please use a workaround with EF 6.1.1. We will notify you about the results of our investigation.
Re: Bad SQL select generated after upgrade from EF5 to EF6
The issue is fixed in EFv6.1.3 (http://entityframework.codeplex.com/workitem/2653).
You can use the corresponding nightly build now. For this, execute the following command in your Package Manager Console:
You can use the corresponding nightly build now. For this, execute the following command in your Package Manager Console:
Code: Select all
Install-Package EntityFramework -Version 6.1.3-rc1-40216 -Source https://www.myget.org/F/aspnetwebstacknightly -IncludePrerelease