Reputation:
SELECT * FROM sometable where a=1 and (a=2 or (b=1 and c=2))
How can I build a query I need? (no inlinequery)
Upvotes: 1
Views: 97
Reputation: 8677
DB.Select().From(sometable.Schema)
.Where(sometable.a).IsEqualTo(1)
.AndExpression(sometable.a).IsEqualTo(2)
.OrExpression(sometable.b).IsEqualTo(1)
.And(sometable.c).IsEqualTo(2);
Upvotes: 1