.NET 9 - BulkInsertOrUpdateOrDeleteAsync - Cannot get _selectExpression

[evicio1]

After upgrading to.NET 9, The following error comes up with BulkInsertOrUpdateOrDeleteAsync

Message

Cannot get _selectExpression

StackTrace

at EFCore.BulkExtensions.IQueryableExtensions.ToParametrizedSql(IQueryable query) at EFCore.BulkExtensions.BatchUtil.GetBatchSql(IQueryable query, DbContext context, Boolean isUpdate) at EFCore.BulkExtensions.SqlAdapters.SqlQueryBuilder.MergeTable[T](DbContext context, TableInfo tableInfo, OperationType operationType, IEnumerable1 entityPropertyWithDefaultValue)
at EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__91.MoveNext() at EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.<MergeAsync>d__91.MoveNext()
at EFCore.BulkExtensions.SqlAdapters.SqlServer.SqlServerAdapter.d__81.MoveNext() at EFCore.BulkExtensions.SqlBulkOperation.<MergeAsync>d__51.MoveNext()
at EFCore.BulkExtensions.DbContextBulkTransaction.d__11.MoveNext()

[borisdj]

It is not yet fully supported, waiting for Pomelo nuget dependency to release v9.
Excepting it to be this week, if not will try to update other packages and only MySql to prerelease.
Dupe of #1605

[svenclaesson]

We are using SQLite (in tests) and experience this error. It's still dependent on Pomelo MySql?

[borisdj]

Not sure, will check it out in a few days.

[Pete-PlaytimeSolutions]

Just an FYI on what I have found, when using against the "Microsoft.EntityFrameworkCore.SqlServer" Provider.

I think its failing in IQueryableExtensions.ToParametrizedSql method, due to one or more of the "enumerator" private fields no longer existing in net 9.0..

When running under net8.0, the private field "_relationalCommandCache" always seems to be populated,
whereas under net 9.0 if no longer exists.

i.e

string privateField = "_relationalCommandCache";
RelationalCommandCache relationalCommandCache = (RelationalCommandCache)enumerator.Private(privateField);

NOTE: When relationalCommandCache is null, the following fallback code does not work for either versions,
due to the private field "_selectExpression" not being available in either net8.0 or net 9.0.