EntityFramework 6.1.2 Support

EntityFramework 6.1.2 Support

Postby BGrojer » Tue 20 Jan 2015 15:42

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?
BGrojer
 
Posts: 16
Joined: Thu 19 Sep 2013 12:35

Re: EntityFramework 6.1.2 Support

Postby Shalex » Wed 21 Jan 2015 15:58

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.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Re: EntityFramework 6.1.2 Support

Postby BGrojer » Thu 22 Jan 2015 09:10

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.
BGrojer
 
Posts: 16
Joined: Thu 19 Sep 2013 12:35

Re: EntityFramework 6.1.2 Support

Postby Shalex » Fri 23 Jan 2015 13:47

Please give us the following information:
1) the exact text of the error and its call stack
2) the generated SQL which fails to execute (for this, enable dbMonitor)
3) send us a small complete test project with the corresponding DDL script
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Re: EntityFramework 6.1.2 Support

Postby BGrojer » Mon 02 Feb 2015 09:47

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
BGrojer
 
Posts: 16
Joined: Thu 19 Sep 2013 12:35

Re: EntityFramework 6.1.2 Support

Postby Shalex » Mon 02 Feb 2015 14:58

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.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Re: EntityFramework 6.1.2 Support

Postby Shalex » Wed 18 Feb 2015 13:14

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: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle