public void LazyLoadTest()
{
var ownerObj = new TestObjWithOne2One {
Id = 1, Text = "Test1"
};
ownerObj.Obj1 = new TestDependentObj2 {
Text = "Obj1", OwnerId = 1
};
ownerObj.Obj2 = new TestDependentObj3 {
Text = "Obj2", OwnerId = 1
};
_db.InsertOrReplace(ownerObj);
var resultObj = _db.Table <TestObjWithOne2One>().First(x => x.Id == 1);
var resultDependentObj = _db.Table <TestDependentObj3>().First(x => x.OwnerId == 1);
Assert.AreEqual("Obj1", resultObj.Obj1.Text);
Assert.AreEqual(null, resultObj.Obj2);
Assert.AreEqual("Obj2", resultDependentObj.Text);
}
public void InsertOrReplaceWithOne2One()
{
var ownerObj = new TestObjWithOne2One {
Id = 1, Text = "Test1"
};
ownerObj.Obj1 = new TestDependentObj2 {
Text = "DependentObj1", OwnerId = 1
};
_db.InsertOrReplace(ownerObj);
var tmpObject = _db.Table <TestObjWithOne2One>().First();
tmpObject.Text = "Test2";
_db.InsertOrReplace(tmpObject);
var resultObjs = _db.Table <TestObjWithOne2One>().ToList();
Assert.AreEqual(1, resultObjs.Count);
Assert.AreEqual("Test2", resultObjs[0].Text);
}
public void LazyLoadTest()
{
var ownerObj = new TestObjWithOne2One {Id = 1, Text = "Test1"};
ownerObj.Obj1 = new TestDependentObj2{Text = "Obj1", OwnerId = 1};
ownerObj.Obj2 = new TestDependentObj3{Text = "Obj2", OwnerId = 1};
_db.InsertOrReplace(ownerObj);
var resultObj = _db.Table<TestObjWithOne2One>().First(x => x.Id == 1);
var resultDependentObj = _db.Table<TestDependentObj3>().First(x => x.OwnerId == 1);
Assert.AreEqual("Obj1",resultObj.Obj1.Text);
Assert.AreEqual(null,resultObj.Obj2);
Assert.AreEqual("Obj2",resultDependentObj.Text);
}
public void InsertOrReplaceWithOne2One()
{
var ownerObj = new TestObjWithOne2One {Id = 1, Text = "Test1"};
ownerObj.Obj1 = new TestDependentObj2{Text = "DependentObj1", OwnerId = 1};
_db.InsertOrReplace(ownerObj);
var tmpObject = _db.Table<TestObjWithOne2One>().First();
tmpObject.Text = "Test2";
_db.InsertOrReplace(tmpObject);
var resultObjs = _db.Table<TestObjWithOne2One>().ToList();
Assert.AreEqual(1, resultObjs.Count);
Assert.AreEqual("Test2",resultObjs[0].Text);
}
