Hello,

I use LLBLGen Version 2.0.0.0 Final and SQL Server 2005.

Is it possible to fetch a entitycollection without data in one field?

The reason: I have to fetch a lot of entities with a byte[] field. To make the query faster, i want to fill the byte[] field on demand. Moreover the collection i have to fetch is a Subcollection. Therefore I use the prefetchpath. I tried to solve theproblem with a resultsetfields-collection, but then i dont't know how i associate the subcollection with the maincollection.

I'll be glad about each answer.

best regards andre

Look at the features list of the version 2.5.

If your not ready to jump to 2.5 yet you could:

1. remove the byte[] field from the entity in the designer.
2. create a new entity on the same table which would contain the PK field(s) and the byte[] field.
3. map the new "byte" entity to the original entity using a 1:1 relation.
4. create a heirarchal relation between them so the "byte" entity is a super type of the original.

another option would be to use projections to fill a collection. this is alot more code each time to fetch a collection, but it is an option.

Thanks for the fast answers.

I'll try to create a new entity. I think this would the best way at the moment.

@arschr: sry for my stupidity, but where can I find the feature list of v2.5?

Hi,

You can find a list of features of version 2.5 here:

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=8811

Cheers