Bug: An identify field parameter issue is being thrown when invoking the MergeAll operation dynamically

[mikependon]

Bug Description

When the method MergeAll is being invoked via dynamic approach, an identity field parameter issue is being thrown if the underlying schema/table has an identify field and if it weren't provided via the supplied list of dynamic objects even the other fields were defined as the qualifiers.

Exception Message:

Microsoft.Data.SqlClient.SqlException: 'Must declare the scalar variable "@id".
Statement(s) could not be prepared.'

Schema and Model:

Created adhocly, see below.

CREATE TABLE [sales].[Person]
(
	[Id] INT IDENTITY
	, [Name] NVARCHAR(256)
	, [DateOfBirth] DATETIME2(7)
	, [Address] NVARCHAR(MAX)
	, [DateInsertedUtc] DATETIME2(7)
) ON [PRIMARY];

No underlying model/class since the invocation is dynamic.

How to Replicate?

Simply call the method like below.

var people = new object[]
{
	new { Name = "Name1", DateOfBirth = DateTime.UtcNow.AddYears(-30), Address = "Address1", DateInsertedUtc = DateTime.UtcNow },
	new { Name = "Name2", DateOfBirth = DateTime.UtcNow.AddYears(-25), Address = "Address2", DateInsertedUtc = DateTime.UtcNow },
	new { Name = "Name3", DateOfBirth = DateTime.UtcNow.AddYears(-35), Address = "Address3", DateInsertedUtc = DateTime.UtcNow }
};
connection.MergeAll("[sales].[Person]", people, qualifiers: Field.From("Name", "Address"));

Library Version:

Example: RepoDb v1.12.8-beta4 and RepoDb.SqlServer v1.1.3

[mikependon]

This will be available on the next version > RepoDb v1.12.8-beta4.