SqlException on V1_2/Capture Endpoint (Capture Masterdata)

[vicmgj]

Environment

• Database Provider: SqlServer
• Runtime: .net8

Issue

When interacting with the V1_2/Capture endpoint there appears to be a SqlException getting triggered with the Masterdata XML example (from the Postman Sandbox). Upon dumping the contents of the SaveChangesAsync() call embedded in the StoreAsync(Request request, CancellationToken cancellationToken) : CaptureHandler.cs method, SQL Profiler showed us that it's attempting to insert this query.

INSERT INTO [Cbv].[MasterDataChildren] 
([ChildrenId], [MasterDataId], [MasterDataRequestId], [MasterDataType], [MasterdataId], [MasterdataType])
VALUES 
(@p104, @p105, @p106, @p107, @p108, @p109),
(@p110, @p111, @p112, @p113, @p114, @p115),
(@p116, @p117, @p118, @p119, @p120, @p121);

The insert manages to have values for the first three properties of the insert statement, but the latter two do not - instead defaulting to null. From looking around I was not able to find a relationship linking the MasterdataId and MasterdataType properties to the MasterDataChildren table. Those appear to only be properties referenced within the MasterDataAttribute table. I did notice that the MasterDataChildren has a link to MasterData which contains a list of MasterDataAttribute's, potentially creating a link between the two?

All that being said, I was hoping you could provide any insight on how the DbContext is suggesting those two properties - MasterdataId and MasterdataType - belong to the MasterDataChildren type within the insert statement.

Thanks!