public void ShouldInitaliseNotCommandTimeoutWhenNotSet() { //Given var dataQuery = new DataQuery(); //When _databaseCommandFactory.CreateCommandFor(dataQuery); //Then _dbCommand.VerifySet(x => x.CommandTimeout = It.IsAny<int>(), Times.Never()); }
public void ShouldInitaliseCommandTimeout() { //Given var dataQuery = new DataQuery().WithCommandTimeout(TimeSpan.FromHours(1)); //When _databaseCommandFactory.CreateCommandFor(dataQuery); //Then _dbCommand.VerifySet(x => x.CommandTimeout = 3600); }
public void ShouldInitaliseCommandProperties() { //Given var dataQuery = new DataQuery().WithStoredProc("Get_Shizzle"); //When _databaseCommandFactory.CreateCommandFor(dataQuery); //Then _dbCommand.VerifySet(x => x.CommandText = "Get_Shizzle"); _dbCommand.VerifySet(x => x.CommandType = CommandType.StoredProcedure); }
public void ShouldGetContactUsingRunQueryMethodWithDataQuery() { //Given var dataQuery = new DataQuery() {CommandText = "select * from Contact where FirstName = @FirstName",}.WithParam("@FirstName", "David"); //When - This could be a generic repository var contact = UnitOfWork.Repository<ContactRepository>().RunQuery(dataQuery); //Then Assert.That(contact.FirstName, Is.EqualTo("David")); Assert.That(contact.Surname, Is.EqualTo("Miranda")); Assert.That(contact.Telephone, Is.EqualTo("999")); }
public void BeforeEachTest() { _sqlDataQuery = new DataQuery(); _command = new Mock<IDbCommand>(); _databaseCommandFactory = new Mock<IDatabaseCommandFactory>(); _transactionWrapperMock = new Mock<ITransactionWrapper>(); _databaseReaderFactory = new Mock<IDatabaseReaderFactory>(); _connectionHandler = new Mock<IConnectionHandler>(); _databaseSession = new DatabaseSession(_databaseCommandFactory.Object, _transactionWrapperMock.Object, _databaseReaderFactory.Object, _connectionHandler.Object); _connectionHandler.Setup(x => x.GetHandler(It.IsAny<IDbCommand>(), It.IsAny<ITransactionWrapper>())).Returns(_connectionHandler.Object); _databaseCommandFactory.Setup(x => x.CreateCommandFor(It.IsAny<DataQuery>())).Returns(_command.Object); }
public void ShouldInitialiseCommandDataParameters() { //Given var dataQuery = new DataQuery() .WithParam("Title", "Mr") .WithParam("FirstName", "David") .WithParam("Surname", "Miranda"); //When _databaseCommandFactory.CreateCommandFor(dataQuery); //Then _dataParameter.VerifySet(x => x.ParameterName = "Title", Times.Once()); _dataParameter.VerifySet(x => x.Value = "Mr", Times.Once()); _dataParameter.VerifySet(x => x.ParameterName = "FirstName", Times.Once()); _dataParameter.VerifySet(x => x.Value = "David", Times.Once()); _dataParameter.VerifySet(x => x.ParameterName = "Surname", Times.Once()); _dataParameter.VerifySet(x => x.Value = "Miranda", Times.Once()); }
public void ShouldNotSetDbTypeForNullValue() { var dataQuery = new DataQuery() .WithParam("Title", null); _databaseCommandFactory.CreateCommandFor(dataQuery); _dataParameter.VerifySet(x => x.DbType = It.IsAny<DbType>(), Times.Never()); }
public void ShouldNotSetDbTypeForDbNullValue() { var dataQuery = new DataQuery() .WithCommandType(CommandType.StoredProcedure) .WithParam("Title", DBNull.Value); _databaseCommandFactory.CreateCommandFor(dataQuery); _dataParameter.VerifySet(x => x.DbType = It.IsAny<DbType>(), Times.Never()); }
public void ShouldMapDbTypeForValue() { var dataQuery = new DataQuery() .WithCommandType(CommandType.StoredProcedure) .WithParam("Title", "Dr"); _databaseCommandFactory.CreateCommandFor(dataQuery); _dataParameter.VerifySet(x => x.DbType = DbType.String, Times.Once()); }