public void PagedQueryFiltering_WhenFilteringValueBetweenExclusive_ThenDataAndCountQueriesContainsWhereClauseWithProperCondition() { var startDate = new DateTime(2000, 10, 20); var endDate = new DateTime(2010, 10, 20); PagedQuery <Data> query = BuildPagedQuery(b => b.Where("Column1", Is.Between(startDate, endDate, inclusive: false))); ShouldContainWhere(query, "WHERE Column1 >= @p1 AND Column1 < @p2"); ParameterValueShouldBe(query, "p1", startDate); ParameterValueShouldBe(query, "p2", endDate); }
public void WhereBetweenWithIsHelper() { FlowQuerySelection <UserEntity> users = Query <UserEntity>() .Where(u => u.Id, FqIs.Between(2, 3)) .Select(); Assert.That(users.Count(), Is.EqualTo(2)); foreach (UserEntity user in users) { Assert.That(user.Id, Is.InRange(2, 3)); } }
public void CanFilterBetween() { FlowQuerySelection <UserEntity> users = Query <UserEntity>() .Where(x => x.Id, FqIs.Between(2, 4)) .Select(); Assert.That(users.Count(), Is.EqualTo(3)); foreach (UserEntity u in users) { Assert.That(u.Id, Is.InRange(2, 4)); } }
public static IQueryFilter <UserEntity> Id_Of_User_UsingWhereHelper_Is(int between, int and) { return(new QueryFilter <UserEntity>(query => query.And((x, y) => y(x.Id, Is.Between(between, and))))); }
public static IQueryFilter <UserEntity> Id_SpecifedByMagicString_Of_User_Is(int between, int and) { return(new QueryFilter <UserEntity>(query => query.And("Id", Is.Between(between, and)))); }
public static IQueryFilter <UserEntity> Id_Of_User_Is(int between, int and) { return(new QueryFilter <UserEntity>(query => query.And(x => x.Id, Is.Between(between, and)))); }