Пример #1
0
 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));
 }
Пример #2
0
 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));
 }
Пример #3
0
 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));
 }
Пример #4
0
 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));
 }
Пример #5
0
 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));
 }