Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2015
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. var myList = (from p in db.Full
  2. where ( (p.date_reception > begin & p.date_reception < end & !p.mc_host_class.Contains("NULL")) &
  3.  
  4. (!strListe.Contains(p.mc_host_class)))
  5. group p by p.mc_host_class into g
  6. orderby g.Count() descending
  7. select new
  8. {
  9. hostclassx = g.Key,
  10. countx = g.Count()
  11. }).Take(10).ToList();
  12.  
  13.  
  14.  
  15. HttpContext.Current.Session["allList"] = myList;
  16. var list = (List<StringIntType>)HttpContext.Current.Session["allList"];
  17.  
  18. public class StringIntType
  19. {
  20.  
  21. public string str { get; set; }
  22. public int nbr { get; set; }
  23. }
  24.  
  25. select new
  26.  
  27. select new StringIntType
  28. {
  29. str = g.Key,
  30. nbr = g.Count()
  31. }).Take(10).ToList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement