Home » C# » How to compare element from the same collection with Linq?

How to compare element from the same collection with Linq?

Lets imagine that you have a collection with a class containing Images. All images are identified by an unique key and a caption that the user enter. You want to verify that the caption entered by the user is unique to the collection. How to do it?

This can be done with Linq to Object pretty easily by using 2 from statement.

var hasDouble =  
         (from s1 in this.Images
          from s2 in this.Images
          where s1.Key != s2.Key
                && s1.Caption == s2.Caption
         select new { Image1 = s1, Image2 = s2 }).Any();

This will loop through all the images and will compare the caption of all shape but not compare node with itself.
I have created an anonymous object because in fact, I may want to get those 2 elements that have the same caption. In that case I just need to call the same code and remove the .Any().

This can be translated to Lambda expression.

(this.Shapes.SelectMany(s1 => this.Images, (s1, s2) => new{s1, s2})
             .Where(tt => tt.s1.Key != tt.s2.Key
              && tt.s1.Caption == tt.s2.Caption)
             .Select(tt => new { Image1 = tt.s1, Image2 = tt.s2}
)

But for this kind of task, Lambda is more confusing from my point of view.

If you like my article, think to buy my annual book, professionally edited by a proofreader. directly from me or on Amazon. I also wrote a TypeScript book called Holistic TypeScript

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.