public QueryCompilationContextDependencies(
[NotNull] IModel model,
[NotNull] IQueryTranslationPreprocessorFactory queryTranslationPreprocessorFactory,
[NotNull] IQueryableMethodTranslatingExpressionVisitorFactory queryableMethodTranslatingExpressionVisitorFactory,
[NotNull] IQueryTranslationPostprocessorFactory queryTranslationPostprocessorFactory,
[NotNull] IShapedQueryCompilingExpressionVisitorFactory shapedQueryCompilingExpressionVisitorFactory,
[NotNull] IExecutionStrategyFactory executionStrategyFactory,
[NotNull] ICurrentDbContext currentContext,
[NotNull] IDbContextOptions contextOptions,
[NotNull] IDiagnosticsLogger <DbLoggerCategory.Query> logger)
{
Check.NotNull(model, nameof(model));
Check.NotNull(queryTranslationPreprocessorFactory, nameof(queryTranslationPreprocessorFactory));
Check.NotNull(queryableMethodTranslatingExpressionVisitorFactory, nameof(queryableMethodTranslatingExpressionVisitorFactory));
Check.NotNull(queryTranslationPostprocessorFactory, nameof(queryTranslationPostprocessorFactory));
Check.NotNull(shapedQueryCompilingExpressionVisitorFactory, nameof(shapedQueryCompilingExpressionVisitorFactory));
Check.NotNull(executionStrategyFactory, nameof(executionStrategyFactory));
Check.NotNull(currentContext, nameof(currentContext));
Check.NotNull(contextOptions, nameof(contextOptions));
Check.NotNull(logger, nameof(logger));
_currentContext = currentContext;
Model = model;
QueryTranslationPreprocessorFactory = queryTranslationPreprocessorFactory;
QueryableMethodTranslatingExpressionVisitorFactory = queryableMethodTranslatingExpressionVisitorFactory;
QueryTranslationPostprocessorFactory = queryTranslationPostprocessorFactory;
ShapedQueryCompilingExpressionVisitorFactory = shapedQueryCompilingExpressionVisitorFactory;
_executionStrategyFactory = executionStrategyFactory;
IsRetryingExecutionStrategy = executionStrategyFactory.Create().RetriesOnFailure;
ContextOptions = contextOptions;
Logger = logger;
}
/// <summary>
/// Clones this dependency parameter object with one service replaced.
/// </summary>
/// <param name="queryTranslationPreprocessorFactory"> A replacement for the current dependency of this type. </param>
/// <returns> A new parameter object with the given service replaced. </returns>
public QueryCompilationContextDependencies With([NotNull] IQueryTranslationPreprocessorFactory queryTranslationPreprocessorFactory)
=> new QueryCompilationContextDependencies(
Model,
queryTranslationPreprocessorFactory,
QueryableMethodTranslatingExpressionVisitorFactory,
QueryTranslationPostprocessorFactory,
ShapedQueryCompilingExpressionVisitorFactory,
CurrentContext,
ContextOptions,
Logger);
/// <summary>
/// parse select statement of queryable
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="queryable"></param>
/// <param name="ctx"></param>
/// <returns></returns>
public static SelectParsingResult Parse <TEntity>(this IQueryable <TEntity> queryable, DbContext ctx, bool ignoreQueryFilters) where TEntity : class
{
if (ignoreQueryFilters)
{
queryable = queryable.IgnoreQueryFilters();
}
SelectParsingResult parsingResult = new SelectParsingResult();
Expression query = queryable.Expression;
var databaseDependencies = ctx.GetService <DatabaseDependencies>();
IQueryTranslationPreprocessorFactory _queryTranslationPreprocessorFactory = ctx.GetService <IQueryTranslationPreprocessorFactory>();
IQueryableMethodTranslatingExpressionVisitorFactory _queryableMethodTranslatingExpressionVisitorFactory = ctx.GetService <IQueryableMethodTranslatingExpressionVisitorFactory>();
IQueryTranslationPostprocessorFactory _queryTranslationPostprocessorFactory = ctx.GetService <IQueryTranslationPostprocessorFactory>();
QueryCompilationContext queryCompilationContext = databaseDependencies.QueryCompilationContextFactory.Create(true);
IDiagnosticsLogger <DbLoggerCategory.Query> logger = ctx.GetService <IDiagnosticsLogger <DbLoggerCategory.Query> >();
QueryContext queryContext = ctx.GetService <IQueryContextFactory>().Create();
QueryCompiler queryComipler = ctx.GetService <IQueryCompiler>() as QueryCompiler;
//parameterize determines if it will use "Declare" or not
MethodCallExpression methodCallExpr1 = queryComipler.ExtractParameters(query, queryContext, logger, parameterize: true) as MethodCallExpression;
QueryTranslationPreprocessor queryTranslationPreprocessor = _queryTranslationPreprocessorFactory.Create(queryCompilationContext);
MethodCallExpression methodCallExpr2 = queryTranslationPreprocessor.Process(methodCallExpr1) as MethodCallExpression;
QueryableMethodTranslatingExpressionVisitor queryableMethodTranslatingExpressionVisitor =
_queryableMethodTranslatingExpressionVisitorFactory.Create(queryCompilationContext);
ShapedQueryExpression shapedQueryExpression1 = queryableMethodTranslatingExpressionVisitor.Visit(methodCallExpr2) as ShapedQueryExpression;
QueryTranslationPostprocessor queryTranslationPostprocessor = _queryTranslationPostprocessorFactory.Create(queryCompilationContext);
ShapedQueryExpression shapedQueryExpression2 = queryTranslationPostprocessor.Process(shapedQueryExpression1) as ShapedQueryExpression;
IRelationalParameterBasedSqlProcessorFactory _relationalParameterBasedSqlProcessorFactory =
ctx.GetService <IRelationalParameterBasedSqlProcessorFactory>();
RelationalParameterBasedSqlProcessor _relationalParameterBasedSqlProcessor = _relationalParameterBasedSqlProcessorFactory.Create(true);
SelectExpression selectExpression = (SelectExpression)shapedQueryExpression2.QueryExpression;
selectExpression = _relationalParameterBasedSqlProcessor.Optimize(selectExpression, queryContext.ParameterValues, out bool canCache);
IQuerySqlGeneratorFactory querySqlGeneratorFactory = ctx.GetService <IQuerySqlGeneratorFactory>();
IZackQuerySqlGenerator querySqlGenerator = querySqlGeneratorFactory.Create() as IZackQuerySqlGenerator;
if (querySqlGenerator == null)
{
throw new InvalidOperationException("please add dbContext.UseBatchEF() to OnConfiguring first!");
}
querySqlGenerator.IsForBatchEF = true;
querySqlGenerator.GetCommand(selectExpression);
parsingResult.Parameters = queryContext.ParameterValues;
parsingResult.PredicateSQL = querySqlGenerator.PredicateSQL;
parsingResult.ProjectionSQL = querySqlGenerator.ProjectionSQL;
TableExpression tableExpression = selectExpression.Tables[0] as TableExpression;
parsingResult.TableName = tableExpression.Table.Name;
return(parsingResult);
}
public QueryCompilationContext(
QueryCompilationContextDependencies dependencies,
bool async)
{
IsAsync = async;
IsTracking = dependencies.IsTracking;
IsBuffering = dependencies.IsRetryingExecutionStrategy;
Model = dependencies.Model;
ContextOptions = dependencies.ContextOptions;
ContextType = dependencies.ContextType;
Logger = dependencies.Logger;
_queryTranslationPreprocessorFactory = dependencies.QueryTranslationPreprocessorFactory;
_queryableMethodTranslatingExpressionVisitorFactory = dependencies.QueryableMethodTranslatingExpressionVisitorFactory;
_queryTranslationPostprocessorFactory = dependencies.QueryTranslationPostprocessorFactory;
_shapedQueryCompilingExpressionVisitorFactory = dependencies.ShapedQueryCompilingExpressionVisitorFactory;
}
public QueryCompilationContext(
QueryCompilationContextDependencies dependencies,
bool async)
{
var context = dependencies.CurrentContext.Context;
IsAsync = async;
IsTracking = context.ChangeTracker.QueryTrackingBehavior == QueryTrackingBehavior.TrackAll;
Model = dependencies.Model;
ContextOptions = dependencies.ContextOptions;
ContextType = context.GetType();
Logger = dependencies.Logger;
_queryTranslationPreprocessorFactory = dependencies.QueryTranslationPreprocessorFactory;
_queryableMethodTranslatingExpressionVisitorFactory = dependencies.QueryableMethodTranslatingExpressionVisitorFactory;
_queryTranslationPostprocessorFactory = dependencies.QueryTranslationPostprocessorFactory;
_shapedQueryCompilingExpressionVisitorFactory = dependencies.ShapedQueryCompilingExpressionVisitorFactory;
}
/// <summary>
/// Creates a new instance of the <see cref="QueryCompilationContext" /> class.
/// </summary>
/// <param name="dependencies">Parameter object containing dependencies for this class.</param>
/// <param name="async">A bool value indicating whether it is for async query.</param>
public QueryCompilationContext(
QueryCompilationContextDependencies dependencies,
bool async)
{
Dependencies = dependencies;
IsAsync = async;
QueryTrackingBehavior = dependencies.QueryTrackingBehavior;
IsBuffering = ExecutionStrategy.Current?.RetriesOnFailure ?? dependencies.IsRetryingExecutionStrategy;
Model = dependencies.Model;
ContextOptions = dependencies.ContextOptions;
ContextType = dependencies.ContextType;
Logger = dependencies.Logger;
_queryTranslationPreprocessorFactory = dependencies.QueryTranslationPreprocessorFactory;
_queryableMethodTranslatingExpressionVisitorFactory = dependencies.QueryableMethodTranslatingExpressionVisitorFactory;
_queryTranslationPostprocessorFactory = dependencies.QueryTranslationPostprocessorFactory;
_shapedQueryCompilingExpressionVisitorFactory = dependencies.ShapedQueryCompilingExpressionVisitorFactory;
_expressionPrinter = new ExpressionPrinter();
}
/// <summary>
/// Creates a new instance of the <see cref="QueryCompilationContext" /> class.
/// </summary>
/// <param name="dependencies"> Parameter object containing dependencies for this class. </param>
/// <param name="async"> A bool value indicating whether it is for async query. </param>
public QueryCompilationContext(
[NotNull] QueryCompilationContextDependencies dependencies,
bool async)
{
Check.NotNull(dependencies, nameof(dependencies));
Dependencies = dependencies;
IsAsync = async;
QueryTrackingBehavior = dependencies.QueryTrackingBehavior;
IsBuffering = dependencies.IsRetryingExecutionStrategy;
Model = dependencies.Model;
ContextOptions = dependencies.ContextOptions;
ContextType = dependencies.ContextType;
Logger = dependencies.Logger;
_queryTranslationPreprocessorFactory = dependencies.QueryTranslationPreprocessorFactory;
_queryableMethodTranslatingExpressionVisitorFactory = dependencies.QueryableMethodTranslatingExpressionVisitorFactory;
_queryTranslationPostprocessorFactory = dependencies.QueryTranslationPostprocessorFactory;
_shapedQueryCompilingExpressionVisitorFactory = dependencies.ShapedQueryCompilingExpressionVisitorFactory;
}
