public virtual void Properties3OrderBy()
{
Srt2.SqlQueries.Delete select = DeleteCustomer();
select.Add(new Field("CustomerName"));
select.OrderBy.Add(new OrderByField("ContactName", true));
string statement = select.ToString(DbConnectionType);
Assert.AreEqual(Expected, statement);
}
public void Properties2Where()
{
Srt2.SqlQueries.Delete select = DeleteCustomer();
select.Add(new EqualToValue("City", "Berlin"));
select.Add(new Equal("CustomerName", "ContactName"));
string statement = select.ToString(DbConnectionType);
Assert.AreEqual(Expected, statement);
}
public virtual void Constructor2OrderBy()
{
Srt2.SqlQueries.Delete select = new Srt2.SqlQueries.Delete
{
From = { "[TestDatabase].[Dbo].[Customers]" },
OrderBy = { "CustomerName" }
};
select.OrderByFieldDescending("ContactName");
string statement = select.ToString(DbConnectionType);
Assert.AreEqual(Expected, statement);
}