Is it possible to override/instruct LLBLGen to reuse parameters in the generated SQL of a query when the values are the same?

I'm hitting the 2100 limit in parameters and I could greatly reduce the numbers if all the parameters, for example, where the value was "0", all used the same "@MySharedParameter1=0", instead of dozens of parameters whose value is "0".

Any thoughts? (Currently LLBLGen 1.0.2005.1 July 6th, but will be upgrading to 2.0 as soon as I get around to refactorring over a thousand lines of code that use the EntityCollection class... )

EDIT: Well, it turns out I was recursively adding embedded predicate expressions creating an exponential growth in clauses. I figured this out using LLBLGen's Verbose debug switches. (I had 5000 parameters which was way too much...)

So this issue is less important for me know, but might be worth while anyways if it would improve performance.

It would help to know more about the scenario you are dealing with - i.e. what is the problem you are trying to solve. Can you post the code (LLBLGen code, DDL for your tables)?

adding 2000+ fieldcomparevalue predicates isn't going to perform as that query will be very slow. What exactly are you going to achieve?

What you can do is use a FieldCompareRange predicate and simply pass in a list of unique values to the predicate.

If you are adding the same expressions to multiple parts of the query, you can benefit from query text caching.

Otis, just helped me with this scenario and the class to help with that is posted here:

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8403