BulkInsertAsync fails with SqlServer on .NET 10 and Entity Framework Core 10.0.0

[Tim-Paaschen]

I use BulkInsertAsync in an application with an Azure SqlServer.

It worked fine, when the project uses .NET 8 with Entity Framework Core 9.0.11 and BulkExtensions 8.1.3.
After upgrading to .NET 10, Entity Framework Core 10.0.0 and BulkExtensions 9.0.2 a call to BulkInsertAsync results in an exception:

System.MissingMethodException:
'Method not found: 'Boolean Microsoft.EntityFrameworkCore.Metadata.IReadOnlyNavigationBase.get_IsCollection()'.'

[Tim-Paaschen]

Downgrading Entity Framework Core to version 9.0.11 temporarily resolves the problem.

[abeckham7305]

I am seeing this same issue. I'm not sure downgrading Entity Framework Core is going to be an option for me. I don't expect EFCore.BulkExtensions 9.0.2 to work with .NET 10, though I was hoping it would. I wonder if there is a timeline for when .NET 10 support will be available for it?

[EikeSchwass]

I am seeing this same issue. I'm not sure downgrading Entity Framework Core is going to be an option for me. I don't expect EFCore.BulkExtensions 9.0.2 to work with .NET 10, though I was hoping it would. I wonder if there is a timeline for when .NET 10 support will be available for it?

There a 2 preview packages available for .NET 10 (only SqlServer though).
When upgrading to that version you get a different Exception (on BulkRead):

System.Reflection.TargetInvocationException: 'Exception has been thrown by the target of an invocation.'
Inner Exception: NotSupportedException: Specified method is not supported.
This exception was originally thrown at this call stack:
    System.Delegate.BindToMethodInfo(object, System.IRuntimeMethodInfo, System.RuntimeType, System.DelegateBindingFlags)
    System.Delegate.CreateDelegateInternal(System.RuntimeType, System.Reflection.RuntimeMethodInfo, object, System.DelegateBindingFlags)
    System.Reflection.RuntimeMethodInfo.CreateDelegateInternal(System.Type, object, System.DelegateBindingFlags)
    System.Linq.Expressions.Interpreter.FuncCallInstruction<T0, TRet>.FuncCallInstruction(System.Reflection.MethodInfo)
    System.Reflection.MethodBaseInvoker.InvokeWithOneArg(object, System.Reflection.BindingFlags, System.Reflection.Binder, object[], System.Globalization.CultureInfo)

If that also happens on BulkWrite I can't tell.

See also #1755 (comment)

[abeckham7305]

I am seeing this same issue. I'm not sure downgrading Entity Framework Core is going to be an option for me. I don't expect EFCore.BulkExtensions 9.0.2 to work with .NET 10, though I was hoping it would. I wonder if there is a timeline for when .NET 10 support will be available for it?

There a 2 preview packages available for .NET 10 (only SqlServer though). When upgrading to that version you get a different Exception (on BulkRead):

System.Reflection.TargetInvocationException: 'Exception has been thrown by the target of an invocation.'
Inner Exception: NotSupportedException: Specified method is not supported.
This exception was originally thrown at this call stack:
    System.Delegate.BindToMethodInfo(object, System.IRuntimeMethodInfo, System.RuntimeType, System.DelegateBindingFlags)
    System.Delegate.CreateDelegateInternal(System.RuntimeType, System.Reflection.RuntimeMethodInfo, object, System.DelegateBindingFlags)
    System.Reflection.RuntimeMethodInfo.CreateDelegateInternal(System.Type, object, System.DelegateBindingFlags)
    System.Linq.Expressions.Interpreter.FuncCallInstruction<T0, TRet>.FuncCallInstruction(System.Reflection.MethodInfo)
    System.Reflection.MethodBaseInvoker.InvokeWithOneArg(object, System.Reflection.BindingFlags, System.Reflection.Binder, object[], System.Globalization.CultureInfo)

If that also happens on BulkWrite I can't tell.

See also #1755 (comment)

Really helpful! Thanks for posting the related issue. I was wondering why I couldn't find the pre-release. I was looking at the overall package, not the SQL Server specific one. That may be an option. Thanks!

[Tim-Paaschen]

On the first glance BulkExtensions 10.0.0-rc2 seems to work with EFCore 10.0.0 in my application. Thanks for mentioning the pre-release packages.