public async Task <World[]> LoadMultipleUpdatesRows(int count)
{
IDictionary <string, object> parameters = new ExpandoObject();
using (var db = _dbProviderFactory.CreateConnection())
{
db.ConnectionString = _connectionString;
await db.OpenAsync();
var results = new World[count];
for (int i = 0; i < count; i++)
{
results[i] = await ReadSingleRow(db);
}
for (int i = 0; i < count; i++)
{
var randomNumber = _random.Next(1, 10001);
parameters[$"@Random_{i}"] = randomNumber;
parameters[$"@Id_{i}"] = results[i].Id;
results[i].RandomNumber = randomNumber;
}
await db.ExecuteAsync(BatchUpdateString.Query(count), parameters);
return(results);
}
}
public async Task <World[]> LoadMultipleUpdatesRows(int count)
{
using var db = _dbProviderFactory.CreateConnection();
db.ConnectionString = _connectionString;
await db.OpenAsync();
using var updateCmd = db.CreateCommand();
using var queryCmd = CreateReadCommand(db);
var results = new World[count];
for (int i = 0; i < count; i++)
{
results[i] = await ReadSingleRow(db, queryCmd);
queryCmd.Parameters["@Id"].Value = _random.Next(1, 10001);
}
updateCmd.CommandText = BatchUpdateString.Query(count);
for (int i = 0; i < count; i++)
{
var id = updateCmd.CreateParameter();
id.ParameterName = $"@Id_{i}";
id.DbType = DbType.Int32;
updateCmd.Parameters.Add(id);
var random = updateCmd.CreateParameter();
random.ParameterName = $"@Random_{i}";
random.DbType = DbType.Int32;
updateCmd.Parameters.Add(random);
var randomNumber = _random.Next(1, 10001);
id.Value = results[i].Id;
random.Value = randomNumber;
results[i].RandomNumber = randomNumber;
}
await updateCmd.ExecuteNonQueryAsync();
return(results);
}