Include parent and child in query?

Prevent EF from adding new child objects instead of just association when inserting new parent object?

Entities that have been disconnected and are reattached are by default in the Added state....After adding the workout, you can alter the state....public int CreateExercise(Exercise newExercise) { db.Exercises.Add(newExercise); // set all attached users to unchanged. db.ChangeTracker.Entries<User>().ToList().ForEach(p => p.State = Enti...

Entity Framework 6: Adding child object to parent's list vs. setting child's navigation property to parent

The two methods can be used interchangeably, yes. This enables you to generate and store your object graph from the viewpoint of the MailServer or the MailDomain to the database....If you use code-first development, you can decide whether or not to keep the properties and mappings....I also assume that in approach (A) the new MailDomain instance is...

How to retrieve child data, via LINQ Include, in one query, to improve performance?

There is possibly a limit on how many levels one can use "Include"? ...It exists! As I explained ...here... about the generated SQL statement -...there are 17-zzz in the...SELECT... is the total of all columns in all relevant tables....The total number of records in included kid collections is ...rows.......That might be a ...huge... (long ...and..

Return parents with null children using C# EF Core .Include

ZZZ_tmp

Add child entities to database and assign them to parent object in database Entity Framework Core

ZZZ_tmp

How to map parent=>children without navigation property on child

ZZZ_tmp

Parent - Child relation Child ID

ZZZ_tmp

Entity Framework Core Parent Child items in the same model, children node returns null

The second option is the proper one, however I have a suspicion that you are not eagerly gathering the kids while loading. Do this:...var one = context.Set<TestModel>().Include(x => x.children).FirstOrDefault(); ...Utilizing slow loading is an additional option. Check out more at ...https://docs.microsoft.com/en-us/ef/core/querying/related-data....

EF Core using navigation property when querying parent and child separatedly

ZZZ_tmp

Entityframework - Include nested children from parent

Apply the...Include... the following is a way to load many layers of linked entities:... dbContext. .Where(f => f.Id == Tenant.Id) .Include(t => t.Users.Select(un => un.Nicknames)) .Include(t => t.Users.Select(uf => uf.FavoriteMovies)) .SingleOrDefault();