private static void InsertData() { using (var context = new animal_ownersContext()) { // Creates the database if not exists context.Database.EnsureCreated(); // Adds an animal var animal = new Animal { Name = "Lion" }; context.Animal.Add(animal); // Adds some clients context.Owner.Add(new Owner { Id = 10, Name = "Peter", Number = 1, Value = 20000, AnimalId = 1, Animal = animal }); context.Owner.Add(new Owner { Id = 11, Name = "Mark", Number = 2, Value = 40000, AnimalId = 1, Animal = animal }); context.Owner.Add(new Owner { Id = 12, Name = "Joe", Number = 5, Value = 100000, AnimalId = 1, Animal = animal }); // Saves changes context.SaveChanges(); } }
private static void PrintData() { // Gets and prints all clients in database using (var context = new animal_ownersContext()) { var owners = context.Owner .Include(p => p.Animal); foreach (var owner in owners) { var data = new StringBuilder(); data.AppendLine($"Id: {owner.Id}"); data.AppendLine($"Name: {owner.Name}"); data.AppendLine($"Number: {owner.Number}"); data.AppendLine($"Value: {owner.Value}"); data.AppendLine($"AnimalId: {owner.AnimalId}"); data.AppendLine($"Name: {owner.Animal.Name}"); Console.WriteLine(data.ToString()); } } }