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); } }