public void ToSqlTextTest01()
{
string expected = "SELECT Field00, Field01 FROM Customs WHERE Id = '0011'";
SQLTextBuilder target = new SQLTextBuilder();
target.Action = SQLText.Action.Select;
target.Field.Set("Field00", "Field01");
target.From.Set("Customs");
target.Where.Set("Id", SQLText.CompareOperation.Equal, DbType.String, "0011");
Assert.AreEqual(expected, target.ToSqlText());
}
public void ToSqlTextTest02()
{
string expected = "SELECT CustomerID, CompanyName, ContactTitle, City FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders)";
SQLTextBuilder target = new SQLTextBuilder();
target.Action = SQLText.Action.Select;
target.Field.Set("CustomerID", "CompanyName", "ContactTitle", "City");
target.From.Set("Customers");
SQLTextBuilder ta = new SQLTextBuilder();
ta.Action = SQLText.Action.Select;
ta.Field.Set("CustomerID");
ta.From.Set("Orders");
SQLInTextBuilder inb = new SQLInTextBuilder();
inb.Set(ta);
target.Where.Set("CustomerID", SQLText.CompareOperation.In, DbType.String, inb);
Assert.AreEqual(expected, target.ToSqlText());
}