public void FillNonMembers() { this.Items.Clear(); List <Models.Inrix.Segment> segmentsDT = new List <Models.Inrix.Segment>(); using (Models.Inrix.Inrix db = new Models.Inrix.Inrix()) { segmentsDT = ((from r in db.Segments select r).Except(from q in db.Segments where q.Segment_ID == this.ID select q)).ToList(); } // MOE.Common.Data.Inrix.SegmentsDataTable segmentsDT = segmentsTA.GetDataByRouteNonMember(this.ID); //MOE.Common.Data.Inrix.SegmentsRow segRow; foreach (Models.Inrix.Segment row in segmentsDT) { Segment segment = new Segment(row.Segment_ID, row.Segment_Name, row.Segment_Description); this.Items.Add(segment); } }