public static CheckArgumentCount ( |
||
methodCallExpression | ||
return | void |
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 2); MethodCallTransformerUtility.CheckInstanceMethod(methodCallExpression); return(new SqlFunctionExpression(methodCallExpression.Type, "REPLACE", methodCallExpression.Object, methodCallExpression.Arguments[0], methodCallExpression.Arguments[1])); }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 0); MethodCallTransformerUtility.CheckInstanceMethod(methodCallExpression); return(new SqlFunctionExpression(methodCallExpression.Type, "LOWER", methodCallExpression.Object)); }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 1); MethodCallTransformerUtility.CheckInstanceMethod(methodCallExpression); return(SqlLikeExpression.Create(methodCallExpression.Object, methodCallExpression.Arguments[0], "%", "%")); }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 2); MethodCallTransformerUtility.CheckStaticMethod(methodCallExpression); return(new SqlLikeExpression(methodCallExpression.Arguments[0], methodCallExpression.Arguments[1], new SqlLiteralExpression(@"\"))); }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 1); MethodCallTransformerUtility.CheckInstanceMethod(methodCallExpression); switch (methodCallExpression.Method.Name) { case "Add": Trace.Assert(methodCallExpression.Method.Name == "Add"); var constantTimeSpanExpression = methodCallExpression.Arguments[0] as ConstantExpression; if (constantTimeSpanExpression == null) { var message = string.Format( "The method 'System.DateTime.Add' can only be transformed to SQL when its argument is a constant value. Expression: '{0}'.", methodCallExpression); throw new NotSupportedException(message); } return(AddTimeSpan((TimeSpan)constantTimeSpanExpression.Value, methodCallExpression.Object)); case "AddDays": return(AddWithConversion( methodCallExpression.Arguments[0], TimeSpan.TicksPerDay / TimeSpan.TicksPerMillisecond, methodCallExpression.Object)); case "AddHours": return(AddWithConversion( methodCallExpression.Arguments[0], TimeSpan.TicksPerHour / TimeSpan.TicksPerMillisecond, methodCallExpression.Object)); case "AddMilliseconds": return(AddMilliseconds(methodCallExpression.Arguments[0], methodCallExpression.Object)); case "AddMinutes": return(AddWithConversion( methodCallExpression.Arguments[0], TimeSpan.TicksPerMinute / TimeSpan.TicksPerMillisecond, methodCallExpression.Object)); case "AddMonths": return(AddUnits(methodCallExpression.Arguments[0], "month", methodCallExpression.Object)); case "AddSeconds": return(AddWithConversion( methodCallExpression.Arguments[0], TimeSpan.TicksPerSecond / TimeSpan.TicksPerMillisecond, methodCallExpression.Object)); case "AddTicks": return(AddTicks(methodCallExpression.Arguments[0], methodCallExpression.Object)); case "AddYears": return(AddUnits(methodCallExpression.Arguments[0], "year", methodCallExpression.Object)); default: var argumentExceptionMessage = string.Format( "The method '{0}.{1}' is not a supported method.", methodCallExpression.Method.DeclaringType, methodCallExpression.Method.Name); throw new ArgumentException(argumentExceptionMessage, "methodCallExpression"); } }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 1); MethodCallTransformerUtility.CheckStaticMethod(methodCallExpression); return(new SqlConvertExpression(methodCallExpression.Type, methodCallExpression.Arguments[0])); }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 1); MethodCallTransformerUtility.CheckStaticMethod(methodCallExpression); var isNullExpression = new SqlIsNullExpression(methodCallExpression.Arguments[0]); var lenExpression = new SqlLengthExpression(methodCallExpression.Arguments[0]); var lenIsZeroExpression = Expression.Equal(lenExpression, new SqlLiteralExpression(0)); return(Expression.OrElse(isNullExpression, lenIsZeroExpression)); }
public Expression Transform(MethodCallExpression methodCallExpression) { MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 2, 3); MethodCallTransformerUtility.CheckStaticMethod(methodCallExpression); if (methodCallExpression.Arguments.Count == 2) // overload without language { return(new SqlFunctionExpression(typeof(bool), "CONTAINS", methodCallExpression.Arguments[0], methodCallExpression.Arguments[1])); } else { MethodCallTransformerUtility.CheckConstantExpression(methodCallExpression.Method.Name, methodCallExpression.Arguments[2], "language parameter"); var compositeExpression = new SqlCompositeCustomTextGeneratorExpression( typeof(string), new SqlCustomTextExpression("LANGUAGE ", typeof(string)), methodCallExpression.Arguments[2]); return(new SqlFunctionExpression( typeof(bool), "CONTAINS", methodCallExpression.Arguments[0], methodCallExpression.Arguments[1], compositeExpression)); } }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 1, 2); MethodCallTransformerUtility.CheckInstanceMethod(methodCallExpression); var startIndexExpression = Expression.Add(methodCallExpression.Arguments[0], new SqlLiteralExpression(1)); if (methodCallExpression.Arguments.Count == 1) { return(new SqlFunctionExpression( methodCallExpression.Type, "STUFF", methodCallExpression.Object, startIndexExpression, new SqlLengthExpression(methodCallExpression.Object), new SqlLiteralExpression(""))); } else if (methodCallExpression.Arguments.Count == 2) { return(new SqlFunctionExpression( methodCallExpression.Type, "STUFF", methodCallExpression.Object, startIndexExpression, methodCallExpression.Arguments[1], new SqlLiteralExpression(""))); } else { var message = string.Format( "Remove function with {0} arguments is not supported. Expression: '{1}'", methodCallExpression.Arguments.Count, methodCallExpression); throw new NotSupportedException(message); } }
public Expression Transform(MethodCallExpression methodCallExpression) { ArgumentUtility.CheckNotNull("methodCallExpression", methodCallExpression); MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 2); MethodCallTransformerUtility.CheckInstanceMethod(methodCallExpression); MethodCallTransformerUtility.CheckConstantExpression("Insert", methodCallExpression.Arguments[0], "insertionIndex"); var insertionIndexExpression = Expression.Add(methodCallExpression.Arguments[0], new SqlLiteralExpression(1)); var testExpression = Expression.Equal(new SqlLengthExpression(methodCallExpression.Object), insertionIndexExpression); var concatMethod = typeof(string).GetMethod("Concat", new[] { typeof(string), typeof(string) }); var thenExpression = Expression.Add(methodCallExpression.Object, methodCallExpression.Arguments[1], concatMethod); var elseExpression = new SqlFunctionExpression( methodCallExpression.Type, "STUFF", methodCallExpression.Object, insertionIndexExpression, new SqlLiteralExpression(0), methodCallExpression.Arguments[1]); return(Expression.Condition(testExpression, thenExpression, elseExpression)); }
public Expression Transform(MethodCallExpression methodCallExpression) { MethodCallTransformerUtility.CheckArgumentCount(methodCallExpression, 1, 2, 3); MethodCallTransformerUtility.CheckInstanceMethod(methodCallExpression); if (methodCallExpression.Arguments.Count == 1) { var lenExpression = new SqlLengthExpression(methodCallExpression.Arguments[0]); var testPredicate = Expression.Equal(lenExpression, new SqlLiteralExpression(0)); var charIndexExpression = new SqlFunctionExpression( methodCallExpression.Type, "CHARINDEX", methodCallExpression.Arguments[0], methodCallExpression.Object); var elseValue = Expression.Subtract(charIndexExpression, new SqlLiteralExpression(1)); return(Expression.Condition(testPredicate, new SqlLiteralExpression(0), elseValue)); } else if (methodCallExpression.Arguments.Count == 2) { var startIndexExpression = Expression.Add(methodCallExpression.Arguments[1], new SqlLiteralExpression(1)); var lenArgExpression = new SqlLengthExpression(methodCallExpression.Arguments[0]); var leftTestPredicate = Expression.Equal(lenArgExpression, new SqlLiteralExpression(0)); var lenObjectExpression = new SqlLengthExpression(methodCallExpression.Object); var rightTestpredicate = Expression.LessThanOrEqual(startIndexExpression, lenObjectExpression); var testPredicate = Expression.AndAlso(leftTestPredicate, rightTestpredicate); var charIndexExpression = new SqlFunctionExpression( methodCallExpression.Type, "CHARINDEX", methodCallExpression.Arguments[0], methodCallExpression.Object, startIndexExpression); var elseValue = Expression.Subtract(charIndexExpression, new SqlLiteralExpression(1)); return(Expression.Condition(testPredicate, methodCallExpression.Arguments[1], elseValue)); } else if (methodCallExpression.Arguments.Count == 3) { var startIndexExpression = Expression.Add(methodCallExpression.Arguments[1], new SqlLiteralExpression(1)); var lenArgExpression = new SqlLengthExpression(methodCallExpression.Arguments[0]); var leftTestPredicate = Expression.Equal(lenArgExpression, new SqlLiteralExpression(0)); var lenObjectExpression = new SqlLengthExpression(methodCallExpression.Object); var rightTestpredicate = Expression.LessThanOrEqual(startIndexExpression, lenObjectExpression); var testPredicate = Expression.AndAlso(leftTestPredicate, rightTestpredicate); var startAddCountExpression = Expression.Add(methodCallExpression.Arguments[1], methodCallExpression.Arguments[2]); var substringExpression = new SqlFunctionExpression( typeof(string), "SUBSTRING", methodCallExpression.Object, new SqlLiteralExpression(1), startAddCountExpression); var charIndexExpression = new SqlFunctionExpression( methodCallExpression.Type, "CHARINDEX", methodCallExpression.Arguments[0], substringExpression, startIndexExpression); var elseValue = Expression.Subtract(charIndexExpression, new SqlLiteralExpression(1)); return(Expression.Condition(testPredicate, methodCallExpression.Arguments[1], elseValue)); } else { var message = string.Format( "IndexOf function with {0} arguments is not supported. Expression: '{1}'", methodCallExpression.Arguments.Count, FormattingExpressionTreeVisitor.Format(methodCallExpression)); throw new NotSupportedException(message); } }