public void Test5() { Condition c = Condition.Empty; c = c.And(CK.K["Id"].Eq(1)).Or(CK.K["Age"].Gt(18)); var cc = new WhereClause(c); var dpc = new DataParameterCollection(); Assert.AreEqual(" WHERE ([Id] = @Id_0) OR ([Age] > @Age_1)", cc.ToSqlText(dpc, new Access(), null)); }
public void Test3() { Condition c = Condition.Empty; c = ((c & null) | null); var cc = new WhereClause(c); var dpc = new DataParameterCollection(); Assert.AreEqual("", cc.ToSqlText(dpc, new Access(), null)); }
public void Test4() { Condition c = Condition.Empty; c &= (CK.K["Id"] == 1 | CK.K["Age"] > 18); var cc = new WhereClause(c); var dpc = new DataParameterCollection(); Assert.IsFalse(c is EmptyCondition); Assert.AreEqual(" WHERE ([Id] = @Id_0) OR ([Age] > @Age_1)", cc.ToSqlText(dpc, new Access(), null)); }
public void Test6() { Condition c = null; c &= (CK.K["Id"] == 1 | CK.K["Age"] > 18); c &= null; c |= null; c &= CK.K["Gender"] == true; var cc = new WhereClause(c); var dpc = new DataParameterCollection(); Assert.AreEqual(" WHERE (([Id] = @Id_0) OR ([Age] > @Age_1)) AND ([Gender] = @Gender_2)", cc.ToSqlText(dpc, new Access(), null)); }
public void Test8() { Condition c = Condition.Empty; c = c.And(CK.K["Id"] == 1).Or(CK.K["Age"] > 18); c = c.And(null); c = c.Or(null); c = c.And(CK.K["Gender"].Eq(true)); var cc = new WhereClause(c); var dpc = new DataParameterCollection(); Assert.AreEqual(" WHERE (([Id] = @Id_0) OR ([Age] > @Age_1)) AND ([Gender] = @Gender_2)", cc.ToSqlText(dpc, new Access(), null)); }