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

iOS Dev: Encryption in Objective-C

By
Hello Friends: In this Article/Post, I introduced the one encryption technique in Objective-C.  Encryption Component Features in all  Symmetric Encryption: AES, Blowfish, Twofish, RC2, ARC4, DES, 3DES, PBES1, PBES2. Hash Algorithms :  SHA-1 , SHA256, SHA384, SHA512, MD2, MD4, MD5, HAVAL. Hash Algorithms: RIPEMD128, RIPEMD160, RIPEMD256, RIPEMD320. Encoding: Base64, hex, quoted-printable,  URL-encoding . HMAC with any supported hash algorithm: HMAC-MD5,  HMAC-SHA1 , etc. Password-based Key Derivation Functions: PBKDF1, PBKDF2 PKCS7 -- P7S and P7M creation, decryption, verification. Public key encryption/decryption with digital certificates. Digital signature creation/verification with digital certificates. Bzip2 in-memory compression. Encrypt / decrypt strings or byte data. Return encrypted data as Base64, quoted-printable, or hex-encoded strings. Hash strings or binary data using SHA1, MD2, MD5, HAVAL, SHA384, or SHA512. Public-key encryp...
1 comment
Read more

iPhonegap: Developing a PhoneGap Application

By
Tutorial: Developing a PhoneGap Application Reference :  Here In this tutorial, you create a fully functional employee directory application with  PhoneGap . You will learn: How to use different local data storage strategies. How to use several PhoneGap APIs such as Geolocation, Contacts, and Camera. How to handle specific mobile problems such as touch events, scrolling, styling, page transitions, etc. How to build an application using a single page architecture and HTML templates. How to build (compile and package) an application for 6 platforms using  PhoneGap Build . To complete this tutorial, all you need is a code editor, a modern browser, and a connection to the Internet. A working knowledge of HTML and JavaScript is assumed, but you don’t need to be a JavaScript guru. Setting Up Download the assets for the workshop  here . Unzip the file anywhere on your file system. If your code editor allows you to “open a directory”, open the phonegap...
Post a Comment
Read more