I apologize if this has been asked and answered before.
We have a TypedView that contains many columns. We wish to use any of these columns in the search filter, but return only a distinct subset of the columns to the application.
For example, if the view V contains columns A,B,C,D,E then we may want to execute a query such as
SELECT DISTINCT A,B,C FROM V WHERE D=1 AND E=2
Is this possible in LLBLGen version 1? If not, is it possible in version 2?