예제 #1
0
        public void Can_Persist_Nullable_Enum_To_Numeric_Column()
        {
            var db = SqlServerNorthwindDatabase();

            using (var tx = db.EnsureInTransaction()) {
                var table = db.Table <Enum.NullableToNumericColumn.Product>();

                var item = new Enum.NullableToNumericColumn.Product {
                    CategoryID  = Enum.CategoryEnum.Beverages,
                    ProductName = ""
                };

                table.Add(item);

                Assert.AreEqual(1, table.Count("ProductID = {0} AND CategoryID = {1}", item.ProductID, item.CategoryID));

                tx.Rollback();
            }
        }
예제 #2
0
        public void Can_Persist_Nullable_Enum_To_Numeric_Column()
        {
            var db = new Database(conn, new AttributeMappingSource().GetModel(typeof(Enum.NullableToNumericColumn.Product)));

            using (var tx = db.EnsureInTransaction()) {
                var table = db.Table <Enum.NullableToNumericColumn.Product>();

                var item = new Enum.NullableToNumericColumn.Product {
                    CategoryID  = Enum.CategoryEnum.Beverages,
                    ProductName = ""
                };

                table.Add(item);

                Assert.AreEqual(1, table.Count("ProductID = {0} AND CategoryID = {1}", item.ProductID, item.CategoryID));

                tx.Rollback();
            }
        }
예제 #3
0
        public void Can_Persist_Nullable_Enum_To_Numeric_Column()
        {
            var db = new Database(conn, new AttributeMappingSource().GetModel(typeof(Enum.NullableToNumericColumn.Product)));

             using (var tx = db.EnsureInTransaction()) {

            var table = db.Table<Enum.NullableToNumericColumn.Product>();

            var item = new Enum.NullableToNumericColumn.Product {
               CategoryID = Enum.CategoryEnum.Beverages,
               ProductName = ""
            };

            table.Add(item);

            Assert.AreEqual(1, table.Count("ProductID = {0} AND CategoryID = {1}", item.ProductID, item.CategoryID));

            tx.Rollback();
             }
        }