public void Properties1Where()
{
Srt2.SqlQueries.Update select = UpdateCustomer().Set("CustomerName", "Boel Namen");
select.Where.Add(new EqualToValue("City", "Berlin"));
string statement = select.ToString(DbConnectionType);
Assert.AreEqual(Expected, statement);
}
public void ConstructorWhere()
{
string statement = new Srt2.SqlQueries.Update("[TestDatabase].[Dbo].[Customers]").Set("CustomerName", "Boel Namen")
.Where("City", "Berlin")
.ToString(DbConnectionType);
Assert.AreEqual(Expected, statement);
}
public void Fluent1()
{
string statement = new Srt2.SqlQueries.Update().Table("[TestDatabase].[Dbo].[Customers]").Set("CustomerName", "Boel Namen").Set("ContactName", "Boel Namen").ToString(DbConnectionType);
Assert.AreEqual(Expected, statement);
}
