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"]); }