public BenchmarkInsertMultiple()
{
_dbContext = new NorthwindEntities();
EntityFrameworkRawRepository = new EntityFrameworkRepository(_dbContext);
DapperRawSqlRepository = new DapperRepository(_connStr);
RawSqlRepository = new RawSqlRepository(_connStr);
RawSqlStoredProcedureRepository = new StoredProcedureRepository(_connStr);
//IMPORTANT STEP: BEFORE STARTING THE BENCHMARK - MAKE SURE THE TABLES ARE EMPTY FOR CONSISTENT RESULTS!!!
new DatabaseCleanup(_connStr).ClearInsertTables();
efList = new List <InsertTable>();
dtoList1 = new List <InsertTableDto>();
dtoList2 = new List <InsertTableDto>();
dtoList3 = new List <InsertTableDto>();
for (int i = 0; i < OBJECT_COUNT; i++)
{
efList.Add(InsertTableGenerator.NewEF(textLength));
dtoList1.Add(InsertTableGenerator.NewDTO(textLength));
dtoList2.Add(InsertTableGenerator.NewDTO(textLength));
dtoList3.Add(InsertTableGenerator.NewDTO(textLength));
}
}
public BenchmarkSelect()
{
_dbContext = new NorthwindEntities();
EntityFrameworkRawRepository = new EntityFrameworkRepository(_dbContext);
EntityFrameworkViewRepository = new ViewEntityFrameworkRepository(_dbContext);
DapperRawSqlRepository = new DapperRepository(_connStr);
RawSqlRepository = new RawSqlRepository(_connStr);
RawSqlStoredProcedureRepository = new StoredProcedureRepository(_connStr);
}
public void RawSql()
{
//arrange
IRepository <InvoiceDto, InsertTableDto> repo = new RawSqlRepository(_connStr);
//act
var results = repo.GetAll();
//assert
Assert.AreEqual(EXPECTED_COUNT, results.Count());
}
public void RawSql_Multiple()
{
//arrange
var repo = new RawSqlRepository(_connStr);
//act
int rows = repo.InsertRows(dtos);
//assert
Assert.AreEqual(dtos.Count(), rows);
}
public void RawSql_Single()
{
//arrange
var repo = new RawSqlRepository(_connStr);
//act
int rows = repo.InsertRows(new List <InsertTableDto> {
single
});
//assert
Assert.AreEqual(1, rows);
}
public ServiceRawSql()
{
_rawSqlRepository = new RawSqlRepository();
}
public int Insert_ADO_NET() => RawSqlRepository.InsertRows(dtoList1);
public RawSqlServices()
{
_rawSqlRepository = new RawSqlRepository();
}
public List <InvoiceDto> Select_ADO_NET()
{
return(RawSqlRepository.GetAll().ToList());
}