[Solved] Vertical Inheritance Identity in Domain Model

[Karlkim Suwanmongkol]

I am doing reverse mapping on some tables on our Oracle database using Domain Model with the latest internal version (2010.2.804.5). I have two classes, A and B. A is inherited from B. I follow the steps in the comment #2 here to create inhertiance relationship. The primary key of table mapped to B (the base class) is "ID" while the primary key of the table mapped to A (the subclass) is "B_ID". 

The issue that the generated SQL has the primary key of the table mappped to A as an ID.

For example, the generated SQL is

select * FROM (SELECT A."ID", A."COL1", B."ID", B."COL1"  FROM A JOIN B ON (A."ID" =  B."ID"))

But I want the generated SQL to be like the below (notice A."B_ID")

select * FROM (SELECT A."ID", A."COL1", B."ID", B."COL1"  FROM A JOIN B ON (A."B_ID" = B."ID"))

Is it possible to do this within Domain Model Designer?

Thanks,
Karlkim

[Zoran]

Hi Karlkim Suwanmongkol,

 This appeared to be a missing functionality on our side. The only setup in which you can create vertical inheritance with the Domain Model designer is when both identity columns on both sides of the inheritance relationship have the same name e.g. both are called "id" or "b_id". Thanks for reporting this to us, we will make sure it is fixed for the Q3 2010 release. You Telerik points have been updated. 

Greetings,
Zoran
the Telerik team