public void TestMethodNestedOwners()
{
var db = new PetaPoco.Database(connectionString, providerName);
var keyObjectStore = new SqlKeyObjectStore(db,keyObjectTableName:"TableWithIndexes");
var ownerStore1 = keyObjectStore.GetStore("owner1");
var ownerStore11 = ownerStore1.GetStore("owner11");
var ownerStore12 = ownerStore1.GetStore("owner1"); // this owner1 is actually owner1.owner1
var defaultStoreTable = ownerStore1.Table<string>("table");
var owner1Table = ownerStore11.Table<string>("table");
var owner2Table = ownerStore12.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());
}
