Hi guys,

Am trying to generate some sql that does the following:

Select * from Product 

Where (1 = 1)

And ( dynamic clause 1)

And ( dynamic clause 2)

There maybe 0 dynamic clauses, there maybe many dynamic clauses and the ones included will be different for each query.

How can I create a PredicateExpression that will output as '1 = 1'? Or is there some over way to handle this?

Cheers,

Pete

Well in case of 0 dynamic clauses, all you have to do is to use no predicate expression with the fetch method.

Yes but if I can't use a '1 = 1' style predicate, I have to track whether I have added a predicate so I know whether to use .Add() or .AddWithAnd()

Am currently using a ProductId > 0 predicate as it always true but I don't know, it feels hacky

Pete

the .AddWithAnd method works in both cases (empty predicateExpression and non-empty predicateExpression) so you could use it no mather the number of existing clausses. Conclusion: you don't have to include an "1 = 1" clause

in fact, 'Add()' does an AddWithAnd

And that would be jsut what i wanted to hear. Cheers guys

Pete