示例#1
0
        public void Contains()
        {
            var db = SqlServerNorthwindDatabase();

            SqlSet <SqlSetAnnotated.Model1.Product> table = db.Table <SqlSetAnnotated.Model1.Product>();

            var prod1 = table.Single("ProductID = 1");

            Assert.IsTrue(table.Contains(prod1));
            Assert.IsFalse(table.Where("ProductID = 2").Contains(prod1));
        }
示例#2
0
        public void Remember_Mapper()
        {
            Database db = SqlServerDatabase();

            SqlSet <string> set = db.From(SQL
                                          .SELECT("'a' AS c")
                                          , r => r.GetString(0))
                                  .OrderBy("c");

            string value = set.Single();
        }