.Contains() and .Any() broken in Devart.Data.MySql.EFCore 10.1.35.0
Using Microsoft.EntityFrameworkCore 10.0.5 in a .NET 10 project.
.Contains and .Any no longer work in dotConnect for MySQL.
query.Where(i => myClass.SomeListOfStrings.Contains(i.SomeField)) fails with '@request_SomeListOfStrings' in the SQL tree does not have a type mapping assigned.
In case anyone (no-one yet, really?) need a work-around: I had to modify a ton or queries with:
var myPredicate = PredicateBuilder.False<Database.Entities.MyTable>();
foreach (var strValue in myClass.SomeListOfStrings)
{
myPredicate = myPredicate .Or(i => i.SomeField== strValue);
}
and then use query.Where(myPredicate);