Ramifications of DbSet.Create versus new Entity()

by

A scenario where using DbSet<T>.Create() makes sense is attaching an existing entity to the context and then leverage lazy loading of related entities. Example:

public class Parent
{
    public int Id { get; set; }
    public virtual ICollection<Child> Children { get; set; }
}

public class Child
{
    public int Id { get; set; }
    public string Name { get; set; }
}

The following would work then:

using (var context = new MyDbContext())
{
    var parent = context.Parents.Create();
    parent.Id = 1; // assuming it exists in the DB
    context.Parents.Attach(parent);

    foreach (var child in parent.Children)
    {
        var name = child.Name;
        // ...
    }
}

Here lazy loading of children is triggered (perhaps with resulting empty collection, but not null). If you’d replace context.Parents.Create() by new Parent() the foreach loop will crash because parent.Children is always null.

Edit

Another example was here (populating a foreign key property of a new entity and then getting the navigation property lazily loaded after the new entity is inserted into the DB): Lazy loading properties after an insert

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  3. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  4. How do I detach objects in Entity Framework Code First?
  5. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  6. How to include a child object’s child object in Entity Framework 5
  7. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  8. Entity framework code-first null foreign key
  9. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  10. Entity Framework 4.1 default eager loading
  11. How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
  12. EF Code First DBContext and Transactions
  13. How to update not every fields of an object using Entity Framework and EntityState.Modified
  14. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  15. EF 4.1 loading filtered child collections not working for many-to-many
  16. Entity Framework Validation confusion – maximum string length of ‘128’
  17. Using the Entry().CurrentValues.SetValues() is not updating collections
  18. Entity Framework Code First Many to Many Setup For Existing Tables
  19. EF Core Second level ThenInclude missworks
  20. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  21. EF5 Code First Enums and Lookup Tables
  22. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  23. How can I delete 1,000 rows with EF6?
  24. When should I call SaveChanges() when creating 1000’s of Entity Framework objects? (like during an import)
  25. How to exclude one table from automatic code first migrations in the Entity Framework?
  26. SQL Server Express connection string for Entity Framework Code First
  27. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  28. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  29. How can I disable migration in Entity Framework 6.0
  30. Many to Many Relationships not saving

Leave a Comment