public void InsertRecords(int amount) { var entities = new List <BenchmarkEntity>(); for (var i = 0; i < amount; i++) { bool?nullableBool = null; if (i % 5 == 0) { nullableBool = false; } else if (i % 6 == 0) { nullableBool = true; } entities.Add(new BenchmarkEntity { DecimalValue = i, TextValue = i.ToString(), IntegerValue = i, NullableBoolean = nullableBool }); } var dbContext = new SqlRepoBenchmarkDbContext(); dbContext.AddRange(entities); dbContext.SaveChanges(); Console.WriteLine($"Completed inserting {amount} records"); }
static void Main(string[] args) { var services = new ServiceCollection() .AddSqlRepo(); SqlRepoBenchmarkDbContext dbContext = new SqlRepoBenchmarkDbContext(); dbContext.Database.Migrate(); services.AddSingleton <ISqlLogger, NoOpSqlLogger>(); services.AddSingleton <IBenchmarkHelpers, BenchmarkHelpers>(); services.AddSingleton <IBenchmarkOperation, SelectUpdateDeleteBenchmarkOperationDapper>(); services.AddSingleton <IBenchmarkOperation, SelectUpdateDeleteBenchmarkOperationSqlRepo>(); services.AddSingleton <IBenchmarkOperation, SelectByDecimalValueBenchmarkOperationDapper>(); services.AddSingleton <IBenchmarkOperation, SelectAllBenchmarkOperationDapper>(); services.AddSingleton <IBenchmarkOperation, SelectTop5000BenchmarkOperationDapper>(); services.AddSingleton <IBenchmarkOperation, SelectTop1BenchmarkOperationDapper>(); services.AddSingleton <IBenchmarkOperation, SelectWhereBetweenBenchmarkOperationDapper>(); services.AddSingleton <IBenchmarkOperation, SelectSingleColumnBenchmarkDapper>(); services.AddSingleton <IBenchmarkOperation, SelectByDecimalValueBenchmarkOperationSqlRepo>(); services.AddSingleton <IBenchmarkOperation, SelectAllBenchmarkOperationSqlRepo>(); services.AddSingleton <IBenchmarkOperation, SelectWhereBetweenBenchmarkOperationSqlRepo>(); services.AddSingleton <IBenchmarkOperation, SelectTop5000BenchmarkOperationSqlRepo>(); services.AddSingleton <IBenchmarkOperation, SelectTop1BenchmarkOperationSqlRepo>(); services.AddSingleton <IBenchmarkOperation, SelectSingleColumnBenchmarkSqlRepo>(); services.AddSingleton <IBenchmarkOperation, SelectAllBenchmarkOperationEfCore>(); services.AddSingleton <IBenchmarkOperation, SelectTop5000BenchmarkOperationEfCore>(); services.AddSingleton <IBenchmarkOperation, SelectWhereBetweenBenchmarkOperationEfCore>(); services.AddSingleton <IBenchmarkOperation, SelectTop1BenchmarkOperationEfCore>(); services.AddSingleton <IBenchmarkOperation, SelectSingleColumnBenchmarkEfCore>(); services.AddSingleton <IBenchmarkRunner, BenchmarkRunner>(); services.AddSingleton <IConnectionProvider>(new ConnectionStringConnectionProvider(ConnectionString.Value)); var serviceCollection = services.BuildServiceProvider(); serviceCollection.GetService <IBenchmarkRunner>().Run(); Console.WriteLine("Completed All Benchmarks"); Console.ReadLine(); Console.ReadLine(); Console.ReadLine(); }
public void ClearBufferPool() { var dbContext = new SqlRepoBenchmarkDbContext(); dbContext.Database.ExecuteSqlCommand("DBCC DROPCLEANBUFFERS"); }