Creating bitwise operator in LINQ to SQL?

Question

I want to get this query at last:

 select * from tableName where columnName & 2 = 2 and columnName & 4 = 4

How can I use LINQ to generate this script?

Answer 1

You can do bitwise operations in C# ( and in LINQ queries ) with either & or | depending on what bitwise operation you want.

var query =
            from row in context.tableName
            where (row.columnName & 2) == 2 && (row.columnName & 4) == 4
            select row

Answer 2

var query = from r in context.tableName 
    where r.columnName & 2 == 2 and r.columnName & 4 == 4
    select r;