How do you delete the entities after you retrieve them using linq?

I am sure I can loop throug the collection but I would prefer to delete them all at once.

I am sure this is easy at the moment I can't figure it out.

 var linqMetaData = new LinqMetaData(dataAccessAdapter);
 var q = linqMetaData.EntityIndex;
 dataAccessAdapter.DeleteEntityCollection((IEntityCollection2)q.ToList());

Noob questions. Sorry.

Bryan

When you call ToList(), it creates a List<entity> collection, it has to, ToList forces it to do that.

However as you expect: this is a copy action. So instead do: var q = ... IEntityCollection2 col = ((ILLBLGenProQuery)q).Execute();

(from my bare head so can have some typo's but the idea is to cast the q to an ILLBLGenProQuery

You can also traverse the List<T> yourself of course and call adapter.DeleteEntity() with the entity, first starting a transaction before you traverse the list.. Though that's less efficient.

That was it! Was not making the connection in my head that the result could be cast to something other then what it was. Make sense now.