public void ConstructorWhere()
{
string statement = new Srt2.SqlQueries.Delete("[TestDatabase].[Dbo].[Customers]")
.Where("City", "Berlin")
.WhereField("CustomerName", SqlOperator.Equal, "ContactName")
.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 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 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);
}
public virtual void FluentTop()
{
string statement = new Srt2.SqlQueries.Delete().From("[TestDatabase].[Dbo].[Customers]").Top(10).ToString(DbConnectionType);
Assert.AreEqual(TopExpected, statement);
}
public void Constructor()
{
string statement = new Srt2.SqlQueries.Delete("[TestDatabase].[Dbo].[Customers]").ToString(DbConnectionType);
Assert.AreEqual(Expected, statement);
}
