none
entityframework vs sql query RRS feed

  • Question

  • hello everyone, I wanted to know why there is a noticeable difference in performance between executing a command from sql server managament and send by EntityFramework? 

    If I have a list with 5000 records if I run the command from EntityFramework:

    var widgets = context.Widgets.toList();
    
    foreach (Widget widget in widgets)
    {
        context.Widgets.DeleteObject(widget);
    }
    context.SaveChanges();

    so takes about a 3 minute.

    however, if I run it from sql managemnt studio this query:

    Delete from Widgets

    Tuesday, June 17, 2014 11:39 AM

Answers

All replies