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?

@Henk, in SQL you don't use double ==. See SQL WHERE caluse information here and the operator section: w3schools.com/sql/sql_where.asp — Filip Ekberg
– Filip Ekberg, Commented Jul 5, 2011 at 11:13
@flip: But I think this is C# (LINQ), it pays to be clear about that. — Henk Holterman
– Henk Holterman, Commented Jul 5, 2011 at 11:18
@Henk, you don't do select * from in LINQ. It's from x in. — Filip Ekberg
– Filip Ekberg, Commented Jul 5, 2011 at 11:19

Coding Flow · Accepted Answer · 2011-07-05 11:48:11Z

11

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

edited Jul 5, 2011 at 11:48

Coding Flow

21.9k6 gold badges68 silver badges84 bronze badges

answered Jul 5, 2011 at 11:12

Filip Ekberg

36.3k20 gold badges129 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Justin Morgan Over a year ago

Will this run on the app server or the DB server, though?

Filip Ekberg Over a year ago

@Justin, LINQ is evaluated to SQL in the end, so AFAIK it will run on the SQL Server. As long as you dont have context.tableName.ToList() instead, which would make it LINQ to Object instead of LINQ to EF / SQL.

Patrick McDonald · Accepted Answer · 2011-07-05 11:13:29Z

2

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

answered Jul 5, 2011 at 11:13

Patrick McDonald

65.7k14 gold badges114 silver badges129 bronze badges

Collectives™ on Stack Overflow

Creating bitwise operator in LINQ to SQL?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related