You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I would like to use BulkRead, however I am getting exception: System.NotSupportedException: 'Specified method is not supported.'
The uniqie key is the SupplierItemId and BrandId together.
What I could find out is the error is coming from BulkExtensions.TableInfo.LoadOutputEntities at EF.CompileQuery.
Hi!
I would like to use BulkRead, however I am getting exception: System.NotSupportedException: 'Specified method is not supported.'
The uniqie key is the SupplierItemId and BrandId together.
What I could find out is the error is coming from BulkExtensions.TableInfo.LoadOutputEntities at EF.CompileQuery.
I am using Azure SQL database.
Versions:
My code:
_supplierItemRepository:
Stack trace:
System.Private.CoreLib.dll!System.Delegate.CreateDelegateInternal(System.RuntimeType rtType, System.Reflection.RuntimeMethodInfo rtMethod, object firstArgument, System.DelegateBindingFlags flags) Unknown
System.Private.CoreLib.dll!System.Reflection.RuntimeMethodInfo.CreateDelegateInternal(System.Type delegateType, object firstArgument, System.DelegateBindingFlags bindingFlags) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.FuncCallInstruction<Microsoft.EntityFrameworkCore.DbContext, Microsoft.EntityFrameworkCore.DbSet<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.FuncCallInstruction(System.Reflection.MethodInfo target) Unknown
[Native to Managed Transition]
[Managed to Native Transition]
System.Private.CoreLib.dll!System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(object obj, System.Span copyOfArgs, System.Reflection.BindingFlags invokeAttr) Unknown
System.Private.CoreLib.dll!System.Reflection.MethodBaseInvoker.InvokeWithOneArg(object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, object[] parameters, System.Globalization.CultureInfo culture) Unknown
System.Private.CoreLib.dll!System.RuntimeType.CreateInstanceImpl(System.Reflection.BindingFlags bindingAttr, System.Reflection.Binder binder, object[] args, System.Globalization.CultureInfo culture) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.CallInstruction.SlowCreate(System.Reflection.MethodInfo info, System.Reflection.ParameterInfo[] pis) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.CallInstruction.Create(System.Reflection.MethodInfo info, System.Reflection.ParameterInfo[] parameters) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.LightCompiler.CompileMethodCallExpression(System.Linq.Expressions.Expression object, System.Reflection.MethodInfo method, System.Linq.Expressions.IArgumentProvider arguments) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.LightCompiler.CompileMethodCallExpression(System.Linq.Expressions.Expression object, System.Reflection.MethodInfo method, System.Linq.Expressions.IArgumentProvider arguments) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.LightCompiler.CompileMethodCallExpression(System.Linq.Expressions.Expression object, System.Reflection.MethodInfo method, System.Linq.Expressions.IArgumentProvider arguments) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.LightCompiler.Compile(System.Linq.Expressions.Expression expr) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.LightCompiler.CompileConvertUnaryExpression(System.Linq.Expressions.Expression expr) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.LightCompiler.Compile(System.Linq.Expressions.Expression expr) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Interpreter.LightCompiler.CompileTop(System.Linq.Expressions.LambdaExpression node) Unknown
System.Linq.Expressions.dll!System.Linq.Expressions.Expression<System.Func>.Compile(bool preferInterpretation) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.ParameterExtractingExpressionVisitor.GetValue(System.Linq.Expressions.Expression expression, out string parameterName) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.ParameterExtractingExpressionVisitor.Evaluate(System.Linq.Expressions.Expression expression, bool generateParameter) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.ParameterExtractingExpressionVisitor.Visit(System.Linq.Expressions.Expression expression) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.ParameterExtractingExpressionVisitor.ExtractParameters(System.Linq.Expressions.Expression expression, bool clearEvaluatedValues) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.ParameterExtractingExpressionVisitor.ExtractParameters(System.Linq.Expressions.Expression expression) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExtractParameters(System.Linq.Expressions.Expression query, Microsoft.EntityFrameworkCore.Query.Internal.IParameterValues parameterValues, Microsoft.EntityFrameworkCore.Diagnostics.IDiagnosticsLogger<Microsoft.EntityFrameworkCore.DbLoggerCategory.Query> logger, bool parameterize, bool generateContextAccessors) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CreateCompiledQuery<System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>(System.Linq.Expressions.Expression query) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.CompiledQuery<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.CreateCompiledQuery(Microsoft.EntityFrameworkCore.Query.Internal.IQueryCompiler queryCompiler, System.Linq.Expressions.Expression expression) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.EnsureExecutor.AnonymousMethod__7_0(Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>> t, Microsoft.EntityFrameworkCore.DbContext c, System.Linq.Expressions.LambdaExpression q) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Internal.NonCapturingLazyInitializer.EnsureInitialized<Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>, Microsoft.EntityFrameworkCore.DbContext, System.Linq.Expressions.LambdaExpression, Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.ExecutorAndModel>(ref Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.ExecutorAndModel target, Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>> param1, Microsoft.EntityFrameworkCore.DbContext param2, System.Linq.Expressions.LambdaExpression param3, System.Func<Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>, Microsoft.EntityFrameworkCore.DbContext, System.Linq.Expressions.LambdaExpression, Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.ExecutorAndModel> valueFactory) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.EnsureExecutor(Microsoft.EntityFrameworkCore.DbContext context) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<Microsoft.EntityFrameworkCore.DbContext, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.ExecuteCore(Microsoft.EntityFrameworkCore.DbContext context, System.Threading.CancellationToken cancellationToken, object[] parameters) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryBase<System.__Canon, System.__Canon>.ExecuteCore(System.__Canon context, object[] parameters) Unknown
Microsoft.EntityFrameworkCore.dll!Microsoft.EntityFrameworkCore.Query.Internal.CompiledQuery<System.__Canon, System.__Canon>.Execute(System.__Canon context) Unknown
EFCore.BulkExtensions.SqlServer.dll!EFCore.BulkExtensions.TableInfo.LoadOutputEntities<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>(Microsoft.EntityFrameworkCore.DbContext context, System.Type type, string sqlSelect) Unknown
EFCore.BulkExtensions.SqlServer.dll!EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.ReadAsync<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>(Microsoft.EntityFrameworkCore.DbContext context, System.Type type, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem> entities, EFCore.BulkExtensions.TableInfo tableInfo, System.Action progress, bool isAsync, System.Threading.CancellationToken cancellationToken) Unknown
[Resuming Async Method]
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__12<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.ExecutionContextCallback(object s) Unknown
System.Private.CoreLib.dll!System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__12<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.MoveNext(System.Threading.Thread threadPoolThread) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__12<System.__Canon>>.MoveNext() Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.TaskAwaiter.OutputWaitEtwEvents.AnonymousMethod__12_0(System.Action innerContinuation, System.Threading.Tasks.Task innerTask) Unknown
System.Private.CoreLib.dll!System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(System.Action action, bool allowInlining) Unknown
System.Private.CoreLib.dll!System.Threading.Tasks.Task.RunContinuations(object continuationObject) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.SetExistingTaskResult(System.Threading.Tasks.Task<System.Threading.Tasks.VoidTaskResult> task, System.Threading.Tasks.VoidTaskResult result) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder.SetResult() Unknown
[Completed] EFCore.BulkExtensions.SqlServer.dll!EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.InsertAsync<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>(Microsoft.EntityFrameworkCore.DbContext context, System.Type type, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem> entities, EFCore.BulkExtensions.TableInfo tableInfo, System.Action progress, System.Threading.CancellationToken cancellationToken) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__5<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.ExecutionContextCallback(object s) Unknown
System.Private.CoreLib.dll!System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__5<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.MoveNext(System.Threading.Thread threadPoolThread) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__5<System.__Canon>>.MoveNext() Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.TaskAwaiter.OutputWaitEtwEvents.AnonymousMethod__12_0(System.Action innerContinuation, System.Threading.Tasks.Task innerTask) Unknown
System.Private.CoreLib.dll!System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(System.Action action, bool allowInlining) Unknown
System.Private.CoreLib.dll!System.Threading.Tasks.Task.RunContinuations(object continuationObject) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.SetExistingTaskResult(System.Threading.Tasks.Task<System.Threading.Tasks.VoidTaskResult> task, System.Threading.Tasks.VoidTaskResult result) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder.SetResult() Unknown
[Completed] EFCore.BulkExtensions.SqlServer.dll!EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.InsertAsync<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>(Microsoft.EntityFrameworkCore.DbContext context, System.Type type, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem> entities, EFCore.BulkExtensions.TableInfo tableInfo, System.Action progress, bool isAsync, System.Threading.CancellationToken cancellationToken) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__6<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.ExecutionContextCallback(object s) Unknown
System.Private.CoreLib.dll!System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__6<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>>.MoveNext(System.Threading.Thread threadPoolThread) Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.AsyncTaskMethodBuilder<System.Threading.Tasks.VoidTaskResult>.AsyncStateMachineBox<EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__6<System.__Canon>>.MoveNext() Unknown
System.Private.CoreLib.dll!System.Runtime.CompilerServices.TaskAwaiter.OutputWaitEtwEvents.AnonymousMethod__12_0(System.Action innerContinuation, System.Threading.Tasks.Task innerTask) Unknown
System.Private.CoreLib.dll!System.Threading.Tasks.AwaitTaskContinuation.System.Threading.IThreadPoolWorkItem.Execute() Unknown
System.Private.CoreLib.dll!System.Threading.ThreadPoolWorkQueue.Dispatch() Unknown
System.Private.CoreLib.dll!System.Threading.PortableThreadPool.WorkerThread.WorkerThreadStart() Unknown
[Async Call Stack]
[Async] EFCore.BulkExtensions.SqlServer.dll!EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.ReadAsync<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>(Microsoft.EntityFrameworkCore.DbContext context, System.Type type, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem> entities, EFCore.BulkExtensions.TableInfo tableInfo, System.Action progress, System.Threading.CancellationToken cancellationToken) Unknown
[Async] EFCore.BulkExtensions.SqlServer.dll!EFCore.BulkExtensions.SqlBulkOperation.ReadAsync<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>(Microsoft.EntityFrameworkCore.DbContext context, System.Type type, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem> entities, EFCore.BulkExtensions.TableInfo tableInfo, System.Action progress, System.Threading.CancellationToken cancellationToken) Unknown
[Async] EFCore.BulkExtensions.SqlServer.dll!EFCore.BulkExtensions.DbContextBulkTransaction.ExecuteAsync<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>(Microsoft.EntityFrameworkCore.DbContext context, System.Type type, System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem> entities, EFCore.BulkExtensions.OperationType operationType, EFCore.BulkExtensions.BulkConfig bulkConfig, System.Action progress, System.Threading.CancellationToken cancellationToken) Unknown
[Async] A365.AMI.SupplierItems.Transformers.dll!A365.AMI.SupplierItems.Transformers.Persistence.Repositories.BaseRepository<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem>.BulkReadAsync(System.Collections.Generic.IEnumerable<A365.AMI.SupplierItems.Transformers.Domain.Entities.SupplierItem> entities, EFCore.BulkExtensions.BulkConfig bulkConfig, System.Threading.CancellationToken cancellationToken) Unknown
The text was updated successfully, but these errors were encountered: