public void TestAddSelectFields()
{
//-------------Setup Test Pack ------------------
const string startSql = "select [FALSE FROM CLAUSE], [FALSE WHERE CLAUSE] from bob WHERE that = this";
var builder = new SqlStatementBuilder(_connection, startSql);
var fields = new List <string> {
"myField1", "myField2"
};
const string expectedSql = "select [FALSE FROM CLAUSE], [FALSE WHERE CLAUSE], [myField1], [myField2] from bob WHERE that = this";
//-------------Execute test ---------------------
builder.AddSelectFields(fields);
var actual = builder.GetStatement().Statement.ToString();
//-------------Test Result ----------------------
Assert.AreEqual(expectedSql, actual);
}