protected override Expression VisitMethodCall(MethodCallExpression methodCallExpression)
{
Check.NotNull(methodCallExpression, nameof(methodCallExpression));
// EF.Property case
if (methodCallExpression.TryGetEFPropertyArguments(out var source, out var propertyName))
{
if (TryBindMember(source, MemberIdentity.Create(propertyName), out var result))
{
return(result);
}
throw new InvalidOperationException("EF.Property called with wrong property name.");
}
// EF Indexer property
if (methodCallExpression.TryGetIndexerArguments(_model, out source, out propertyName))
{
return(TryBindMember(source, MemberIdentity.Create(propertyName), out var result) ? result : null);
}
// GroupBy Aggregate case
if (methodCallExpression.Object == null &&
methodCallExpression.Method.DeclaringType == typeof(Enumerable) &&
methodCallExpression.Arguments.Count > 0 &&
methodCallExpression.Arguments[0] is GroupByShaperExpression groupByShaperExpression)
{
var translatedAggregate = methodCallExpression.Method.Name switch
{
nameof(Enumerable.Average) => TranslateAverage(GetSelector(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.Count) => TranslateCount(GetPredicate(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.LongCount) => TranslateLongCount(GetPredicate(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.Max) => TranslateMax(GetSelector(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.Min) => TranslateMin(GetSelector(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.Sum) => TranslateSum(GetSelector(methodCallExpression, groupByShaperExpression)),
_ => null
};
if (translatedAggregate == null)
{
throw new InvalidOperationException(CoreStrings.TranslationFailed(methodCallExpression.Print()));
}
return(translatedAggregate);
}
// Subquery case
var subqueryTranslation = _queryableMethodTranslatingExpressionVisitor.TranslateSubquery(methodCallExpression);
if (subqueryTranslation != null)
{
protected override Expression VisitMethodCall(MethodCallExpression methodCallExpression)
{
// EF.Property case
if (methodCallExpression.TryGetEFPropertyArguments(out var source, out var propertyName))
{
if (TryBindMember(Visit(source), MemberIdentity.Create(propertyName), out var result))
{
return(result);
}
throw new InvalidOperationException("EF.Property called with wrong property name.");
}
// GroupBy Aggregate case
if (methodCallExpression.Object == null &&
methodCallExpression.Method.DeclaringType == typeof(Enumerable) &&
methodCallExpression.Arguments.Count > 0 &&
methodCallExpression.Arguments[0] is GroupByShaperExpression groupByShaperExpression)
{
var translatedAggregate = methodCallExpression.Method.Name switch
{
nameof(Enumerable.Average) => TranslateAverage(GetSelector(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.Count) => TranslateCount(),
nameof(Enumerable.LongCount) => TranslateLongCount(),
nameof(Enumerable.Max) => TranslateMax(GetSelector(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.Min) => TranslateMin(GetSelector(methodCallExpression, groupByShaperExpression)),
nameof(Enumerable.Sum) => TranslateSum(GetSelector(methodCallExpression, groupByShaperExpression)),
_ => null
};
if (translatedAggregate == null)
{
throw new InvalidOperationException(CoreStrings.TranslationFailed(methodCallExpression.Print()));
}
return(translatedAggregate);
}
// Subquery case
var subqueryTranslation = _queryableMethodTranslatingExpressionVisitor.TranslateSubquery(methodCallExpression);
if (subqueryTranslation != null)
{
if (subqueryTranslation.ResultCardinality == ResultCardinality.Enumerable)
{
return(null);
}
var subquery = (SelectExpression)subqueryTranslation.QueryExpression;
subquery.ApplyProjection();
if (subquery.Projection.Count != 1)
{
return(null);
}
if (subquery.Tables.Count == 0 &&
methodCallExpression.Method.IsGenericMethod &&
methodCallExpression.Method.GetGenericMethodDefinition() is MethodInfo genericMethod &&
(genericMethod == QueryableMethods.AnyWithoutPredicate ||
genericMethod == QueryableMethods.AnyWithPredicate ||
genericMethod == QueryableMethods.All ||
genericMethod == QueryableMethods.Contains))
{
return(subquery.Projection[0].Expression);
}
return(new ScalarSubqueryExpression(subquery));
}
// MethodCall translators
if (TranslationFailed(methodCallExpression.Object, Visit(methodCallExpression.Object), out var sqlObject))
{
return(null);
}
var arguments = new SqlExpression[methodCallExpression.Arguments.Count];
for (var i = 0; i < arguments.Length; i++)
{
var argument = methodCallExpression.Arguments[i];
if (TranslationFailed(argument, Visit(argument), out var sqlArgument))
{
return(null);
}
arguments[i] = sqlArgument;
}
return(Dependencies.MethodCallTranslatorProvider.Translate(_model, sqlObject, methodCallExpression.Method, arguments));
}