static void StudiuCaz1() { using (var context = new ModelSelfReferences()) { var parent1 = new SelfReference() { Name = "Ana" }; var child1 = new SelfReference() { Name = "Maria", ParentSelfReference = parent1 }; context.SelfReferences.Add(parent1); context.SelfReferences.Add(child1); var child2 = new SelfReference() { Name = "Silviu" }; var parent2 = new SelfReference() { Name = "Alex" }; parent2.References.Add(child2); context.SelfReferences.AddRange(new List <SelfReference>() { child2, parent2 }); context.SaveChanges(); foreach (var selfReference in context.SelfReferences) { Console.WriteLine("SelfReference {0}", selfReference.Name); foreach (var childReference in selfReference.References) { Console.WriteLine(" Child SelfReference {0}", childReference.Name); } } } }
public static void Scenariul1() { using (var db = new ModelSelfReferences()) { var nume = new Model.SelfReference { Name = "Mihai" }; db.SelfReferences.Add(nume); db.SaveChanges(); var query = from b in db.SelfReferences orderby b.Name select b; Console.WriteLine("All data in database"); foreach (var item in query) { Console.WriteLine(item.Name); } Console.WriteLine("Press any key to exit"); Console.ReadKey(); } }
private static void primulScenariu() { using (var context = new ModelSelfReferences()) { SelfReference selfReference = new SelfReference() { Name = "Robert" }; List <SelfReference> refs = new List <SelfReference>(); SelfReference pers2 = new SelfReference() { Name = "Bianca" }; SelfReference pers3 = new SelfReference() { Name = "Alex" }; refs.Add(pers2); refs.Add(pers3); selfReference.References = refs; context.SaveChanges(); Console.WriteLine("User: "******"Referinte:"); foreach (var item in selfReference.References) { Console.WriteLine(item.Name); } Console.ReadLine(); } }