/// <summary> /// Adds a range condition to the given query's where clause. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="query"></param> /// <param name="fieldName"></param> /// <param name="begin"></param> /// <param name="end"></param> /// <returns></returns> public static IDbQueryWhereClause FieldBetween <T>(this IDbQueryWhereClause query, string fieldName, DbDate <T> begin, DbDate <T> end) where T : struct { query.FieldMatch(fieldName, SqlOperator.GreaterThanOrEqual, begin).FieldMatch(fieldName, SqlOperator.LessThanOrEqual, end); return(query); }
/// <summary> /// Adds a condition to the given query's where clause using the given values. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="query"></param> /// <param name="fieldName"></param> /// <param name="operator"></param> /// <param name="date"></param> /// <returns></returns> public static IDbQueryWhereClause FieldMatch <T>(this IDbQueryWhereClause query, string fieldName, SqlOperator @operator, DbDate <T> date) where T : struct { query.AddFilter(new Csg.Data.Sql.SqlCompareFilter(query.Root, fieldName, @operator, date.GetDbType(), date.Value)); return(query); }