.any in subquery. older dotconnect version.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 2
Joined: Wed 08 Jun 2016 06:43

.any in subquery. older dotconnect version.

Post by jgoodlet » 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.

Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: .any in subquery. older dotconnect version.

Post by Shalex » Fri 10 Jun 2016 12:56

We cannot reproduce the issue with dotConnect for Oracle v6.30.185 as well.

Please send us a small test project with the corresponding model so that we can reproduce the error with v6.30.185 and check v9.1.35.

In case of >2MB attachment, we recommend either using some file exchange server (send us the corresponding link) or uploading a test project to our FTP server (the credentials will be provided by email request).

Post Reply