Devart Forums

Code: Select all

var reportData = (from pr in db.PageReports
                  where pr.CampaignID == 594
                  group pr by pr.DeviceID into g
                  select new
                  {
                      DeviceID = g.Key,
                      DeviceCount = g.Count(),
                      Device = (from d in db.Devices
                                    where d.DeviceID == g.Key
                                    select d)
                  });

var finalData = reportData.OrderByDescending(s => s.DeviceCount);