OUTER APPLY is not supported by MySQL.

OUTER APPLY is not supported by MySQL.

Postby klaygomes » Fri 10 Feb 2012 01:54

That is my first try using dotconnect and I'm using 'dotConnect for MySQL' version 6.7 trial, everything was working ok, but when I try to do something like:

Code: Select all
from tp in InstanceOfCleigomeModel.threads.OfType()
select new {
   topic= tp,
   topquestions = q.Questions.Take(5)
}


that is my diagram http://screencast.com/t/6xzSVhOR7Mjb

I get this error:
OUTER APPLY is not supported by MySQL.

what i'm doing wrong?
klaygomes
 
Posts: 2
Joined: Thu 09 Feb 2012 22:33

Postby Shalex » Fri 10 Feb 2012 17:25

MySQL Server doesn't support OUTER APPLY. You should reconstruct your query in the way when there is no OUTER APPLY in the SQL which is generated by EF runtime.
Shalex
Devart Team
 
Posts: 7698
Joined: Thu 14 Aug 2008 12:44

Postby klaygomes » Mon 13 Feb 2012 01:37

Shalex wrote:MySQL Server doesn't support OUTER APPLY. You should reconstruct your query in the way when there is no OUTER APPLY in the SQL which is generated by EF runtime.


I`m afraid I cant write this query in another way.
klaygomes
 
Posts: 2
Joined: Thu 09 Feb 2012 22:33

Postby Shalex » Tue 14 Feb 2012 16:37

When constructing your LINQ to Entities queries, please take into account the following typical scenarios that might lead to the presence of CROSS APPLY and/or OUTER APPLY operators in the output query:
- A correlated subquery with paging.
- An AnyElement over a correlated sub-query, or over a collection produced by navigation.
- LINQ queries that use grouping methods that accept an element selector.
- A query in which a CROSS APPLY or an OUTER APPLY is explicitly specified
- A query that has a DEREF construct over a REF construct.
Shalex
Devart Team
 
Posts: 7698
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL