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)