public ActionResult Index() { var users = (from u in db.Users join s in db.States on u.StateId equals s.StateId join l in db.Lgas on u.LgaId equals l.LgaId select new { u.Surname, u.Firstname, u.Othernames, u.Email, s.StateName, l.LgaName }).ToList(); return View(users); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)