public void UpdateWhenMatchedIsTrue_ReturnsMergeCommandWithUpdateWhenMatched()
{
// Arrange
var connection = new SqlConnection();
var targetTable = "myTableName";
var tableSource = "myTableSource";
var columns = new[]
{
"key_part_1",
"key_part_2",
"nullable_text",
"nullable_number",
"nullable_datetimeoffset",
"nullable_money",
"nullable_varbinary",
"nullable_image",
};
var primaryKeyColumns = new[]
{
"key_part_1",
"key_part_2",
};
var updateWhenMatched = true;
// Act
var command = SqlConnectionExtensions.GetMergeCommand(connection, targetTable, tableSource, columns, primaryKeyColumns, updateWhenMatched);
// Assert
Assert.Equal(@"MERGE INTO [myTableName] AS [Target]
USING [myTableSource] AS [Source]
ON ([Target].[key_part_1] = [Source].[key_part_1] AND [Target].[key_part_2] = [Source].[key_part_2])
WHEN MATCHED
THEN
UPDATE
SET [Target].[nullable_text] = [Source].[nullable_text],
[Target].[nullable_number] = [Source].[nullable_number],
[Target].[nullable_datetimeoffset] = [Source].[nullable_datetimeoffset],
[Target].[nullable_money] = [Source].[nullable_money],
[Target].[nullable_varbinary] = [Source].[nullable_varbinary],
[Target].[nullable_image] = [Source].[nullable_image]
WHEN NOT MATCHED
THEN
INSERT ([key_part_1], [key_part_2], [nullable_text], [nullable_number], [nullable_datetimeoffset], [nullable_money], [nullable_varbinary], [nullable_image])
VALUES ([key_part_1], [key_part_2], [nullable_text], [nullable_number], [nullable_datetimeoffset], [nullable_money], [nullable_varbinary], [nullable_image]);
", command.CommandText, ignoreLineEndingDifferences: true);
}
