OUTER APPLY is not supported by MySQL.

[klaygomes]

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]

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]

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]

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.