Linq to EF .Clear() does not clear

Question

EntityCollection.ToList().Clear()

Does not clear the entity collection. Any idea why?

Any solution?

How should i clear the EntityCollection?

score 4 · Accepted Answer · edited May 02 '12 at 07:38

4

Because ToList() creates a copy of the EntityCollection as a List<T> and then you just clear that list and not the EntityCollection itself.

Edit 1: Use the Clear() method from EntityCollection: http://msdn.microsoft.com/de-de/library/bb302707.aspx

Edit 2: Oh I see. So it's this class: http://msdn.microsoft.com/de-de/library/ff422654(v=vs.91).aspx ? Seems you have to enumerate all items and delete them one by one.

foreach( var item in EntityCollection.ToList() )
    EntityCollection.Remove(item);

Here you need ToList() to create a copy because most of the collection classes don't like it when you delete items from them during enumeration.

edited May 02 '12 at 07:38

mattytommo

answered May 02 '12 at 05:45

Torben Schramme

EntityCollection does not have Clear() – ove May 02 '12 at 05:50
As I said with the Clear() method from EntityCollection. Just postet the msdn link. – Torben Schramme May 02 '12 at 05:50
The EntityCollection is part of this namespace: System.ServiceModel.DomainServices.Client.Entity .. DO not have Clear() – ove May 02 '12 at 05:53
Then it's not the ADO.NET EF although the classes have the same name and simelar members. Think about retagging your question with http://stackoverflow.com/questions/tagged/wcf-ria-services – Torben Schramme May 02 '12 at 06:10

score 0 · Answer 2 · answered May 02 '12 at 05:45

0

ToList() generates a new list (you are clearing that).

answered May 02 '12 at 05:45

ChristopheD

2 Answers2