LINQ to Coffee - LINQ Coffee Mug

Tag Cloud (Number of pages by category)

var q = from call in callLog
        where call.Incoming == true
        group call by call.Number into g
        join contact in contacts on g.Key equals contact.Phone
        orderby contact.FirstName, contact.LastName
        select new { contact.FirstName, contact.LastName, 
                     Count = g.Count(), 
                     Avg   = g.Average( c => c.Duration ), 
                     Total = g.Sum( c => c.Duration )};

Ariel Hazelgrove - Calls:2, Time:27mins, Avg:13.5mins
Armando Valdes - Calls:2, Time:20mins, Avg:10mins
Barney Gottshall - Calls:4, Time:31mins, Avg:7.75mins
Chance Lard - Calls:2, Time:22mins, Avg:11mins
Mack Kamph - Calls:2, Time:44mins, Avg:22mins
Stewart Kagel - Calls:2, Time:13mins, Avg:6.5mins
 

XElement xml = new XElement("Contacts",
                    from contact in contacts
                    orderby contact.LastName, contact.FirstName ascending
                    select new XElement("contact",
                        new XAttribute("email", contact.Email),
                        new XElement("FirstName", contact.FirstName),
                        new XElement("LastName", contact.LastName)));

<Contacts>
  <contact email="jeff.deane@my-domain.com">
    <FirstName>Jeffery</FirstName>
    <LastName>Deane</LastName>
  </contact>
  <contact email="adamg@may-domain.com">
    <FirstName>Adam</FirstName>
    <LastName>Gauwain</LastName>
  </contact>
</Contacts>