Linq to SQL Inheritance Question -


I think I am not sure how the Linq legacy works.

I have a "user" unit and I have two additional organizations called "Manufacturer" and "Assigned", which are the "user" unit (basically the same as the user unit) Should be attributable) I should not be deprived. I have no need Additional properties I can do this right in the designer.

The problem is that when I try to associate the entities inherited with any other entity - I do not have access to any property from the Aadhar unit. Do I not reach those people? Could have established relationships with other organizations? I feel like i need

It seems like a relationship to me rather than a legacy that these institutions are users, but some users Has a producer relationship with others and some people have an assignment relationship. Probably the simplest way to make models is to create a join table for creators and another assignment. Create a foreign key relationship back into the user table with both columns in the join table. When you drag all these tables to the surface of the designer, then each user will be created / created and assigned / assigned to the unit set. The anticipation of your DB is limited, it will be limited that each user only has one manufacturer and one user not assigned to more than one other use (or maybe not based on your rules).

  User table user_id int identity tap primary key user_name varchar .... created by_by_id int identity tap primary key manufacturer int no null, user for fk.user_id int no null, user To user_id, FK (with a unique index) can be creator / composition - or both can be PK) (compulsive manufacturer & lt; & gt; createe) assigned_to assign_to_id int identity tap primary key owner_id int tap, for user FK.user_id assignee_id int For the user, FK.user_id (with or without a unique index on the assign_id) (binding owner_id <> fixed_id - or not)  

Comments

  1. Casinos in the UK - How to find good games - GrizzGo
    So, apr casino what do we mean by “casinos in the UK”? gri-go.com to find sporting100 a casino and live casino https://sol.edu.kg/ games 출장샵 on a mobile phone device in 2021.

    ReplyDelete

Post a Comment