Deep Dive into Many-to-Many: A Tour of EF Core 5.0 pt. 2

In this episode, Arthur Vickers returns to chat some more with Jeremy about some of the new features in Entity Framework Core 5. In particular, they’ll be diving deep into the building blocks of many-to-many. You’ll see how they can be configured to allow flexible mapping and access to the underlying join table.

[01:46] - Reviewing the debug views for many-to-many
[08:00] - Under the covers of the change tracker
[10:38] - Configuring shared-type entities
[12:30] - Explicit many-to-many configuration

What's New in EF Core 5.0

Persist and retrieve relational data with Entity Framework Core

Announcing the Release of EF Core 5.0

[jesusmendoza]

Could you tell me please, how to add custom fields to association table?? On many to many relationships,
thanks very much!

[mariomorazan]

Is it possible to configure the DbSet to work as dictionary just wondering if i could save some steps by moving it to dictionary lol

[akovac]

Java world: do not make an attempt to try this, it will be a painfull realization :)

[chairmakerPete]

Many to Many. If you have one of these relationships in your schema, you've not finished the design phase. Please do not proceed to bodge up some secret-sauce solution to abstract it away; instead look for the data that potentially lies in the link entity. 9 times out of 10, it's useful and part of the system you are modelling.

Code first is for people who don't want to "waste time" on proper schema design. They'd rather just write code. Then more code to bodge round the shortfalls in schema design which not "wasting time" on the design phase has caused. Rinse and repeat. In fairness, many companies have made fortunes selling bad design then the fixes for it. Step forward Microsoft and SAP for a special award.

It's a good certain job software "engineers" (sic) don't design aircraft or automobiles.