public void SelectAllFrom_UseCache()
{
var value = new TableWithGuid
{
Id = Guid.NewGuid(),
Text = "Text"
};
connection.Save(value);
var parent = new ParentTableWithGuid {
Key = Guid.NewGuid(), Reference = value
};
connection.Save(parent);
var grandParent = new GrandParentWithGuid {
Key = Guid.NewGuid(), Reference = parent
};
connection.Save(grandParent);
value = connection.Get <TableWithGuid>(value.Id);
var all = connection.SelectAllFrom <GrandParentWithGuid>().Where(x => x.Reference == parent).ToList();
Assert.Equal(value, all[0].Reference.Reference);
Assert.Equal("Text", value.Text);
}
public void Load_ObjectWithGuid_WithAutoJoin()
{
var value = new TableWithGuid
{
Id = Guid.NewGuid(),
Text = "Text"
};
connection.Save(value);
var parent = new ParentTableWithGuid
{
Key = Guid.NewGuid(),
Text = "Parent",
Reference = value
};
connection.Save(parent);
var result = connection.Load <ParentTableWithGuid>(parent.Key, x => x.Reference);
Assert.Equal(parent.Key, result.Key);
Assert.Equal(parent.Text, result.Text);
Assert.Equal(value.Id, parent.Reference.Id);
Assert.Equal(value.Text, parent.Reference.Text);
}