LINQ using FirebirdClient produces invalid query when using INCLUDE and SKIP
together
-------------------------------------------------------------------------------------
Key: DNET-405
URL: http://tracker.firebirdsql.org/browse/DNET-405
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.7
Environment: Windows
Reporter: NoPyGod
Assignee: Jiri Cincura
this
var ingredients = (from ing in db.Ingredients.Include(c => c.Recipe) orderby
ing.ID select ing)
.Skip(20)
.Take(20)
.ToList();
creates this query:
SELECT
"Limit1"."Extent1"."ID" AS "ID",
"Limit1"."Extent1"."RECIPE" AS "RECIPE",
"Limit1"."Extent1"."NAME" AS "NAME",
"Limit1"."Extent2"."ID" AS "ID1",
"Limit1"."Extent2"."NAME" AS "NAME1"
FROM ( SELECT FIRST (20) SKIP (20) "Extent1"."ID" AS "ID1", "Extent1"."RECIPE"
AS "RECIPE", "Extent1"."NAME" AS "NAME1", "Extent2"."ID" AS "ID2",
"Extent2"."NAME" AS "NAME2"
FROM "INGREDIENTS" AS "Extent1"
INNER JOIN "RECIPE" AS "Extent2" ON "Extent1"."RECIPE" = "Extent2"."ID"
ORDER BY "Extent1"."ID" ASC
) AS "Limit1"
which is wrong, it should be "Limit1"."RECIPE" not "Limit1"."Extent1"."RECIPE"
Full details here
http://stackoverflow.com/questions/8889714/entity-framework-produces-invalid-firebird-query-when-using-include-and-skip-tog
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
