Add object list to DB context in Entity Framework

Question

Add object list to DB context in Entity Framework

asp.net asp.net-mvc entity-framework entity-framework-5 entity-framework-6

Question

Here is one approach where we can add items in database context one by one for save data.

  List<AuditTrails> auditLogs= new List<AuditTrails>();

  foreach (AuditTrail a in auditLogs)
  {
      if (a.Operation == CreatedBy)
      {
         if (!string.IsNullOrEmpty(a.NewState))
             context.AuditTrails.Add(a);
      }
      else
         context.AuditTrails.Add(a);
  }
  context.SaveChanges();

Is there any way to do without Loop? I am working with Entity Framework 6. `

Rizwan Shahid

Popular Answer

Technically, no, but you can, I think, get the gist of what you're looking for via the ForEach method of List.

auditLogs.Where(a =>
    (a.Operation == CreatedBy && !string.IsNullOrEmpty(a.NewState)) || 
    a.Operation != CreatedBy
).ToList().ForEach(a => context.AuditTrails.Add(a));

Chris Pratt

View more on Stack Overflow

octavioccl · Accepted Answer · 2/18/2015 5:27:30 PM

Also, you can use the AddRange method, but first you have to filter your collection as @ChrisPratt suggests in his answer:

var elementsToBeAdded=auditLogs.Where(a => (a.Operation == CreatedBy && !string.IsNullOrEmpty(a.NewState)) || 
                                            a.Operation != CreatedBy);
context.AuditTrails.AddRange(elementsToBeAdded);

If AutoDetectChangesEnabled is set to true (which is the default), then DetectChanges will be called once before adding any entities and will not be called again. This means that in some situations AddRange may perform significantly better than calling Add multiple times would do. Note that entities that are already in the context in some other state will have their state set to Added. AddRange is a no-op for entities that are already in the context in the Added state

Add object list to DB context in Entity Framework

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Performance

Expression Evaluator

Related