✅ EF Core Junction Tables with seperate columns
In EF Core:
I have entity X which has a list of Item Y
(This will let EF Core make a junction table to represent the many to many relationship)
Now as per my requirements I needed to add a Price to that junction table. So that the price only exists when and if there is a link between X and Y.
So I manually made the junction entity XY and added a single item of X and a single item of Y along with ints for their ID's and I added a decimal price.
Now my question is: Is this the correct way to add columns to Junction tables?
I have entity X which has a list of Item Y
(This will let EF Core make a junction table to represent the many to many relationship)
Now as per my requirements I needed to add a Price to that junction table. So that the price only exists when and if there is a link between X and Y.
So I manually made the junction entity XY and added a single item of X and a single item of Y along with ints for their ID's and I added a decimal price.
Now my question is: Is this the correct way to add columns to Junction tables?
