Entity Framework Delete Performance

Question

I have a Concept table of about 1000 rows that I would like to clear out along with all of its descendent rows in the Attribute table (There should only be one attribute row per concept). Calling save changes below takes about 2 minutes, is there any optimization I can do to the code below, or do I need to write a stored prodcedure.

 public static void RemoveConcepts()
 {
  using (var ve = new DataModel())
  {
   foreach (var concept in ve.Concepts)
   {
    if (concept.Thesaurus != null)
    {
     concept.Thesaurus.Concepts.Remove(concept);
    }
    concept.Thesaurus = null;
    concept.Attributes.Load();
    concept.Attributes.Clear();
    ve.DeleteObject(concept);
   }
   ve.SaveChanges();
  }
 }

Data Model http://img504.imageshack.us/img504/9604/datamodel.png

Craig Stuntz · Accepted Answer · 2010-02-04 19:57:51Z

2

If you have a cascade on the attributes, then you won't need to load/clear them. That probably accounts for most of the performance issue you're having.

answered Feb 4, 2010 at 19:57

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework Delete Performance

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related