OK, I think I got everything summarized in that subject line. Here's the situation: I've got two fields in TableA that make up a unique constraint. They are then used as a foreign key in TableB. This foreign key does not generate a relation in LLBLGen, because it doesn't involve a primary key. I'd like to be able to get a collection of TableBEntity and prefetch the TableAEntity that is related via the foreign key tied to the unique constraint.

I'm using Sql Server 2005 and adapter.

Is this even possible?

Thanks.

This would be possible if you use the LLBLGen Pro Designer to set those couple of fields as the PK of the entity.

I'm having a hard time figuring out how to use the designer to make those fields the primary key. Can you point me in the right direction?

Thanks, Pete

The fields must not be nullable. Then you should be able to edit the Entity TableA and set that the two fields are Part of the Primary Key. This can be set at the bottom of the Entity Fields tab.