public void BuildExpression_OrderBy() { MySQLBuilder sqlBuilder = new MySQLBuilder(); sqlBuilder.AddSelectClause("id"); sqlBuilder.AddFromClause("employees"); sqlBuilder.AddOrderByClause("name", SortDirection.Descending); StringBuilder stringBuilder = new StringBuilder(); sqlBuilder.BuildExpression(stringBuilder); Assert.AreEqual("SELECT DISTINCT id FROM employees ORDER BY name DESC;", stringBuilder.ToString()); }