I have a hierarchy setup as follows:

Product <- SubProductA Product <- SubProductB

Is there any way I can determine the type of a product using the productId without actually completely loading the entity?

Cheers,

Peter

Assuming you've already fetched the product entity and trying to get subProduct entity Type:

are we talking M:N or M:1 relationship? If the former, I'd think you could prefetch the relationship table (subProductsInProducts tbl) and include a productType column. (Which I'll assume you will use as a discriminator for your sub Types)

If the latter, then I guess you could place the productType column onto the product table.

Could you perhaps explain in more detail what you are looking to do?

Thanks,

If you are talking about getting the entity type w/o ANY fetch (such as id passed via url param), then you could represent the type information in the id itself. Such as:

byte (entity type) + entity id

And the called page will have to translate.

Product <- SubProductA Product <- SubProductB

Are these inheritance relations? which inheritance type?

If you have the id only and no entity is loaded, then you can't determine the type unless accessing the database. Unless the id is well formatted to implecitly include the type

Hi Walaa.

Just a quick follow up on this - does the adapter.FetchEntity method perform polymorphic fetches?

Cheers

Pete

Hi Pete,

This is how Polymorphic Fetches works: LLBLGenPro Help - Using the generated code - Adapter - Using the entity classes - Polymorphic fetches