A method which always works regardless of the provider is to build the whole SQL statement dynamically using expressions.

I always use that approach and so far...so good.

-Jamie