EntityFramework adding new object to a collection

Question

Probably this question has been answered before, if that's the case I would appreciate if you guys point me in the right direction.

I would like to know what happens when a new object is added to an EntityFramework collection.

More precisely, I'd like to know if in order to add the new object the whole collection is loaded into memory

For example:

public class MyContext : DbContext
{
    public DbSet<Assignment> Assignments { get; set; }
}

public class SomeClass
{
    public void AddAssignment(Assignment assignment)
    {
        var ctx = new MyContext();

        ctx.Assignments.Add(assignment);

        ctx.SaveChanges();
    }
}

Do all the assignment records have to be loaded into memory just to perform a simple insert???

Yusubov · Accepted Answer · 2012-12-13 20:13:46Z

5

In short: no load process of entire entity collection.

The AddObject() method is used for adding newly created objects that do not exist in the database. When AddObject() is called, a temporary EntityKey is generated and the EntityState is set to 'Added', as shown below:

enter image description here

When context.SaveChanges() is called, EF 4.0 goes ahead and inserts the record into the database. Note that Entity Framework converts the code into queries that the database understand and handles all data interaction and low-level details. Also notice in the code above, that we are accessing data as objects and properties.

After you have executed the code, you can go ahead and physically verify the record in the database.

answered Dec 13, 2012 at 20:13

Yusubov

5,8439 gold badges35 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jupaol Over a year ago

I just added a new question, could you please share your knowledge with me again =)? stackoverflow.com/q/13868030/1268570

Yusubov Over a year ago

Sure, no problem, i will look at that shortly.

Sergey Akopov Over a year ago

Funny, i'm actually looking at profiler right now and experiencing the complete opposite of what you just said. The entire collection is fetched before the new item is added.

Collectives™ on Stack Overflow

EntityFramework adding new object to a collection

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related