Hello,

What is the recommended to do do a JOIN on entities in different catalogs (and .NET assemblies)?

Thanks.

so in different projects? Which framework / llblgen pro version are you using?

Sorry, I should be specifying these!

v3.0 Final NHibernate

You want to keep the entity definitions also separated? Do you use a single session with multiple assemblies?

LLBLGen Pro supports multiple catalogs, and you can define in the project multiple groups which can represent multiple vs.net projects (assemblies), so you can define the entity (e.g. 'Product') multiple times in the project (e.g. in each group) and map it to the same target. This has the advantage that when the target table changes, all the entities mapped onto it are validated against it.

We are using different (NHibernate) sessions with the multiple assemblies. The entities that we want to join are in these different assemblies. Currently, we are using LINQ to NHibernate to get the results.

In the cases where the entities were in the same assembly we use Typed Lists; so is it right that the typed lists cannot be used if the entities are in different assemblies?

You can only join entities which are in the same session factory, so if you have Customer in sessionfactory S1 with assembly A, and Order in session factory S2 with assembly B, you can't join them, using a session created on S1 or S2 as both sessionfactories don't know all the types.

thanks for the explanation