コード例 #1
0
        public static SqlExpression DateTimeDayOfWeek(SqlExpression _this)
        {
            var baseExpression = ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.DayOfWeek, _this));
            var context        = ExpressionTranslationContext.Current;

            if (context == null)
            {
                return(baseExpression);
            }
            if (context.ProviderInfo.ProviderName == WellKnown.Provider.MySql)
            {
                return(baseExpression - 1); //Mysql starts days of week from 1 unlike in .Net.
            }
            return(baseExpression);
        }
コード例 #2
0
 public static SqlExpression ToInteger([Type(typeof(string))] SqlExpression stringExpression)
 {
     return(ExpressionTranslationHelpers.ToInt(stringExpression));
 }
コード例 #3
0
 public static SqlExpression DateTimeDayOfYear(SqlExpression _this)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.DayOfYear, _this)));
 }
コード例 #4
0
 public static SqlExpression DateTimeMillisecond(SqlExpression _this)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.Millisecond, _this)));
 }
コード例 #5
0
 public static SqlExpression TimeSpanDays(SqlExpression _this)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlIntervalPart.Day, _this)));
 }
コード例 #6
0
 public static SqlExpression GenericSign(SqlExpression target)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Sign(target)));
 }
コード例 #7
0
 public static SqlExpression TimeSpanMilliseconds(SqlExpression _this)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlIntervalPart.Millisecond, _this)));
 }
コード例 #8
0
 public static SqlExpression DateTimeOffsetDayOfWeek(SqlExpression _this)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimeOffsetPart.DayOfWeek, _this)));
 }
コード例 #9
0
 public static SqlExpression DateTimeOffsetMinute(SqlExpression _this)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimeOffsetPart.Minute, _this)));
 }
コード例 #10
0
 public static SqlExpression Second(SqlExpression dateExpression)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.Second, dateExpression)));
 }
コード例 #11
0
 public static SqlExpression DecimalCompare(
     [Type(typeof(decimal))] SqlExpression d1,
     [Type(typeof(decimal))] SqlExpression d2)
 {
     return(ExpressionTranslationHelpers.ToInt(SqlDml.Sign(d1 - d2)));
 }