nnoln

I just need to delete data by chunk. Replaced Take such like this: ``` deleted = await _context.Deals .Take(_chunkSize) .Where(w => w.ServerId == serverId) .DeleteAsync(); ``` SQL: ``` DECLARE @take...

> you should be able to delete it using filter by top 10 ids (if you have unique single-column id in this table) > > ``` > _context.Deals > .Where(_...

> @MeNoln You might also try the following: > > ```cs > deleted = await _context.Deals > .Take(_chunkSize) > .Where(w => w.ServerId == serverId) > .AsCte() > .DeleteAsync(); > ```...