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 StoreProcedureGeneratorImpl( StoreProcedureTemplateGenerator aTemplateGenerator, StoredProcedureRepository aStoreProcedureGenerator ) { TemplateGenerator = aTemplateGenerator; StoredProcedureRepository = aStoreProcedureGenerator; }
//[TestCase] public void TestCase1() { // Arrange var repository = new StoredProcedureRepository(); // Act // Assert }
//[TestCase] public void TestCase1() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); // Act // Assert }
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 StoredProcedure_Multiple() { //arrange var repo = new StoredProcedureRepository(_connStr); //act int rows = repo.InsertRows(dtos); //assert Assert.AreEqual(dtos.Count(), rows); }
public void RawSqlStoredProcedure() { //arrange IRepository <InvoiceDto, InsertTableDto> repo = new StoredProcedureRepository(_connStr); //act var results = repo.GetAll(); //assert Assert.AreEqual(EXPECTED_COUNT, results.Count()); }
public IHttpActionResult GetProbationPeriodDetails(EmployeeDetails emp) { var response_from_stored_proc = StoredProcedureRepository.GetEmployeeDetails(emp.EmpID); if (response_from_stored_proc == null) { return(NotFound()); } var response = WebMethods.CreateServiceResponse(Enums.WebServiceStatus.Success, response_from_stored_proc); return(Json(response)); }
public CustomerManager(UnitOfWork unitOfWork, StoredProcedureRepository storedProcedureRepository, BasePerson basePerson) { _unitOfWork = unitOfWork; _storedProcedureRepository = storedProcedureRepository; _basePerson = basePerson; UpdatedByPersonID = _basePerson.CurrentPersonID(); SourcePersonID = _basePerson.CurrentPersonID(); PersonRole = _basePerson.CurrentPersonRole(); }
public void StoredProcedure_Single() { //arrange var repo = new StoredProcedureRepository(_connStr); //act int rows = repo.InsertRows(new List <InsertTableDto> { single }); //assert Assert.AreEqual(1, rows); }
public static string obtenerConsultorios() { try { var spr = new StoredProcedureRepository(); var consultorios = spr.ObtenerDetallesConsultorios().Select(c => new { c.IdConsultorio, c.NombreConsultorio, c.Planta, c.TipoConsultorio, c.UsuarioRegistro, FechaRegistro = c.FechaRegistro.ToString("dd/MM/yyyy"), Activo = c.Activo ? "Si" : "No" }); return(new JavaScriptSerializer().Serialize(consultorios)); } catch (Exception ex) { Log.Error("[ System ] " + " [ Page ] " + "[ " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name.ToString() + " ] [ " + System.Reflection.MethodBase.GetCurrentMethod().Name.ToString() + " ] [ Fin ]", ex); throw; } }
public void GetRankingsTotal_ExceptionCaught_LogsAndRethrowsException() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var seasonID = 2017; A.CallTo(() => dbContext.GetRankingsTotal(A <int> .Ignored)).Throws <Exception>(); // Act ObjectResult <GetRankingsTotal_Result> result = null; Assert.Throws <Exception>(() => result = result = repository.GetRankingsTotal(seasonID)); // Assert Assert.IsNull(result); }
public void GetLeagueSeasonTotals() { // Arrange var repository = new StoredProcedureRepository(); var dbContext = A.Fake <ProFootballEntities>(); var leagueName = "League"; var seasonID = 2017; A.CallTo(() => dbContext.GetLeagueSeasonTotals(A <string> .Ignored, A <int> .Ignored)) .Returns(A.Fake <ObjectResult <GetLeagueSeasonTotals_Result> >()); // Act var result = repository.GetLeagueSeasonTotals(dbContext, leagueName, seasonID); // Assert A.CallTo(() => dbContext.GetLeagueSeasonTotals(leagueName, seasonID)).MustHaveHappenedOnceExactly(); Assert.IsInstanceOf <ObjectResult <GetLeagueSeasonTotals_Result> >(result); }
public void GetSeasonStandings() { // Arrange var repository = new StoredProcedureRepository(); var dbContext = A.Fake <ProFootballEntities>(); var seasonID = 2017; var groupByDivision = false; A.CallTo(() => dbContext.GetSeasonStandings(A <int> .Ignored, A <bool> .Ignored)) .Returns(A.Fake <ObjectResult <GetSeasonStandings_Result> >()); // Act var result = repository.GetSeasonStandings(dbContext, seasonID, groupByDivision); // Assert A.CallTo(() => dbContext.GetSeasonStandings(seasonID, groupByDivision)).MustHaveHappenedOnceExactly(); Assert.IsInstanceOf <ObjectResult <GetSeasonStandings_Result> >(result); }
public void GetRankingsTotal_HappyPath() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var seasonID = 2017; var totalRankings = A.Fake <ObjectResult <GetRankingsTotal_Result> >(); A.CallTo(() => dbContext.GetRankingsTotal(A <int> .Ignored)).Returns(totalRankings); // Act var result = repository.GetRankingsTotal(seasonID); // Assert A.CallTo(() => dbContext.GetRankingsTotal(seasonID)).MustHaveHappenedOnceExactly(); Assert.AreSame(totalRankings, result); }
public void GetTeamSeasonScheduleProfile() { // Arrange var repository = new StoredProcedureRepository(); var dbContext = A.Fake <ProFootballEntities>(); var teamName = "Team"; var seasonID = 2017; A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(A <string> .Ignored, A <int> .Ignored)) .Returns(A.Fake <ObjectResult <GetTeamSeasonScheduleProfile_Result> >()); // Act var result = repository.GetTeamSeasonScheduleProfile(dbContext, teamName, seasonID); // Assert A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(teamName, seasonID)) .MustHaveHappenedOnceExactly(); Assert.IsInstanceOf <ObjectResult <GetTeamSeasonScheduleProfile_Result> >(result); }
public void GetLeagueSeasonTotals_GenericExceptionCaught_LogsAndRethrowsException() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var leagueName = "League"; var seasonID = 2017; A.CallTo(() => dbContext.GetLeagueSeasonTotals(A <string> .Ignored, A <int> .Ignored)) .Throws <Exception>(); // Act ObjectResult <GetLeagueSeasonTotals_Result> result = null; Assert.Throws <Exception>( () => { result = repository.GetLeagueSeasonTotals(leagueName, seasonID); }); // Assert Assert.IsNull(result); }
public void GetTeamSeasonScheduleAverages_InvalidOperationExceptionCaught_LogsAndRethrowsException() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var teamName = "Team"; var seasonID = 2017; A.CallTo(() => dbContext.GetTeamSeasonScheduleAverages(A <string> .Ignored, A <int> .Ignored)) .Throws <InvalidOperationException>(); // Act ObjectResult <GetTeamSeasonScheduleAverages_Result> result = null; Assert.Throws <InvalidOperationException>( () => { result = repository.GetTeamSeasonScheduleAverages(teamName, seasonID); }); // Assert Assert.IsNull(result); }
public void GetSeasonStandingsForDivision_ExceptionCaught_LogsAndRethrowsException() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var seasonID = 2017; var divisionName = "Division"; A.CallTo(() => dbContext.GetSeasonStandingsForDivision(A <int> .Ignored, A <string> .Ignored)) .Throws <Exception>(); // Act ObjectResult <GetSeasonStandingsForDivision_Result> result = null; Assert.Throws <Exception>( () => { result = repository.GetSeasonStandingsForDivision(seasonID, divisionName); }); // Assert Assert.IsNull(result); }
public void GetSeasonStandingsForDivision_HappyPath() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var seasonID = 2017; var divisionName = "Division"; var standings = A.Fake <ObjectResult <GetSeasonStandingsForDivision_Result> >(); A.CallTo(() => dbContext.GetSeasonStandingsForDivision(A <int> .Ignored, A <string> .Ignored)) .Returns(standings); // Act var result = repository.GetSeasonStandingsForDivision(seasonID, divisionName); // Assert A.CallTo(() => dbContext.GetSeasonStandingsForDivision(seasonID, divisionName)). MustHaveHappenedOnceExactly(); Assert.AreSame(standings, result); }
public void GetTeamSeasonScheduleAverages_HappyPath() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var teamName = "Team"; var seasonID = 2017; var teamSeasonScheduleAverages = A.Fake <ObjectResult <GetTeamSeasonScheduleAverages_Result> >(); A.CallTo(() => dbContext.GetTeamSeasonScheduleAverages(A <string> .Ignored, A <int> .Ignored)) .Returns(teamSeasonScheduleAverages); // Act var result = repository.GetTeamSeasonScheduleAverages(teamName, seasonID); // Assert A.CallTo(() => dbContext.GetTeamSeasonScheduleAverages(teamName, seasonID)) .MustHaveHappenedOnceExactly(); Assert.AreSame(teamSeasonScheduleAverages, result); }
public void GetTeamSeasonScheduleProfile_ArgumentExceptionCaught_LogsAndRethrowsException() { // Arrange var dbContext = A.Fake <ProFootballEntities>(); var repository = new StoredProcedureRepository(dbContext); var teamName = "Team"; var seasonID = 2017; A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(A <string> .Ignored, A <int> .Ignored)) .Throws <ArgumentException>(); // Act ObjectResult <GetTeamSeasonScheduleProfile_Result> result = null; Assert.Throws <ArgumentException>( () => { result = repository.GetTeamSeasonScheduleProfile(teamName, seasonID); }); // Assert A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(teamName, seasonID)) .MustHaveHappenedOnceExactly(); Assert.IsNull(result); }