Multiple where clauses

ServiceStack.OrmLite
1

Hello,

Is there any way to achive this:

Select *
FROM A JOIN 
     B JOIN
	 C JOIN
	 D
WHERE ((B.b = 1 AND C.c = 1) OR A.a = 1) AND D.d = 2

I’ve been struggling with .Where().And().Or() but i can’t seem to find a way to get there.

EDIT:

q.WhereExpression = $"WHERE ({q.WhereExpression.Remove(0,5) })";

I achieved this with this hack however i don’t know if this will end up messing sth else.

Thanks in advance

2

I would think something like:

.Where<A,B,C>((a,b,c) => (b.b == 1 && c.c == 1) || a.a == 1))
.And<D>(d => d.d == 2);
3

Thank you very much.
I had older version and it supported only two < A, B> inside where…