Share Code Bytes

Look into TPT introduced in EF Core 7, this design avoids the round trip to the database when inserting into a parent table and need to use the primary key ID as a foreign Key in other tables. What it does is insert a record into a child's table with respect to the Parent. 

 - Also look into using HiLow in the EF Core 6 to generate a sequence of IDs when inserting into the parent Table the Primary Key is already known. However, it is advised that you should be really careful when using HiLow, use it if you really need it.