public void ReturnsAlterNonclusteredIndexesCommand()
{
// Arrange
var connection = new SqlConnection();
var tableName = "myTableName";
var action = "DISABLE";
// Act
var command = SqlConnectionExtensions.GetAlterNonclusteredIndexesCommand(connection, tableName, action);
// Assert
Assert.Equal(@"DECLARE @sql AS nvarchar(max) = '';
SELECT @sql = @sql + 'ALTER INDEX ' + QUOTENAME(sys.indexes.name) + ' ON ' + QUOTENAME(sys.objects.name) + ' ' + @action + ';' + CHAR(13) + CHAR(10)
FROM sys.indexes
JOIN sys.objects ON sys.indexes.object_id = sys.objects.object_id
WHERE sys.indexes.type_desc = 'NONCLUSTERED'
AND sys.objects.type_desc = 'USER_TABLE'
AND sys.objects.name = @tableName;
EXEC(@sql);", command.CommandText, ignoreLineEndingDifferences: true);
Assert.True(command.Parameters.Contains("@tableName"));
}
