Bad SQL select generated after upgrade from EF5 to EF6

Bad SQL select generated after upgrade from EF5 to EF6

Postby McMlok » Mon 02 Feb 2015 09:33

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
McMlok
 
Posts: 20
Joined: Tue 04 Jun 2013 13:01

Re: Bad SQL select generated after upgrade from EF5 to EF6

Postby McMlok » Mon 02 Feb 2015 12:18

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.
McMlok
 
Posts: 20
Joined: Tue 04 Jun 2013 13:01

Re: Bad SQL select generated after upgrade from EF5 to EF6

Postby Shalex » Mon 02 Feb 2015 16:19

That is correct. Please use a workaround with EF 6.1.1. We will notify you about the results of our investigation.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Bad SQL select generated after upgrade from EF5 to EF6

Postby Shalex » Wed 18 Feb 2015 13:22

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:
Code: Select all
Install-Package EntityFramework -Version 6.1.3-rc1-40216 -Source https://www.myget.org/F/aspnetwebstacknightly -IncludePrerelease
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle