// GET: INV_ItemConfiguration public ActionResult Index() { var iNV_ItemConfiguration = db.INV_ItemConfiguration.GroupBy(IC => IC.MainItemID) .Select(IC => IC.FirstOrDefault()).Include(i => i.INV_Item).Include(i => i.SEC_User).ToList(); //var iNV_ItemConfiguration = db.INV_ItemConfiguration.Distinct(i=>i.MainItemID).Include(i => i.INV_Item).Include(i => i.SEC_User); return(View(iNV_ItemConfiguration)); }