legio
legio

Reputation:

how to use subsonic2.1 build a query like this

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

Answers (1)

Adam Cooper
Adam Cooper

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

Related Questions