public ViewResult Index() { var model = new HomeViewModel(); using (var db = new DataContext()) { model.CallForSpeakersCount = db.CallsForSpeakers.Count(); return View(model); } }
public ViewResult Index(User user) { using (var db = new DataContext(user)) { var calls = db.CallsForSpeakers.AsNoTracking().Where(x => x.Organizer.Id == user.Id); var speakers = db.SpeakerProfiles.AsNoTracking().Where(x => x.Maintainer.Id == user.Id); var model = new HomeViewModel(calls, speakers); return View(model); } }