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)
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)
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);