Hi,
is EF 6.1.2 already supported by Version 8.4.333?
We saw quite a lot of broken queries (when includes are used) if EF 6.1.2 is used instead of 6.1.2.
Any Feedback on that?
EntityFramework 6.1.2 Support
Re: EntityFramework 6.1.2 Support
Please describe the problem you have encountered.
If the issue is caused by generating unnecessary OUTER APPLY, it should be fixed in upcoming 6.1.3: https://entityframework.codeplex.com/workitem/2612. As a temporary workaround, downgrade to 6.1.1.
If the issue is caused by generating unnecessary OUTER APPLY, it should be fixed in upcoming 6.1.3: https://entityframework.codeplex.com/workitem/2612. As a temporary workaround, downgrade to 6.1.1.
Re: EntityFramework 6.1.2 Support
A simple query with multiple includes leads to the mentioned error.
A reproduce is super simple. Just doing a query with multiple includes leads to the issue:
var query = from o in dbContext.ObjectA
.Include("A")
.Include("A.B")
.Include("AA")
.Include("BB.C)
where O.ID == 123
select o;
I generated SQL is broken. (unable to execute that in SQL developer). There is no let keyword and also no TPH or TPT mapping for the mentioned tables in place.
A reproduce is super simple. Just doing a query with multiple includes leads to the issue:
var query = from o in dbContext.ObjectA
.Include("A")
.Include("A.B")
.Include("AA")
.Include("BB.C)
where O.ID == 123
select o;
I generated SQL is broken. (unable to execute that in SQL developer). There is no let keyword and also no TPH or TPT mapping for the mentioned tables in place.
Re: EntityFramework 6.1.2 Support
Issue with DevArt Sql Generator confirmed by EF team. Reproduce provided to you guys.
Related bug on EF site could be found here:
https://entityframework.codeplex.com/workitem/2653
Related bug on EF site could be found here:
https://entityframework.codeplex.com/workitem/2653
Re: EntityFramework 6.1.2 Support
Thank you for your test project.
We have reproduced the issue with incorrect SQL generation when using EFv6.1.2. We will notify you about the results of our investigation.
As a temporary workaround, please use EFv6.1.1.
We have reproduced the issue with incorrect SQL generation when using EFv6.1.2. We will notify you about the results of our investigation.
As a temporary workaround, please use EFv6.1.1.
Re: EntityFramework 6.1.2 Support
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