This is a migrated thread and some comments may be shown as answers.

Vertical Inheritance Identity in Domain Model

1 Answer 22 Views
Design Time (Visual Designer & Tools)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Karlkim Suwanmongkol
Top achievements
Rank 1
Karlkim Suwanmongkol asked on 17 Sep 2010, 07:45 PM
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

1 Answer, 1 is accepted

Sort by
0
Accepted
Zoran
Telerik team
answered on 22 Sep 2010, 04:47 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Design Time (Visual Designer & Tools)
Asked by
Karlkim Suwanmongkol
Top achievements
Rank 1
Answers by
Zoran
Telerik team
Share this question
or