public void InitializeDb() { try { conn = new Models.PjatkDb(); dg.ItemsSource = conn.Animals.Join(conn.AnimalTypes, animal => animal.IdAnimalType, animalType => animalType.IdAnimalType, (animal, animalType) => new { OwnerId = animal.IdOwner, AnimalName = animal.Name, AnimalType = animalType.Name }).Join(conn.Owners, s => s.OwnerId, owner => owner.IdOwner, (s, owner) => new { AnimalName = s.AnimalName, AnimalType = s.AnimalType, FirstName = owner.FirstName, LastName = owner.LastName }); } catch (Exception e) { Console.WriteLine("Error connecting to DB"); } }
public void InitializeData() { var conn = new Models.PjatkDb(); OwnerComboBox.ItemsSource = conn.Owners.ToList(); }