C# Entity Framework: Update Only First Batch Records and Stop

Question

Is there way with EF Core Bulk extensions to only update first few 10000 rows? write message, update next batch, write message in loop until complete?
I know there is Batch Size, however if there is only 5 million to update, and I want only update a certain amount, write a message, in continual loop until complete, how can this be done?
Should I use Top or Take?
I want to write "Hello", every few batches.
while {

await _dbContext.Set<Product>()
    .Where(x => x.Manufacturer == "ABC Company" &&
                x.StartYear == 2019 &&
                x.ProductType.ProductTypeDescription == "Electronics")
    .BatchUpdateAsync(x => new Product(){
                Manufacturer = "XYZ Company",
                StartYear = 2020 });

Console.WriteLine("hello"):

https://github.com/borisdj/EFCore.BulkExtensions
Using EF Core 3.1.
Company does not want to use SignalR

David Browne - Microsoft · Accepted Answer

It looks like BatchSize is only used for bulk insert.  For update the expression is translated to a single SQL UPDATE statement, which doesn't operate by "batches".

Asherguru · Answer

Try this.

if loop until first few 10,000

int iEnd = 5;

for (var i = 0; i <= iEnd; i++)
{
    var products = await _dbContext.Set<Product>().Where(x => x.Manufacturer == "ABC Company" &&
                    x.StartYear == 2019 &&
                    x.ProductType.ProductTypeDescription == "Electronics").Skip(i * 10000).Take(10000).ToList();

    products.ForEach(x =>
    {
         x.Manufacturer = "XYZ Company";
         x.StartYear = 2020;
    });
    _dbContext.Set<Product>().UpdateRange(products); // or you can use BulkUpdate here.
}

_dbContext.SaveChanges();

If loop until 5 millions.

int i = 0;
Boolean IsContinue = true;
while (IsContinue)
{
     var products = await _dbContext.Set<Product>().Where(x => x.Manufacturer == "ABC Company" &&
                x.StartYear == 2019 &&
                x.ProductType.ProductTypeDescription == "Electronics").Skip(i * 10000).Take(10000).ToList();

     if (products.Count() == 0)
          IsContinue = false;
     else
     {
          products.ForEach(x =>
          {
                x.Manufacturer = "XYZ Company";
                x.StartYear = 2020;
          });
          _dbContext.Set<Product>().UpdateRange(products); // or you can use BulkUpdate here.
      }
      i++;
}

_dbContext.SaveChanges();

Answered by Asherguru on August 29, 2020

C# Entity Framework: Update Only First Batch Records and Stop

2 Answers

if loop until first few 10,000

If loop until 5 millions.

Add your own answers!

Related Questions

What is a configmap cache?

Main Thread Checker Error: Double to UILabel Fails Swift

How to model class in order to serialize Dart Object (Map) into JSON in Flutter?

Can’t create bitmap without Color space android

Create a type of corresponding key/value pairs in TypeScript

Gradle. Running tests in parallel from one Class

React useEffect warning to put missing dependency. But dependency value changes in the hook

How to solve the Errors when reading .csv file into array with Python

How to Copy Column data from one table to another table in MySql?

fetch id who have register all adv

Is there a better way to write this snippet in python?

How to set if-else statement in a React function Return()?

How to convert three lists to dicts where keys are taken from a Cartesian product of the first two lists and the values are from the third list

Check if the next item is 1 unit longer (Javascript)

adding onclick to an array of items

JQuery Nice-Select’s selected text overflowing out of the dropdown when width is fixed or 100%

How to make sure only 1 thread is running? C++

Understanding the operator “less” or “greater” in assigning value with C++

Is it possible to use std::char_traits in constant expressions before GCC 8?

How to give more than 3 color in a gradient property such that 2 mixed well in 50% and 1 will show in 50%?

Ask a Question