public void AddNotBetween_BothParametersAreNull_AddsNothing()
{
// arrange
var sut = new SqlClause();
// act
sut.AddNotBetween("Id", null, null);
var sql = sut.GetSql();
var parameters = sut.GetParameters();
// assert
sql.Should().Be(string.Empty);
parameters.Should().BeEmpty();
}
public void AddNotBetween_TheFirstParameterIsNull_AddsNothing()
{
// arrange
var sut = new SqlClause();
var parameter2 = new SqlParameter {
ParameterName = "@x2"
};
// act
sut.AddNotBetween("Id", null, parameter2);
var sql = sut.GetSql();
var parameters = sut.GetParameters();
// assert
sql.Should().Be("Id > @x2");
parameters.Should().Equal(parameter2);
}
public void AddNotBetween_TheSecondParameterIsNull_AddsNothing()
{
// arrange
var sut = new SqlClause();
var parameter = new SqlParameter {
ParameterName = "@x"
};
// act
sut.AddNotBetween("Id", parameter, null);
var sql = sut.GetSql();
var parameters = sut.GetParameters();
// assert
sql.Should().Be("Id < @x");
parameters.Should().Equal(parameter);
}
public void AddNotBetween_ByDefault_AddsCorrectPredicate()
{
// arrange
var sut = new SqlClause();
var parameter = new SqlParameter {
ParameterName = "@x"
};
var parameter2 = new SqlParameter {
ParameterName = "@x2"
};
// act
sut.AddNotBetween("Id", parameter, parameter2);
var sql = sut.GetSql();
var parameters = sut.GetParameters();
// assert
sql.Should().Be("Id not between @x and @x2");
parameters.Should().Equal(parameter, parameter2);
}
