Linq grouping question

Posted by Mike C. on Stack Overflow See other posts from Stack Overflow or by Mike C.
Published on 2011-03-03T23:12:08Z Indexed on 2011/03/03 23:25 UTC
Read the original article Hit count: 273

Filed under:

LINQ

I have the following objects in a collection:

Transaction:
Type = "Widget"
Date = "3/1/2011"
Name = "Foo"

Transaction:
Type = "Widget"
Date = "3/4/2011"
Name = "Bar"

Transaction:
Type = "Gadget"
Date = "3/2/2011"
Name = "Baz"

Transaction:
Type = "Gizmo"
Date = "3/1/2011"
Name = "Who"

Transaction:
Type = "Gizmo"
Date = "3/2/2011"
Name = "What"

Transaction:
Type = "Gizmo"
Date = "3/6/2011"
Name = "When"

I want to end up with the following, grouped by Type. If there are multiple, return only the first one chronologically by date.

Transaction:
Type = "Widget"
Date = "3/1/2011"
Name = "Foo"

Transaction:
Type = "Gadget"
Date = "3/2/2011"
Name = "Baz"

Transaction:
Type = "Gizmo"
Date = "3/1/2011"
Name = "Who"

Related posts about LINQ

LINQ to SQL, LINQ to XML and Accessing DataTable using LINQ

as seen on C# Corner - Search for 'C# Corner'
This article demonstrates how to use LINQ on DataTable, XML Data using LINQ to XML and SQL server data base using LINQ to SQL Classes. >>> More
Exception with Linq2SQL Query

as seen on Stack Overflow - Search for 'Stack Overflow'
I am running a query using Linq2SQL that comes down to following query: DateTime? expiration = GetExpirationDate(); IQueryable<Persons> persons = GetPersons(); IQueryable<Items> subquery = from i in db.Items where i.ExpirationDate >= expiration … >>> More
What is Linq?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
The way data can be retrieved in .NET. LINQ provides a uniform way to retrieve data from any object that implements the IEnumerable<T> interface. With LINQ, arrays, collections, relational data, and XML are all potential data sources. Why LINQ?With LINQ, you can use the same syntax to retrieve… >>> More
Subsonic 3 LINQ vs LINQ to SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using SQL Server 2005 in a project. I have to decide about datalayer. I would like to use LINQ in my project. I saw SubSonic 3 supporting LINQ and I also have option for LINQ to SQL, because i can have typed lists from LINQ to SQL. I am wondering what is different between LINQ to SQL and… >>> More
Mixing Silverlight-Specific System.Xml.Linq dll with Non-Silverlight System.Xml.Linq dll

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Logic layer that references Silverlight's System.Xml.Linq dll and a GUI that is in WPF (hence using the non-Silverlight System.Xml.Linq dll). When I attempt to pass an XElement from GUI project to a method in the Logic project, I am getting (basically) "XElement is not of type XElement" errors… >>> More

Developer IT