本文整理汇总了C#中SelectQuery.Or方法的典型用法代码示例。如果您正苦于以下问题:C# SelectQuery.Or方法的具体用法?C# SelectQuery.Or怎么用?C# SelectQuery.Or使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SelectQuery
的用法示例。
在下文中一共展示了SelectQuery.Or方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: TestSelect
public void TestSelect()
{
//[SimpleDBDomain("TestDao")]
bool result = DAO.CreateTable ().Result;
Assert.AreEqual (true, result);
TestEntity entity = new TestEntity ();
entity.Id = 0;
//[SimpleDBField("TestString")]
entity.TestString = "plz";
//[SimpleDBField("TestBool")]
entity.TestBool = false;
//[SimpleDBField("TestByte",3)]
entity.TestByte = 244;
//[SimpleDBField("TestNegativeByte",3, 255)]
entity.TestNegativeByte = -50;
//[SimpleDBField("TestDecimal",5,1000)]
entity.TestDecimal = 500;
//[SimpleDBField("TestNegativeDecimal",5,1000)]
entity.TestNegativeDecimal = -500;
//[SimpleDBField("TestList")]
entity.TestList = new List<string> (new[]{ "hello", "dolly", "the", "sheep" });
bool result2 = DAO.SaveOrReplace (entity).Result;
Assert.AreEqual (true, result2);
//Equal
SelectQuery<TestEntity> query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.Equal ("TestString", "plz");
List<TestEntity> list = DAO.Select (query).Result;
Assert.AreEqual (1, list.Count);
TestEntity retreived = list [0];
AssertTestEntity (retreived);
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.Like ("TestString", "hello");
list = DAO.Select (query).Result;
Assert.AreEqual (0, list.Count);
//Or
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.Or ("TestString", "hello", "TestByte", "244");
list = DAO.Select (query).Result;
Assert.AreEqual (1, list.Count);
retreived = list [0];
AssertTestEntity (retreived);
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.Or ("TestString", "hello", "TestNegativeDecimal", "-500");
list = DAO.Select (query).Result;
Assert.AreEqual (1, list.Count);
retreived = list [0];
AssertTestEntity (retreived);
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.Or ("TestString", "hello", "TestByte", "243");
list = DAO.Select (query).Result;
Assert.AreEqual (0, list.Count);
//NotEqual
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.NotEqual ("TestString", "hello");
list = DAO.Select (query).Result;
Assert.AreEqual (1, list.Count);
retreived = list [0];
AssertTestEntity (retreived);
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.NotEqual ("TestString", "plz");
list = DAO.Select (query).Result;
Assert.AreEqual (0, list.Count);
//GreatherThan
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.GreatherThan ("TestDecimal", "499");
list = DAO.Select (query).Result;
Assert.AreEqual (1, list.Count);
retreived = list [0];
AssertTestEntity (retreived);
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.GreatherThan ("TestDecimal", "500");
list = DAO.Select (query).Result;
list = DAO.Select (query).Result;
Assert.AreEqual (0, list.Count);
//GreatherThanOrEqual
query = new SelectQuery<TestEntity> ();
query.ConsistentRead = true;
query.GreatherThanOrEqual ("TestDecimal", "500");
list = DAO.Select (query).Result;
//.........这里部分代码省略.........