public void Static_Class_With_Nested_And_Or()
{
var whereClause = Are.AreAllOfTheseTrue(Column.Named("Foo").IsEqualTo(0), Are.AnyOfTheseTrue(Column.Named("Bar").IsEqualTo(1), Column.Named("Baz").IsEqualTo(2)));
Assert.AreEqual <string>("(Foo = '0') AND ((Bar = '1') OR (Baz = '2'))", whereClause.ToString());
}
public void Fluent_And_With_Extension()
{
var whereClause = Column.Named("MerchantId").IsEqualTo(12).And(Column.Named("Status").IsEqualTo("Good"));
Assert.AreEqual <string>("(MerchantId = '12') AND (Status = 'Good')", whereClause.ToString());
}
public void Fluent_With_And()
{
var whereClause = Are.AreAllOfTheseTrue(Column.Named("Foo").IsOneOf(1, 2, 3), Column.Named("Bar").IsEqualTo(6));
Assert.AreEqual <string>("(Foo IN ('1','2','3')) AND (Bar = '6')", whereClause.ToString());
}
public void Factory_Method_For_Column()
{
var whereClause = new And(Column.Named("MerchantId").IsEqualTo(12), Column.Named("Status").IsEqualTo("Good"));
Assert.AreEqual <string>("(MerchantId = '12') AND (Status = 'Good')", whereClause.ToString());
}
