protected override ShapedQueryExpression TranslateSum(ShapedQueryExpression source, LambdaExpression selector, Type resultType)
{
var selectExpression = (SelectExpression)source.QueryExpression;
selectExpression.PrepareForAggregate();
var newSelector = selector == null ||
selector.Body == selector.Parameters[0]
? selectExpression.GetMappedProjection(new ProjectionMember())
: ReplacingExpressionVisitor.Replace(selector.Parameters.Single(), source.ShaperExpression, selector.Body);
var projection = _sqlTranslator.TranslateSum(newSelector);
return(AggregateResultShaper(source, projection, throwOnNullResult: false, resultType));
}
private Expression GetPredicate(MethodCallExpression methodCallExpression, GroupByShaperExpression groupByShaperExpression)
{
if (methodCallExpression.Arguments.Count == 1)
{
return(null);
}
if (methodCallExpression.Arguments.Count == 2)
{
var selectorLambda = methodCallExpression.Arguments[1].UnwrapLambdaFromQuote();
return(ReplacingExpressionVisitor.Replace(
selectorLambda.Parameters[0],
groupByShaperExpression.ElementSelector,
selectorLambda.Body));
}
throw new InvalidOperationException(CoreStrings.TranslationFailed(methodCallExpression.Print()));
}
private Expression GetSelector(MethodCallExpression methodCallExpression, GroupByShaperExpression groupByShaperExpression)
{
if (methodCallExpression.Arguments.Count == 1)
{
return(groupByShaperExpression.ElementSelector);
}
if (methodCallExpression.Arguments.Count == 2)
{
var selectorLambda = methodCallExpression.Arguments[1].UnwrapLambdaFromQuote();
return(ReplacingExpressionVisitor.Replace(
selectorLambda.Parameters[0],
groupByShaperExpression.ElementSelector,
selectorLambda.Body));
}
throw new InvalidOperationException();
}
private Expression CreateGetValueExpression(
ParameterExpression dbDataReader,
int index,
bool nullable,
RelationalTypeMapping typeMapping,
Type clrType)
{
var getMethod = typeMapping.GetDataReaderMethod();
Expression indexExpression = Expression.Constant(index);
if (_indexMapParameter != null)
{
indexExpression = Expression.ArrayIndex(_indexMapParameter, indexExpression);
}
Expression valueExpression
= Expression.Call(
getMethod.DeclaringType != typeof(DbDataReader)
? Expression.Convert(dbDataReader, getMethod.DeclaringType)
: (Expression)dbDataReader,
getMethod,
indexExpression);
if (ProjectionColumns != null)
{
var columnType = valueExpression.Type;
if (!columnType.IsValueType ||
!BufferedDataReader.IsSupportedValueType(columnType))
{
columnType = typeof(object);
valueExpression = Expression.Convert(valueExpression, typeof(object));
}
if (ProjectionColumns[index] == null)
{
ProjectionColumns[index] = ReaderColumn.Create(
columnType,
nullable,
_indexMapParameter != null ? ((ColumnExpression)_selectExpression.Projection[index].Expression).Name : null,
Expression.Lambda(
valueExpression,
dbDataReader,
_indexMapParameter ?? Expression.Parameter(typeof(int[]))).Compile());
}
if (getMethod.DeclaringType != typeof(DbDataReader))
{
valueExpression
= Expression.Call(
dbDataReader,
RelationalTypeMapping.GetDataReaderMethod(columnType),
indexExpression);
}
}
valueExpression = typeMapping.CustomizeDataReaderExpression(valueExpression);
var converter = typeMapping.Converter;
if (converter != null)
{
if (valueExpression.Type != converter.ProviderClrType)
{
valueExpression = Expression.Convert(valueExpression, converter.ProviderClrType);
}
valueExpression = ReplacingExpressionVisitor.Replace(
converter.ConvertFromProviderExpression.Parameters.Single(),
valueExpression,
converter.ConvertFromProviderExpression.Body);
}
if (valueExpression.Type != clrType)
{
valueExpression = Expression.Convert(valueExpression, clrType);
}
//var exceptionParameter
// = Expression.Parameter(typeof(Exception), name: "e");
//var property = materializationInfo.Property;
//if (detailedErrorsEnabled)
//{
// var catchBlock
// = Expression
// .Catch(
// exceptionParameter,
// Expression.Call(
// _throwReadValueExceptionMethod
// .MakeGenericMethod(valueExpression.Type),
// exceptionParameter,
// Expression.Call(
// dataReaderExpression,
// _getFieldValueMethod.MakeGenericMethod(typeof(object)),
// indexExpression),
// Expression.Constant(property, typeof(IPropertyBase))));
// valueExpression = Expression.TryCatch(valueExpression, catchBlock);
//}
//if (box && valueExpression.Type.GetTypeInfo().IsValueType)
//{
// valueExpression = Expression.Convert(valueExpression, typeof(object));
//}
if (nullable)
{
valueExpression
= Expression.Condition(
Expression.Call(dbDataReader, _isDbNullMethod, indexExpression),
Expression.Default(valueExpression.Type),
valueExpression);
}
return(valueExpression);
}
private static Expression CreateGetValueExpression(
Expression dbDataReader,
int index,
bool nullable,
RelationalTypeMapping typeMapping,
Type clrType)
{
var getMethod = typeMapping.GetDataReaderMethod();
var indexExpression = Expression.Constant(index);
Expression valueExpression
= Expression.Call(
getMethod.DeclaringType != typeof(DbDataReader)
? Expression.Convert(dbDataReader, getMethod.DeclaringType)
: dbDataReader,
getMethod,
indexExpression);
valueExpression = typeMapping.CustomizeDataReaderExpression(valueExpression);
var converter = typeMapping.Converter;
if (converter != null)
{
if (valueExpression.Type != converter.ProviderClrType)
{
valueExpression = Expression.Convert(valueExpression, converter.ProviderClrType);
}
valueExpression = ReplacingExpressionVisitor.Replace(
converter.ConvertFromProviderExpression.Parameters.Single(),
valueExpression,
converter.ConvertFromProviderExpression.Body);
}
if (valueExpression.Type != clrType)
{
valueExpression = Expression.Convert(valueExpression, clrType);
}
//var exceptionParameter
// = Expression.Parameter(typeof(Exception), name: "e");
//var property = materializationInfo.Property;
//if (detailedErrorsEnabled)
//{
// var catchBlock
// = Expression
// .Catch(
// exceptionParameter,
// Expression.Call(
// _throwReadValueExceptionMethod
// .MakeGenericMethod(valueExpression.Type),
// exceptionParameter,
// Expression.Call(
// dataReaderExpression,
// _getFieldValueMethod.MakeGenericMethod(typeof(object)),
// indexExpression),
// Expression.Constant(property, typeof(IPropertyBase))));
// valueExpression = Expression.TryCatch(valueExpression, catchBlock);
//}
//if (box && valueExpression.Type.GetTypeInfo().IsValueType)
//{
// valueExpression = Expression.Convert(valueExpression, typeof(object));
//}
if (nullable)
{
valueExpression
= Expression.Condition(
Expression.Call(dbDataReader, _isDbNullMethod, indexExpression),
Expression.Default(valueExpression.Type),
valueExpression);
}
return(valueExpression);
}
