Oracle BitAnd support

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
Posts: 18
Joined: Thu 22 Apr 2010 07:55

Oracle BitAnd support

Post by LordFjord » Wed 04 May 2011 14:06


I have the case to filter data depending on the value of a flagged enum, the Devart.Data.Linq.Provider throws a System.NotSupportedException: Operation is not supported: BitAnd at Devart.Data.Oracle.Linq.Provider.Query.a.a(SqlNodeType A_0)

Code Example:

Code: Select all

var result = context.MyObject.Where( x => (x.MyColumn & (int)MyFlaggedEnum.SomeValue) == 0);
Are there any plans to support BitAnd operations via LINQ? This works with the .NET System.Data.Linq library on a MS SQL database.
Also, Oracle has a builtin bitand function if i remember right.

Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 05 May 2011 10:13

Thank you for the suggestion, we will consider supporting the bitwise operations. We will post here when any new information concerning this feature is available.

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

Re: Oracle BitAnd support

Post by Shalex » Wed 27 Apr 2016 11:57

Bitwise And, Or, Xor (SQL Server / Oracle), and Not (SQL Server) operators are supported in LINQ queries for integer operands in the newest (4.5.976) build of LinqConnect.

Post Reply