Page 1 of 1

Inheritance with only one known discriminator

Posted: Fri 01 Apr 2016 07:15
by patahel
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

Code: Select all

SettingId (int, key)
Year (short, key)
ClientId (short, key)
Description (varchar)
Value (varchar)
Type (short)
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

Re: Inheritance with only one known discriminator

Posted: Fri 01 Apr 2016 12:49
by Shalex
Sorry, but your question exceeds the goals of our support. The Devart ADO.NET Providers for Clouds product line (https://www.devart.com/dotconnect/#cloud/) doesn't include a connectivity solution for Sage OfficeLine.