Benchmarking data editing methods
In this section, we will be writing our benchmarks that test the performance of various update statements. These benchmarks will be run and analyzed in the final section of this chapter:
- Add the
UpdateProductADN
method:[Benchmark] public void UpdateProductADN() { string connectionString = SecretsManager .GetSecrets<DatabaseSettings> ("ConnectionString"); AdoDotNetData adnData = new(connectionString); int recordsAffected = adnData.ExecuteNonQuery("UPDATE Products SET ProductName = 'ADO.NET Product - &...