We make a lot of use of WhereExpression with DataSets, for example:
WhereExpression oWhere = new BinaryExpression(new FieldExpression(“IsActive”), DateTime.Today, BinaryOperator.Equal);
Is it possible to do the following with a WhereExpression (or TableRequestInfoV6)? :
SELECT * FROM Employee WHERE DATEPART(DAY, DayOfBirth) = @Day AND DATEPART(MONTH, DayOfBirth) = @Month
With other words, a where clause on parts of a DateTime column?