Open cervengoc opened 3 months ago
Just as an addition, it seems like the key here is not the IncludeGraph
option, but the SetOutputIdentity = true
option (which I guess is set implicitly when using IncludeGraph
). The issue is reproducible by trying to bulk-insert addresses with SetOutputIdentity = true
. I've also tried IgnoreGlobalQueryFilters = true
option (found in another, possibly related issue), but it makes no difference. In my case I don't even have a global filter on this table (Address)
Hi, first or all, thank you for all the efforts put into this library.
We're in the middle of trying to migrate our codebase from MSSQL to PostgreSQL, and have some difficoulties around bulk operations.
Before anything else, I'd like to emphasize that we're on .NET version 6, including related framework packages (
EFCore
,EFCore.Bulkextensions
, etc. Namely we're using version6.8.1
from bulk extensions. Unfortunately this is a hard constraint and we cannot put the huge efforts into upgrading to latest, or even to7.x
.We have a model similar to this (simplified)
Type
Coordinates
is an owned type byAddress
, so it maps to columns likecoordinates_x
and so.When calling
BulkInsert
on companies (using IncludeGraph), we get the following query in one of the commands, which producessyntax error at or near "INTO"
SQL exception.SELECT .... FROM (INSERT INTO ...)
structure.Any tips or advices are highly appreciated, thank you in advance.