EF Core 10 ships first-class LeftJoin and RightJoin operators, named query filters you can disable individually, complex types mapped to JSON, and native vector search for RAG - a tour of what actually changes day to day.
EF Core can map a C# class hierarchy to the database three different ways - one shared table, a table per class with joins, or a table per concrete type. Here is how each one looks on disk and which to pick.