public void Can_Clear_SelectCommandBuilder()
{
// Arrange
var command = new SelectCommandBuilder()
.DistinctValues()
.WithTop(1)
.From("Table2")
.Select("Field4", "Field5", "Field6");
// Act
var actual = command.Clear()
.From("Table")
.Select(new List <string>(new[] { "Field1", "Field2", "Field3" })) // use enumerable, works as well
.Build();
// Assert
actual.CommandText.Should().Be("SELECT Field1, Field2, Field3 FROM Table");
}