0 Replies Latest reply on Apr 3, 2007 8:57 AM by Rabbia Qaswar

    Discriminator Column in Joined Inheritance Strategy?

    Rabbia Qaswar Newbie

      Hi

      Can anyone please tell me how to use the Discriminator Column in queries when using the Joined strategy for Inheritance?

      I have three database tables, Employee, PartTimeEmployee and FullTimeEmployee.
      For these tables i have three entities, abtract parent class Employee having two subclass entities i.e. PartTimeEmployee & FullTimeEmployee. The name of discriminator column in Employee is ETYPE.

      Now if i want to run a query in which i want to get all the PartTimeEmployee from the Employee table, how can i use the ETYPE column to differentiate between the two types of Employees so that i only get all the PartTimeEmployees?

      Thanks