Efficient DELETE operator

BIZ BIZ Feature Requests
1

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

2

Great! And the same for a batch update.
Maybe something like:

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

(the requested batch delete)

and

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

(batch update without iterating objects)

4 Likes