internal static string WithExpression <T>(params Expression <Func <T, object> >[] columnsAndValues) { var condition = columnsAndValues.Select(cvw => ExpressionHelper.ConditionBuilder(cvw)).ToList().Aggregate((c, n) => c + "," + n); return(string.Concat(Constants.Sql.Set, "(", condition, ")", " ")); }
internal static string BuildFunctionWithExpression <T>(string funcName, Expression <Func <T, object> > column, bool comma, bool parenthesis = true) { return(string.Concat(comma ? "," : "", funcName, parenthesis ? "(":"", ExpressionHelper.ConditionBuilder(column).Trim(' '), parenthesis ?")":"", " ")); }
internal static string WithExpression <T>(Expression <Func <T, object> > condition, bool parenthesis) { var value = ExpressionHelper.ConditionBuilder(condition, Constants.Sql.Or); return(!parenthesis ? value : string.Concat(value.Insert(Constants.Sql.Or.Length, "("), ")", " ")); }
internal static string WithExpression <T>(Expression <Func <T, object> > column, int startIndex, int length, bool comma) { var expression = ExpressionHelper.ConditionBuilder(column, Constants.Sql.SubString); return(string.Concat(comma ? "," : "", expression.Insert(Constants.Sql.SubString.Length, "("), ",", startIndex, ",", length, ")", " ")); }