Batch Update Feature Request

[Ferrari_Julio]

Batch Update,Insert,delete

add feature of editing or deleting batch of objects without iterate through each object i.e. generating equivalent of "delete from accounts where balance < 0" or equivalent of "update Accounts set status='Inactive' where balance<0" also add feature of batch insertion

Sorry, I could not view the topic 60min before the solution has been posted.
I believe that by "without iterations" he meant something like:

manager.BatchRemove<TAccount>.Where(Linq['Balance'] < 0);

and/or

manager.BatchUpdate<TAccount>
  .Set('status','inactive')
  .Set('CurrValue', Linq['OpeningValue'])
  .Set('StateChangeTime', now)
  .Where(Linq.LessThan('balance', 0));

[wlandgraf (Wagner Landgraf)]

I think such feature is already asked in this request:

Efficient DELETE operator

Please add a DELETE operator similar to the Find(<>) which allows conditions and performs an efficient delete on the database. Current workaround is to do a Find(<>) then iterate that list and do a Remove of each object. This is wasteful as we need to load the data into objects first, then delete each record separately

[Ferrari_Julio]

Thanks! I'll post this suggestion and vote!