Entity Framework 4 Multiple Object Delete(RemoveAll)

Question

I read that the new Entity Framework will include a method to delete multiple items (Linq to SQL has DeleteAllOnSubmit()) but I can't find the function/method to do that.

Is this in Beta 2 or do I have to make my own?

UPDATE:

This is what I'm using now:

    public void DeleteObjects(IEnumerable<object> objects)
    {
        foreach (object o in objects)
        {
            DeleteObject(o);
        }
        SaveChanges();
    }

possible duplicate of Bulk-deleting in LINQ to Entities

Danny Varod
– Danny Varod

2012-01-15 23:30:38 +00:00
Commented Jan 15, 2012 at 23:30 — Danny Varod
– Danny Varod, Commented Jan 15, 2012 at 23:30

Shiraz Bhaiji · Accepted Answer · 2009-11-28 23:30:08Z

8

EF 4 allows you to execute TSQL statements against an object context:

   using (var context = new EntityFrameworkExampleEntities())
    {       
     var count = 
         context.ExecuteStoreCommand(@"DELETE FROM Companies WHERE [CompanyID]=4");            
    }

See the following blog for details.

http://blogs.microsoft.co.il/blogs/gilf/archive/2009/11/25/execute-t-sql-statements-in-entity-framework-4.aspx

answered Nov 28, 2009 at 23:30

Shiraz Bhaiji

65.7k37 gold badges149 silver badges260 bronze badges

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

3 Comments

Omar Over a year ago

Is there a drawback to my function?

Anders Fjeldstad Over a year ago

The drawback would be that all of your objects are held in memory during the removal. If you wanted to delete a large batch of objects that you haven't already loaded from the database, they would all be loaded into the application before they were deleted.

mhenry1384 Over a year ago

Ick. To quote the article you link to, "This ability should only be used in cases that Entity Framework doesn’t support something that you need." EF does support deleting multiple objects, call DeleteObject() and then SaveChanges() (or do this stackoverflow.com/a/870081/24267).

beezler · Accepted Answer · 2013-05-30 10:51:31Z

0

I know this is late, but I found this post and found a simpler solution, that wasn't posted. You can set OnDelete to Cascade in the Association properties. In VS2012 open the edmx file. Click on the association and you'll find the OnDelete in the Properties tab. Then you can use the Remove() method with no triggers or any other special handling.

answered May 30, 2013 at 10:51

beezler

6466 silver badges18 bronze badges

Collectives™ on Stack Overflow

Entity Framework 4 Multiple Object Delete(RemoveAll)

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related