public void BetweenPredicate_ReturnsProperSql()
{
var pred = new BetweenPredicate<PredicateTestEntity>
{
PropertyName = "Id",
Value = new BetweenValues {Value1 = 1, Value2 = 10}
};
Dictionary<string, object> parameters = new Dictionary<string, object>();
string result = pred.GetSql(parameters);
Assert.AreEqual("([PredicateTestEntity].[Id] BETWEEN @Id_0 AND @Id_1)", result);
Assert.AreEqual(2, parameters.Count);
}
public void BetweenPredicate_ReturnsProperSql()
{
var pred = new BetweenPredicate <PredicateTestEntity>
{
PropertyName = "Id",
Value = new BetweenValues {
Value1 = 1, Value2 = 10
}
};
Dictionary <string, object> parameters = new Dictionary <string, object>();
string result = pred.GetSql(parameters);
Assert.AreEqual("([PredicateTestEntity].[Id] BETWEEN @Id_0 AND @Id_1)", result);
Assert.AreEqual(2, parameters.Count);
}
public void GetSql()
{
var predicate = new BetweenPredicate <TestEntity>()
{
Value = new BetweenValues()
{
Value1 = 10,
Value2 = 20,
},
Not = false,
PropertyName = "Id"
};
var dictionary = new Dictionary <string, object>();
var sql = predicate.GetSql(SqlHelper.GetSqlGenerator(), dictionary);
Assert.Equal("(Id BETWEEN @Id_0 AND @Id_1)", sql);
Assert.Equal(10, dictionary["@Id_0"]);
Assert.Equal(20, dictionary["@Id_1"]);
}
