public virtual string Trim(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format(" (rtrim(ltrim({0}))) ", parameter.MemberName)); }
public virtual string CharIndex(MethodCallExpressionModel model) { return(string.Format("CHARINDEX ({0},{1})", model.Args[0].MemberName, model.Args[1].MemberName)); }
public string ToVarchar(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format(" CAST({0} AS VARCHAR(MAX))", parameter.MemberName)); }
public virtual string HasNumber(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format("( {0}>0 AND {0} IS NOT NULL )", parameter.MemberName)); }
public virtual string AggregateDistinctCount(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format("COUNT(DISTINCT{0})", parameter.MemberName)); }
public virtual string Length(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format("LEN({0})", parameter.MemberName)); }
public virtual string AggregateMax(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format("MAX({0})", parameter.MemberName)); }
public virtual string ToDecimal(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format(" CAST({0} AS MONEY)", parameter.MemberName)); }
public virtual string ToDate(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format(" CAST({0} AS DATETIME)", parameter.MemberName)); }
public virtual string ToGuid(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format(" CAST({0} AS UNIQUEIDENTIFIER)", parameter.MemberName)); }
public virtual string ToInt64(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format(" CAST({0} AS BIGINT)", parameter.MemberName)); }
public virtual string IsNullOrEmpty(MethodCallExpressionModel model) { var parameter = model.Args[0]; return(string.Format("( {0}='' OR {0} IS NULL )", parameter.MemberName)); }