c# - Filter linq/entity query results by related data -
i'm using mvc5 ef6 , identity 2.1. i have 2 classes: public class incident { public int incidentid {get; set;} ...//title, description, etc public virtual icollection<followedincident> followedincidents { get; set; } public virtual applicationuser user { get; set; } } public class followedincident { public int followedincidentid { get; set; } public string userid { get; set; } public int incidentid { get; set; } public virtual incident incident { get; set; } public virtual applicationuser user { get; set; } } so, users have ability follow incident. (for starters, i'm not entirely sure if need icollection , public virtual relationship references, added them in case time being.) i'm trying create query show users results of followed incidents. in controller, query starts (i'm using troy goode's paging packa...