Hi,

Is it possible to join a view with a table? I am using Adapter.

Thanks.

Yes, use the LLBLGen Pro designer as follows: 1- First you should map the view to an Entity. 2- Then go to the entity's Edit/properties and on the relations tab you can define the custom relation , using one of the "Add new custom... relation" buttons. Please refer to the LLBLGen Pro manual "Using the designer -> Adding custom relations"

Is it possible to do it programmatically instead of designer? For example, I am using the following codes to join two tables without FK relations?

Dim rel As New EntityRelation(RelationType.ManyToMany) rel.AddEntityFieldPair(New Address().Fields(AddressFieldIndex.ZipCode), New ZipCode().Fields(ZipCodeFieldIndex.ZipCode)) rel.AddEntityFieldPair(New Address().Fields(AddressFieldIndex.City), New ZipCode().Fields(ZipCodeFieldIndex.City)) bucket.Relations.Add(rel, JoinHint.Inner)

I want to do something similar for the table/view join.

Thanks.

The similar is possible, but first you will have to have the view mapped to an entity.

Then you just can treat it as an entity/table.