Understanding Entity Framework Core's Join Behavior When Selecting a Single Entity Without Include() Method

Cannot Insert Explicit Value When Saving to Another Table in Entity Framework Core