MySQL does not support limit and IN/ALL/ANY/SOME subquery
Description
Using the Linq provider can cause invalid SQL when you try to limit your query. If you write statements that generates SQL with an IN clause and also tries to limit your result it will cause an error as MySQL doesn´t support it "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery". Without the limit the query is perfectly valid.
Maybe an inner join would be the solution in this cause instead of the IN statement
Using the Linq provider can cause invalid SQL when you try to limit your query. If you write statements that generates SQL with an IN clause and also tries to limit your result it will cause an error as MySQL doesn´t support it "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery". Without the limit the query is perfectly valid.
Maybe an inner join would be the solution in this cause instead of the IN statement
Tested: MySQL 5.5.27 & 5.0.67 .NET 4.0