I'm using LLBLGen Pro 2.5 Final with adapter and .NET 2.0/c# connecting to both SQL Server 2000 and 2005 dBs.
I have recently implemented data paging and discovered that if the FetchEntityCollection method incorporates a join then LLBL Gen will include a Distinct statement within the SQL query. If a column in my table has a data type of nText (which is not compatible with the Distinct statement) then rather than returning a fixed number of records the method will return all the records.
I have worked around a similiar scenario with the FetchTypedList method by replacing the nText data type field in the fieldCollectionToFetch with a new field incorporating a cast expression.
Can anyone tell me if something similiar is possible with FetchEntityCollection as I obviously don't have a collection of fields to modify simply an EntityFactoryToUse?
I know that there's a override on FetchEntityCollection that accepts fields to exclude but I need the nText data type field to be returned so that option isn't possible for me.
Cheers,
Chris