Dear all,

Is there any sample on TargetPerEntity inheritance out there on SQL Server.

I've been struggling more than three hours on this and I cannot have it working properly!

I cannot have the project to validate!

My exemple is as follow

BuiltProperty->Property

House->BuiltPRoperty

Appartment->BuiltProperty

Land->Property

All table have the column ID.

It is define as primary key only on table property

I had to define Unique constrain ont he column ID on BuiltPRoperty otherwise I could not create the relations ID-ID from House and appartment to BuiltProperty...

I have also defined relation on ID-ID on land to Property and BuiltPRoperty to Property

Any help would be appreciated.

Thanks

• Those relations you created were created on database or LLBLGen?

• Please show us the DDL script of the involved entities.

• What exactly is not working? (you cant create the hierarchy, you can validate project, you cant compile code, etc.)

Thanks for your reply.

HEre it goes.

You will find the DDL files and the LLBLGEN Project File.

Please answer these questions:

• Those relations you created were created on database or LLBLGen?

• What exactly is not working? (you cant create the hierarchy, you can validate project, you cant compile code, etc.)

Well,

Regarding the relations, They are defined on the database and automaticaly generated when reverse engeneering the table to Entity. So in both places...

What does not work? Well open the llblgen project and validate. You will get two error messages. It is stating that automaticaly generated relations are missing the FK mapping values. I tried so set those values manually but I then got other errors. So I went back to the original values.

I try to change the least possible options on the LLBLGEN project and make the DDL as simple as posible to facilitate the identification of the issue.

Hope this help.

Again if you have any sample of targetperentity Inheritance on the LLBLGEN framework with the DDL that might help me resolving the issue without making you loose your time.

Thanks for your time anyway.

You don't need these relations. Please remove them from the Model.

You don't need a relation between a SuperEntity and a SubEntity.