We have a search screen in the UI where the user enters data and then the code should build a dynamic query to fetch the results.
In pre-LINQ era, this was done by building a filterBucket for any of the dirty UI controls and then sending this filterBucket to the BL to fetch the results.
In building the filterBucket, handling the Like operator was trivial as that is supported directly in LLBL's filtering syntax.
When trying to do the same with LINQ, we tried using the LINQ functions StartWith, EndsWith, and Contains instead of LLBL's Like. The problem is this would not support such cases when the text being filtered looks like "firstName%LastName" or "firstName%middleName%anotherMiddleName%LastName"
Is there a way to have the same support (or simulate that support) for LIKE in LLBL's filtering syntax to be also in LLBL's LINQ ?