public void NullableSumTest() { SQLiteConnection db = new TestDb(); db.CreateTable <NullableIntClass>(); var r = db.ExecuteScalar <int>("SELECT SUM(NullableInt) FROM NullableIntClass WHERE 1 = 0"); Assert.AreEqual(0, r); }
public void CanUseSubtypeOfTableAttribute() { var db = new TestDb(); db.CreateTable <Cat>(); db.Insert(new Cat() { Breed = "Siamese" }); int numCats = db.ExecuteScalar <int>("select count(*) from Cats"); Assert.That(numCats, Is.EqualTo(1), "The resulting num cats should be 1."); }