Inheritance with only one known discriminator
Posted: Fri 01 Apr 2016 07:15
Hi
I've to write a data acces layer to an existing database. Most of the tables store a column, which identifies the coresponding "user". But it is never really referenced trough foreign keys. The table which contains the "user" is a multipurpuse/parameter (string) table. May you know the database from Sage OfficeLine.
Table which stores the "users" and all sort of other strings: KHKMandanten
If the row is storing a "user" the Description column is storing "Mandant", every other value is unknown, because it is storing different parameters for the user.
How do I create a entity for the Table and one for the User (which ofcourse contains navigation properties)
Best regards
patahel
I've to write a data acces layer to an existing database. Most of the tables store a column, which identifies the coresponding "user". But it is never really referenced trough foreign keys. The table which contains the "user" is a multipurpuse/parameter (string) table. May you know the database from Sage OfficeLine.
Table which stores the "users" and all sort of other strings: KHKMandanten
Code: Select all
SettingId (int, key)
Year (short, key)
ClientId (short, key)
Description (varchar)
Value (varchar)
Type (short)
How do I create a entity for the Table and one for the User (which ofcourse contains navigation properties)
Best regards
patahel