OUTER APPLY is not supported by MySQL.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
klaygomes
Posts: 2
Joined: Thu 09 Feb 2012 22:33

OUTER APPLY is not supported by MySQL.

Post by 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?

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Post by 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.

klaygomes
Posts: 2
Joined: Thu 09 Feb 2012 22:33

Post by 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.

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Post by 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.

Post Reply