Skip to main content

Linq - Group By Finding Duplicates

Image
By

From: http://www.matlus.com/linq-group-by-finding-duplicates/

 

This post is a little snippet on using Linq to find duplicates in a list of objects where a specific property of the object is used to find the duplicates. In this particular example, the objects are Lessons and in addition to other properties each lesson has a AddedDate property and what we need to do is find all lessons where the AddedDate is a duplicate of another lesson.

 

In order to solve this we use Group By and we group by the AddedDate property and if any group has a count greater than 1, it is a duplicate and we need to get those.

 

For test purposes, I've defined a variable called testDateAndTime that is assigned to the current DateTime.

And then at the time of initializing the Lesson instances, I've assigned two lessons the same date and time using this variable.

The two lessons (as shown in the code listing below) are:

  1. Preposition / Phrasal Verb
  2. German Verbs in the Present Tense

 

class Program

  {

    static void Main(string[] args)

    {

      var testDateAndTime = DateTime.Now;

 

      var lessons = new Lesson[] {

        new Lesson { Title="Verb Tense", Subject="English", AddedDate = DateTime.Now.AddMinutes(1)},

        new Lesson { Title="Conditionals", Subject="English", AddedDate = DateTime.Now.AddDays(2)},

        new Lesson { Title="Gerunds and Infinitives", Subject="English", AddedDate = DateTime.Now.AddDays(3)},

        new Lesson { Title="Vocabulary", Subject="English", AddedDate = DateTime.Now.AddDays(4)},

        new Lesson { Title="Preposition / Phrasal Verb", Subject="English", AddedDate = testDateAndTime},

        new Lesson { Title="Greetings", Subject="German", AddedDate = DateTime.Now.AddMinutes(5)},

        new Lesson { Title="Personal pronouns", Subject="German", AddedDate = DateTime.Now.AddDays(6)},

        new Lesson { Title="Introduction to nouns and gender", Subject="German", AddedDate = DateTime.Now.AddDays(7)},

        new Lesson { Title="Two important verbs", Subject="German", AddedDate = DateTime.Now.AddDays(8)},

        new Lesson { Title="German Verbs in the Present Tense", Subject="German", AddedDate = testDateAndTime}

      };

 

      var groupedLessons = from l in lessons

                           group l by l.AddedDate into g

                           where g.Count() > 1

                           select new { AddedDate = g.Key, Lessons = g };

 

      foreach (var k in groupedLessons)

      {

        Console.WriteLine("Added Date: " + k.AddedDate);

        foreach (var l in k.Lessons)

        {

          Console.WriteLine("\t Lesson Title: " + l.Title);

        }

      }

    }

  }

 

  public class Lesson

  {

    public string Title { get; set; }

    public string Subject { get; set; }

    public DateTime AddedDate { get; set; }

  }

 

If you run this program you'll see the following output, which is what you'd expect.

 

Added Date: 2/2/2011 8:08:59 AM
         Lesson Title: Preposition / Phrasal Verb
         Lesson Title: German Verbs in the Present Tense

 

 

DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

Labels:

Comments

Post a Comment

Popular posts from this blog

WPF-MVVM: RelayCommand Implementation

By
In WPF if we are implementing MVVM pattern then we need to play with Command rather than Events. You can use ICommand interface to create each command class. Implementation of ICommand in a class gives you CanExecute(), Execute() methods which take part in the action performed by Command.   Rather than making Command Class for each Command we can implement a generic Relay Command to get Command. Below is a RelayCommand class that we will implement.   ///   <summary>      ///  To register commands in MMVM pattern      ///   </summary>      class   RelayCommands  :  ICommand     {          readonly   Action < object > _execute;          readonly   Predicate < object > _canExecute;  ...
Post a Comment
Read more

.Net List with Changed event

By
Sometimes we need a List which can notify user when an item is added. Here is the way that you can implement a generic ArrayList which notifies user at the time of an element is added.   using  System; using  System.Collections; namespace  ArchiveData.Logging {    // A delegate type for hooking up change notifications.    public   delegate   void   ChangedEventHandler ( object  sender,  EventArgs  e);    public   class   ListWithChangedEvent  :  ArrayList   {      // An event that clients can use to be notified whenever the      // elements of the list change.      public   event   ChangedEventHandler  Changed;      public   object  NewlyAddedItem {...
Post a Comment
Read more

What is DispatcherTimer in wpf?

By
DispatcherTimer When you want to set a timer working with GUI, you always come across threading problem. The problem is that if you want to send some changes to UI that is constantly/continuously changing then that will make your UI unresponsive or in other words it will hang your UI.   To overcome from this situation, WPF gives us DispatcherTimer threading functionality that will take care of such continuously changing processing on UI thread and that will not hang your UI. We can accomplish same scenario in Win Form , through System.Windows.Forms.Timer and in WPF it is System.Windows.Threading.DispatcherTimer .   Difference between DispatcherTimer and Regular timer (System.Timers.Timer) DispatcherTimer is the regular timer. It fires its Tick event on the UI thread, you can do anything you want with the UI. System.Timers.Timer is an asynchronous timer, its Elapsed event runs on a thread pool thread. You have to be very careful in your event handler...
Post a Comment
Read more