public bool Save() { bool isOkay = false; using (var dbContext = new PeopleEntities()) { if (languageID == null) { Language = null; } else { Language = dbContext.Languages.Find(languageID); } if (id > 0) { dbContext.People.Attach(this); dbContext.Entry(this).State = System.Data.EntityState.Modified; } else { dbContext.People.Add(this); } if (dbContext.SaveChanges() > 0) { isOkay = true; } } return isOkay; }
public LanguageViewModel(int id) { using (var dbContext = new PeopleEntities()) { language = dbContext.Languages.First(l => l.id == id); } if (language == null) { language = new Language(); } }
public LanguagesViewModel() { InitializeDependencies(); List<Language> languagesList; using (var dbContext = new PeopleEntities()) { languagesList = dbContext.Languages.ToList(); } SetCollection(languagesList); }
public static Person GetPerson(int id) { Person person; using (var dbContext = new PeopleEntities()) { person = dbContext.People .Find(id); if (person != null) { if (person.Language != null) { } // forces load of Language } } return person; }
private List<Person> GetPeopleFromDB() { List<Person> peopleList; using (var dbContext = new PeopleEntities()) { peopleList = dbContext.People .Include(a => a.Language) .OrderBy(a => a.id) .ToList<Person>(); } return peopleList; }