22P03: incorrect binary data format

[choby]

I'm using EFCore.BulkExtensions latest version with Postgresql and ef core 6.x . I update some entities and call BulkUpdateAsync , but I get the following error:

{"22P03: incorrect binary data format"}

Stacktrace:

在 Npgsql.Internal.NpgsqlConnector.<<ReadMessage>g__ReadMessageLong|211_0>d.MoveNext()
   在 Npgsql.NpgsqlBinaryImporter.<Complete>d__39.MoveNext()
   在 EFCore.BulkExtensions.SQLAdapters.PostgreSql.PostgreSqlAdapter.<InsertAsync>d__2`1.MoveNext()
   在 EFCore.BulkExtensions.SQLAdapters.PostgreSql.PostgreSqlAdapter.<InsertAsync>d__2`1.MoveNext()
   在 EFCore.BulkExtensions.SQLAdapters.PostgreSql.PostgreSqlAdapter.<InsertAsync>d__1`1.MoveNext()
   在 EFCore.BulkExtensions.SQLAdapters.PostgreSql.PostgreSqlAdapter.<MergeAsync>d__6`1.MoveNext()
   在 EFCore.BulkExtensions.SQLAdapters.PostgreSql.PostgreSqlAdapter.<MergeAsync>d__6`1.MoveNext()
   在 EFCore.BulkExtensions.SQLAdapters.PostgreSql.PostgreSqlAdapter.<MergeAsync>d__5`1.MoveNext()
   在 EFCore.BulkExtensions.SqlBulkOperation.<MergeAsync>d__5`1.MoveNext()
   在 EFCore.BulkExtensions.DbContextBulkTransaction.<ExecuteAsync>d__1`1.MoveNext()
   在 Evo.Scm.EntityFrameworkCore.BulkOperationProvider.<UpdateManyAsync>d__7`2.MoveNext() 在 D:\Work\致轩\EVO\evo-scm-backend\src\Evo.Scm.EntityFrameworkCore\EntityFrameworkCore\BulkOperationProvider.cs 中: 第 165 行
   在 Volo.Abp.Domain.Repositories.EntityFrameworkCore.EfCoreRepository`2.<UpdateManyAsync>d__23.MoveNext()
   在 Castle.DynamicProxy.AsyncInterceptorBase.<ProceedAsynchronous>d__13.MoveNext()
   在 Volo.Abp.Castle.DynamicProxy.CastleAbpMethodInvocationAdapter.<ProceedAsync>d__7.MoveNext()
   在 Volo.Abp.Uow.UnitOfWorkInterceptor.<InterceptAsync>d__2.MoveNext()
   在 Volo.Abp.Castle.DynamicProxy.CastleAsyncAbpInterceptorAdapter`1.<InterceptAsync>d__2.MoveNext()
   在 Evo.Scm.DesignStyles.DesignStyleManager.<UpdateStatus>d__10.MoveNext() 在 D:\Work\致轩\EVO\evo-scm-backend\src\Evo.Scm.Domain\DesignStyles\DesignStyleManager.cs 中: 第 70 行

[borisdj]

Can you write a test where the issue would be reproducible

[joaofx]

Hey @choby! I was having this same problem months ago and gave up using this library. After .NET 7 and EFCore 7 update, and using EFCore.BulkExtensions's last version, everything is working for me so far. Maybe give a second try after updating your project. Good luck!