Hello,

I am migrating a rather old project from 2.6 straight to 5.7

I would need help with building the dynamic relations. So in the old code I have things like this:

IEntityRelation rb = new EntityRelation(RelationType.OneToMany);
rb.StartEntityIsPkSide = true;
rb.AddEntityFieldPair(CorporationHierarchyListItemFields.UnitID, AccountFields.BusinessUnitID);
rb.InheritanceInfoPkSideEntity = InheritanceInfoProviderSingleton.GetInstance().GetInheritanceInfo("CorporationHierarchyListItem", false);
rb.InheritanceInfoFkSideEntity = InheritanceInfoProviderSingleton.GetInstance().GetInheritanceInfo("AccountEntity", true);
filter.Relations.Add(rb, JoinHint.Inner);

So basically it's an inner join between a view and a table.

I'd guess I need to convert this to DynamicRelation? but then I could not figure out how to do it if one part is a view?

Thanks, Artem

You can map the view to an entity. And thus you would be able to build this dynamic relation, or define it in the LLBLGen Pro Designer, so you don't need to create it in code.

In v5 we also have 2 additional query systems, Linq and QuerySpec which make it much easier to write queries than the low-level API you're using in v2

Thanks!

Yep, we are about 10 years late, so we have quite some catch up to do

Mapping the view to the entity -> yep, thanks, works. It looks like although the project is using v2.6 most of the concepts are from 1.0, so I just need to manually change all those things.

Linq and QuerySpec -> yep, looking into them, the code is much cleaner, very nice; I guess the existing stuff we might leave as it is, but the new code we start writing using one of these.

Thanks guys