private static void UpdateEmployees(EmployeeContext context, int records)
{
var employeesToUpdate = new List <Employee>();
for (var index = 0; index < records; index++)
{
var employee = new Employee
{
Id = index + 1,
Forename = $"UpdatedTestFirstName{index + 1}",
Surname = $"UpdatedTestSecondName{index + 1}",
JoiningDate = DateTime.Now,
MiddleName = $"UpdatedTestMiddleName{index + 1}",
PayrollId = $"{index + 1}"
};
employeesToUpdate.Add(employee);
}
var updateStopwatch = new Stopwatch();
updateStopwatch.Start();
//context.Employees.UpdateFromQuery(emp => new Employee
//{
// Forename = $"UpdatedTestFirstName",
// Surname = $"UpdatedTestSecondName",
// JoiningDate = DateTime.Now,
// MiddleName = $"UpdatedTestMiddleName",
// PayrollId = $"1"
//}, op => op.BatchTimeout = 60);
context.BulkUpdate(employeesToUpdate);
updateStopwatch.Stop();
Console.WriteLine($"Total Time Taken To Update {records} records: {updateStopwatch.ElapsedMilliseconds}");
}
