...maybe I just haven't found it in the docu, but...

Well, I would like to setup an inheritance hierarchy based on several views, rather than tables .

Everything works fine with the foreign key 1:1 relationship using a table as sub-type. But how do I tell my MSSQL2005 to setup a foreign key constraint on a view?

Or is there another way to tell LLBLGen that a view is meant to be a sub-type in a heirachy?

Any help would be appreciated.

Thank you.

Alles Gute.

As far as I know, the inheritance features of LLBLGen Pro are limited to real tables only.

• Map an entity onto the view
• Specify in the designer a PK field (or fields) for the entity
• define the relation (custom relation) in the designer.
• create the hierarchy

Yepp, this works. Thanks a lot.

Alles Gute