c# - Linq join query displayed in MVC view -
i'm trying display linq join query in partial web view. here query within controller: public actionresult inactiveusers() { using (modelcontainer ctn = new modelcontainer()) { datetime duration = datetime.now.adddays(-3); var inactive = usrs in ctn.aspnet_users usrs.lastactivitydate <= duration join o in ctn.groups on usrs.userid equals o.userid select new { usrs.username, usrs.lastactivitydate, o.primaryphonenumber, }; return view(inactive.tolist()); } } what i'm bit confused on next. i'm familiar adding typed views using models, happens in case have join query? if point ...