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