当前位置: 首页>>代码示例>>C#>>正文


C# SelectQuery.GreatherThanOrEqual方法代码示例

本文整理汇总了C#中SelectQuery.GreatherThanOrEqual方法的典型用法代码示例。如果您正苦于以下问题:C# SelectQuery.GreatherThanOrEqual方法的具体用法?C# SelectQuery.GreatherThanOrEqual怎么用?C# SelectQuery.GreatherThanOrEqual使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SelectQuery的用法示例。


在下文中一共展示了SelectQuery.GreatherThanOrEqual方法的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;
//.........这里部分代码省略.........
开发者ID:sadiq81,项目名称:AWSSimpleDBPersistence,代码行数:101,代码来源:TestDAO.cs


注:本文中的SelectQuery.GreatherThanOrEqual方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。