Benchmarking data deletion methods
In this section, we write our benchmarks for measuring the performance of our deletion methods. These benchmarks will be run and analyzed in the next section:
- Add the
DeleteProductADN
method:[Benchmark] public void DeleteProductADN() { string connectionString = SecretsManager .GetSecrets<DatabaseSettings> ("ConnectionString"); AdoDotNetData adnData = new(connectionString); int recordsAffected = adnData.ExecuteNonQuery("DELETE FROM Products WHERE ProductName LIKE 'ADO.NET Product%'"); adnData.Dispose(...