Have you needed to do a complex where clause with a query, but didn’t want to write raw SQL? That’s where SubSonic expression constraints come in handy. Say you want to do something like:
Using SubSonic 2.1, you can do the following:
List<Product> products = DB.Select().From<Product>()
Basically, the AndExpression part translates to a SQL "and" operator followed by a beginning parentheses. The CloseExpression translates to the closing parentheses. Theoretically, you could nest these bad boys as deep as you’d like. Note: SubSonic also comes with an OrExpression as well.
Hope this helps