How would I make this code more efficient using Linq
//Get all incidents List < DataRow > Incidents = rm.getData(Token, "incdet").Tables["Client Data"].AsEnumerable().ToList(); //get incidents that fall between a date range var appointmentNoShow = from a in Incidents where (Convert.ToDateTime(a["dateinc"].ToString()) >= firstDayOfMonth && Convert.ToDateTime(a["dateinc"].ToString()) <= lastDayOfMonth) select a; //get all injuries List<DataRow> injuries = rm.getData(Token, "incemp").Tables["Client Data"].AsEnumerable().ToList(); //put injuries that match incidents in date range into list var result = injuries.Where(p => Incidents.Any(p2 => p2["incid"].ToString() == p["incid"].ToString())); // check if injuries have specific code add to list foreach (var item in result) { if (item["consqce"].ToString() == "107547" || item["consqce"].ToString() == "107548" || item["consqce"].ToString() == "107549") { IncidentRecord r = new IncidentRecord(); r.ID = item["incid"].ToString(); //r.Date = item["dateinc"].ToString(); QualifyingList.Add(r); } } //select The incident that match the incident ids in the QualifyingList to get the dates var injuriesForMonth = Incidents.Where(p => QualifyingList.Any(p2 => p2.ID == p["incid"].ToString()));
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)