Inheritance with only one known discriminator

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 1
Joined: Fri 01 Apr 2016 06:49

Inheritance with only one known discriminator

Post by patahel » Fri 01 Apr 2016 07:15

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

Site Admin
Posts: 8240
Joined: Thu 14 Aug 2008 12:44

Re: Inheritance with only one known discriminator

Post by Shalex » Fri 01 Apr 2016 12:49

Sorry, but your question exceeds the goals of our support. The Devart ADO.NET Providers for Clouds product line ( doesn't include a connectivity solution for Sage OfficeLine.

Post Reply