I've to correct Aurelien, because both are possible.
BaileyK83 wrote:
Before I duplicate code is there anything in LLBL that would:
1.) take a string (like from a sql WHERE statement) and produce a predicate expression
OR
2.) Can you attach a sting sql where statement to an entity collection fetch?
You can create custom where fragments by using your own class which derives from Predicate and in which you simply output the SQL fragment in the ToQueryText method override. Then in your code, you simply use instances of that class and add these instances to the predicateexpression used in the fetch.
You can also attach Sql fragments by overriding OnFetchEntityCollection in a derived class of DataAccessAdapter (if you're using adapter of course) or a partial class of DataAccessAdapter, and add the sql there, or call to a method which knows which sql fragment to add to the query.