Bad SQL select generated after upgrade from EF5 to EF6

[McMlok]

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]

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.

[Shalex]

That is correct. Please use a workaround with EF 6.1.1. We will notify you about the results of our investigation.

[Shalex]

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