public void TestCreateHiearchicalKey()
{
using (var context = GetContext())
{
var root = new HierarchicalKeyEntity {
Code = "root"
};
var child = new HierarchicalKeyEntity {
Parent = root, Code = "Child"
};
var grandchild = new HierarchicalKeyEntity {
Parent = child, Code = "Grandchild"
};
context.HierarchicalKeyEntities.Add(root);
context.HierarchicalKeyEntities.Add(child);
context.HierarchicalKeyEntities.Add(grandchild);
context.SaveChanges();
}
using (var context = GetContext())
{
var gc = context.HierarchicalKeyEntities.FirstOrDefault(x => x.Id.Equals("root/Child/Grandchild"));
Assert.That(gc, Is.Not.Null);
var c = context.HierarchicalKeyEntities.FirstOrDefault(x => x.Id.Equals("root/Child"));
Assert.That(c, Is.Not.Null);
var r = context.HierarchicalKeyEntities.FirstOrDefault(x => x.Id.Equals("root"));
Assert.That(r, Is.Not.Null);
}
}
public void TestCreateHiearchicalKey()
{
using (var context = GetContext())
{
var root = new HierarchicalKeyEntity {Code = "root"};
var child = new HierarchicalKeyEntity {Parent = root, Code = "Child"};
var grandchild = new HierarchicalKeyEntity {Parent = child, Code = "Grandchild"};
context.HierarchicalKeyEntities.Add(root);
context.HierarchicalKeyEntities.Add(child);
context.HierarchicalKeyEntities.Add(grandchild);
context.SaveChanges();
}
using (var context = GetContext())
{
var gc = context.HierarchicalKeyEntities.FirstOrDefault(x => x.Id.Equals("root/Child/Grandchild"));
Assert.That(gc, Is.Not.Null);
var c = context.HierarchicalKeyEntities.FirstOrDefault(x => x.Id.Equals("root/Child"));
Assert.That(c, Is.Not.Null);
var r = context.HierarchicalKeyEntities.FirstOrDefault(x => x.Id.Equals("root"));
Assert.That(r, Is.Not.Null);
}
}
