Using LINQ to merge a list of objects

Question

I have two lists of objects, using Linq I would like to merge them, but where the two lists contain objects with the same key, I only want the one with the greatest LastUpdated Value.

I thought that I could somehow get a list grouping by key a with max(LastUpdated) then join back to the list joining on key and LastUpdated, but there must be a more efficient way...

List<MyObject> lstListA = new List<MyObject>;
List<MyObject> lstListB = new List<MyObject>;

public class MyObject
{
    public string Key {get;set;}
    public string Value {get;set;}
    public DateTime LastUpdated {get;set;}
}

Jon Skeet · Accepted Answer · 2010-02-19 17:15:10Z

17

One option, using DistinctBy from MoreLINQ:

var query = lstListA.Concat(lstListB)
                    .OrderByDescending(x => x.LastUpdated)
                    .DistinctBy(x => x.Key);

answered Feb 19, 2010 at 17:15

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jeremy Over a year ago

How does the DistinctBy differ from using Distinct with a comparer? Will the result be the same?

Jon Skeet Over a year ago

@Jeremy: Yes, the result is the same - DistinctBy is just easier :)

Amy B · Accepted Answer · 2010-02-22 18:24:40Z

2

Classic pick-a-winner.

IEnumerable<MyObject> query = lstListA
  .Concat(lstListB)
  .GroupBy(x => x.Key)
//now work with each group to pick a winner
  .Select(g => g.OrderByDescending(x => x.LastUpdated).First())

answered Feb 22, 2010 at 18:24

Amy B

110k21 gold badges140 silver badges191 bronze badges

Comments

Konamiman · Accepted Answer · 2010-02-19 17:40:48Z

0

A bit comvoluted, but this seems to work as well:

var mergedItems = lstListA.Concat(lstListB);

mergedItems =
    (from item in mergedItems
    group item by item.Key into grp
    let sameKey = mergedItems.Where(obj => obj.Key == grp.Key)
    select sameKey.Where(obj => obj.LastUpdated == grp.Max(obj2 => obj2.LastUpdated)).Single()
).ToList();

answered Feb 19, 2010 at 17:40

Konamiman

50.5k17 gold badges111 silver badges140 bronze badges

Collectives™ on Stack Overflow

Using LINQ to merge a list of objects

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related