public void TestMethodTable() { var db = new PetaPoco.Database(connectionString, providerName); var keyObjectStore = new SqlKeyObjectStore(db); using (var myTable = keyObjectStore.Table<string>("myTable")) { myTable.Empty(); var firstId = myTable.Insert("foo"); var secondId = myTable.Insert("bar"); var thirdId = myTable.Insert("THREE"); var second = myTable.Select(secondId); Assert.AreEqual("bar", second); myTable.Delete(secondId); var secondIsDeleted = myTable.Select(secondId); Assert.IsNull(secondIsDeleted); var all = myTable.All(); Assert.AreEqual(2, all.Count()); } }
public void TestMethodTypedOwners() { var db = new PetaPoco.Database(connectionString, providerName); var keyObjectStore = new SqlKeyObjectStore(db, keyObjectTableName: "TableWithIndexes3"); var ownerStore1 = keyObjectStore.GetStore("owner1"); var ownerStore2 = keyObjectStore.GetStore("owner2"); var defaultStoreTable = keyObjectStore.Table<string>("table"); var owner1Table = ownerStore1.Table<string>("table"); var owner2Table = ownerStore2.Table<string>("table"); defaultStoreTable.Empty(); owner1Table.Empty(); owner2Table.Empty(); owner1Table.Insert("Foo"); var getFromDefaultStore = defaultStoreTable.All(); var getFromOwner1 = owner1Table.All(); var getFromOwner2 = owner2Table.All(); Assert.AreEqual(0, getFromDefaultStore.Count()); Assert.AreEqual(1, getFromOwner1.Count()); Assert.AreEqual(0, getFromOwner2.Count()); }
public void TestMethodTypedTable() { var db = new PetaPoco.Database(connectionString, providerName); var keyObjectStore = new SqlKeyObjectStore(db); using (var myTable = keyObjectStore.Table<SomeType>()) // stored in "SomeType" by default { myTable.Empty(); var firstId = myTable.Insert(new SomeType { SomeValue = 100, SomeGuid = Guid.NewGuid(), SomeOtherValue = 1.1M }); var secondId = myTable.Insert(new SomeType { SomeValue = 200, SomeGuid = Guid.NewGuid(), SomeOtherValue = 2.2M }); var thirdId = myTable.Insert(new SomeType { SomeValue = 300, SomeGuid = Guid.NewGuid(), SomeOtherValue = 3.3M }); var second = myTable.Select(secondId); Assert.AreEqual(200,second.SomeValue); Assert.AreEqual(2.2M, second.SomeOtherValue); Assert.AreEqual(400, second.SomeFunction()); var all = myTable.All(); var sum = all.Sum(t => t.SomeOtherValue); Assert.AreEqual(6.6M, sum); } }