Vertical Inheritance Identity in Domain Model

2 posts, 1 answers
  1. Karlkim Suwanmongkol
    Karlkim Suwanmongkol avatar
    41 posts
    Member since:
    Aug 2012

    Posted 17 Sep 2010 Link to this post

    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?

  2. Answer
    Zoran avatar
    534 posts

    Posted 22 Sep 2010 Link to this post

    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. 

    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
  3. DevCraft banner
Back to Top