public void AppendOrderBy()
{
//---------------Set up test pack-------------------
const string startSql = "select * from bob WHERE that = this";
var builder = new SqlStatementBuilder(_connection, startSql);
const string appendSql = "this";
const string expectedSql = startSql + " ORDER BY " + appendSql;
//---------------Execute Test ----------------------
builder.AppendOrderBy(appendSql);
var actual = builder.GetStatement().Statement.ToString();
//---------------Test Result -----------------------
Assert.AreEqual(expectedSql, actual);
}