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);
}
public static SqlExpression ToStringFromBoolean([Type(typeof(bool))] SqlExpression expression)
{
return(ExpressionTranslationHelpers.ToString(expression));
}
public static SqlExpression DecimalToString(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToChar(_this));
}
public static SqlExpression DecimalParse(
[Type(typeof(string))] SqlExpression str)
{
return(ExpressionTranslationHelpers.ToDecimal(str));
}
public static SqlExpression ToSingle([Type(typeof(string))] SqlExpression stringExpression)
{
return(ExpressionTranslationHelpers.ToFloat(stringExpression));
}
public static SqlExpression ToDecimalFromBoolean([Type(typeof(bool))] SqlExpression stringExpression)
{
return(ExpressionTranslationHelpers.ToDecimal(stringExpression));
}
public static SqlExpression ToStringFromUInt64([Type(typeof(ulong))] SqlExpression expression)
{
return(ExpressionTranslationHelpers.ToString(expression));
}
public static SqlExpression ToStringFromChar([Type(typeof(char))] SqlExpression expression)
{
return(ExpressionTranslationHelpers.ToString(expression));
}
public static SqlExpression TimeSpanTotalDays(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToDouble(SqlDml.IntervalToMilliseconds(_this)) / MillisecondsPerDay);
}
public static SqlExpression TimeSpanTicks(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToLong(SqlDml.IntervalToNanoseconds(_this) / NanosecondsPerTick));
}
public static SqlExpression TimeSpanDays(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlIntervalPart.Day, _this)));
}
public static SqlExpression TimeSpanMilliseconds(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlIntervalPart.Millisecond, _this)));
}
public static SqlExpression DateTimeOffsetDayOfWeek(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimeOffsetPart.DayOfWeek, _this)));
}
public static SqlExpression DateTimeOffsetMinute(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimeOffsetPart.Minute, _this)));
}
public static SqlExpression Second(SqlExpression dateExpression)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.Second, dateExpression)));
}
public static SqlExpression ToStringFromDecimal([Type(typeof(decimal))] SqlExpression expression)
{
return(ExpressionTranslationHelpers.ToString(expression));
}
public static SqlExpression ToStringFromDate([Type(typeof(DateTime))] SqlExpression expression)
{
return(ExpressionTranslationHelpers.ToString(expression));
}
public static SqlExpression MathBigMul(
[Type(typeof(int))] SqlExpression a,
[Type(typeof(int))] SqlExpression b)
{
return(ExpressionTranslationHelpers.ToLong(a) * b);
}
public static SqlExpression ToStringFromSingle([Type(typeof(float))] SqlExpression expression)
{
return(ExpressionTranslationHelpers.ToString(expression));
}
public static SqlExpression GenericSign(SqlExpression target)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Sign(target)));
}
public static SqlExpression ToStringFromInteger([Type(typeof(int))] SqlExpression expression)
{
return(ExpressionTranslationHelpers.ToString(expression));
}
public static SqlExpression DateTimeMillisecond(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.Millisecond, _this)));
}
public static SqlExpression ToLong([Type(typeof(string))] SqlExpression stringExpression)
{
return(ExpressionTranslationHelpers.ToLong(stringExpression));
}
public static SqlExpression DateTimeDayOfYear(SqlExpression _this)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Extract(SqlDateTimePart.DayOfYear, _this)));
}
public static SqlExpression ToUInteger([Type(typeof(string))] SqlExpression stringExpression)
{
return(ExpressionTranslationHelpers.ToUint(stringExpression));
}
public static SqlExpression DecimalCompare(
[Type(typeof(decimal))] SqlExpression d1,
[Type(typeof(decimal))] SqlExpression d2)
{
return(ExpressionTranslationHelpers.ToInt(SqlDml.Sign(d1 - d2)));
}
