.any in subquery. older dotconnect version.
Posted: Wed 08 Jun 2016 06:55
I'm running an older version of dotConnect (v6.30.185.0) and i'm trying to use the any function inside of where function
For example Item.Where(x => x.subItems.Any(y => y.subItem.Contains("subitem")));
and i'm getting back
System.NotSupportedException: Specified method is not supported.
at Devart.Data.Linq.Provider.Query.r.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.r.a(Expression A_0, LambdaExpression A_1, Boolean A_2)
at Devart.Data.Linq.Provider.Query.r.b(MethodCallExpression A_0).
at Etc...
I'm wondering if this now supported in newer versions.
Thanks
For example Item.Where(x => x.subItems.Any(y => y.subItem.Contains("subitem")));
and i'm getting back
System.NotSupportedException: Specified method is not supported.
at Devart.Data.Linq.Provider.Query.r.a(SqlNode A_0)
at Devart.Data.Linq.Provider.Query.r.a(Expression A_0, LambdaExpression A_1, Boolean A_2)
at Devart.Data.Linq.Provider.Query.r.b(MethodCallExpression A_0).
at Etc...
I'm wondering if this now supported in newer versions.
Thanks