public ISqlExecutor CreateSut(ISqlClassProvider sqlClassProvider = null) { var optionsMock = Substitute.For <IOptions <SnoozleSqlServerOptions> >(); optionsMock.Value.Returns(new SnoozleSqlServerOptions()); return(new SqlExecutor(optionsMock, sqlClassProvider ?? Substitute.For <ISqlClassProvider>())); }
public void CreateSqlConnection_NullConnectionStringParameter_ThrowsArgumentNullException() { // Arrange ISqlClassProvider sut = CreateSut(); TestDelegate result = () => sut.CreateSqlConnection(null); // Act // Assert Assert.Throws <ArgumentNullException>(result); }
public void CreateSqlCommand_NullSqlParameter_ThrowsArgumentNullException() { // Arrange ISqlClassProvider sut = CreateSut(); TestDelegate result = () => sut.CreateSqlCommand(null, Substitute.For <IDatabaseConnection>()); // Act // Assert Assert.Throws <ArgumentNullException>(result); }
public void CreateSqlCommand_NullSqlConnectionParameter_ThrowsArgumentNullException() { // Arrange ISqlClassProvider sut = CreateSut(); string sql = "SELECT * FROM TABLE"; TestDelegate result = () => sut.CreateSqlCommand(sql, null); // Act // Assert Assert.Throws <ArgumentNullException>(result); }
public void CreateSqlConnection_CorrectParameters_ReturnsIDatabaseConnectionInstance() { // Arrange ISqlClassProvider sut = CreateSut(); string connectionString = string.Empty; // Act var result = sut.CreateSqlConnection(connectionString); // Assert Assert.IsInstanceOf <IDatabaseConnection>(result); }
public void CreateSqlCommand_CorrectParameters_ReturnsIDatabaseCommandInstance() { // Arrange ISqlClassProvider sut = CreateSut(); string sql = "SELECT * FROM TABLE"; // Act var result = sut.CreateSqlCommand(sql, Substitute.For <IDatabaseConnection>()); // Assert Assert.IsInstanceOf <IDatabaseCommand>(result); }
public void CreateDatabaseCommandParameter_CreateDatabaseCommandParameter_ReturnsIDatabaseCommandParameterInstance() { // Arrange ISqlClassProvider sut = CreateSut(); string paramName = string.Empty; object value = null; SqlDbType sqlDbType = SqlDbType.Int; bool isNullable = false; // Act var result = sut.CreateDatabaseCommandParameter(paramName, value, sqlDbType, isNullable); // Assert Assert.IsInstanceOf <IDatabaseCommandParameter>(result); }
public SqlExecutor(IOptions <SnoozleSqlServerOptions> options, ISqlClassProvider sqlClassProvider) { _connectionString = options.Value.ConnectionString; _sqlClassProvider = sqlClassProvider; }
public SqlExpressionBuilder(ISqlParamaterProvider sqlParamaterProvider, ISqlClassProvider sqlClassProvider) { _sqlParamaterProvider = sqlParamaterProvider; _sqlClassProvider = sqlClassProvider; }