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); }