OUTER APPLY is not supported by MySQL

Question

I am using Entity Framework with MySQL. The following query results in an error:

var foobar = ctx.ArticleBase.OfType<ActicleSpecial>().Include("CreatedBy.Image.Location").ToList();

Error: "OUTER APPLY is not supported by MySQL" I also get "CROSS APPLY is not supported by MySQL" on a slightly different request.

I have the following data model:

Except that the Image entity has a Location entity (one-to-many) with the name Location location, and UserBase has an Image relationship instead of UserSpecial.

Why am I getting this error? How to avoid this error? Is it possible?

Answer 1

If this error comes from MySQL, one of two things happened:

• .
• EF .

MySQL EF, :

• .
• EF .

SQL . SQL- SQL- ProviderManifestToken EDMX. SQL, .

, MySQL SQL, . , , ProviderManifestToken, .

, , SQL. , , , .

: @Devart , , - MySQL. EF ADO.NET. , SQL. EF / node CCT, , Devart SQL, MySQL. , MySQL EF, -, MySQL ( !), Devart, MySQL- SQL, cross/outer CCT.

Answer 2

Entity Framework. , , SQL Server. , MSDN.