Tags

LINQ Basics, LINQ Query Operators, LINQ Joins, LINQ Grouping, LINQ to SQL, LINQ to XML

LINQ SelectMany Operator

SelectMany operator is used when we have a sequence of objects which has a collection property and we need to enumerate each item of child collection one by one. SelectMany operator comes under Projection operators category of LINQ Query Operators. Below is the syntax of SelectMany operator public static IEnumerable<TResult> SelectMany<TSource, TResult>(this IEnumerable<...

Continue Reading

LINQ Contains Operators

LINQ Contains operator is used to check whether an element is available in sequence (collection) or not. Contains operator comes under Quantifier Operators category in LINQ Query Operators. Below is the syntax of Contains operator. public static bool Contains<TSource>(this IEnumerable<TSource> source, TSource value); public static bool Contains<TSource>(this IEnumerable...

Continue Reading

LINQ Any Operator

LINQ Any operator comes under Quantifier Operators category in LINQ Query operators. LINQ Any operator is used for two cases: Check whether sequence is blank or not. Check whether any single element in a sequence satisfy a given condition or not. Any operator is only available in Method syntax and not available in Query Syntax. Below is the syntax of Any operator public stati...

Continue Reading

LINQ All Operator

LINQ All operator is used to check whether all elements in a sequence (collection) satisfy a particular condition or not. LINQ All operator comes under Quantifier Operators category in LINQ Query Operators. Lets take an example, we have a collection A = { 3, 6, 9, 12 } and we have to check whether all elements in this sequence is divide by 3 or not. For this we use All operator and pass predic...

Continue Reading

LINQ Distinct Operator

LINQ Distinct operator is used for removing duplicates elements from the sequence (list). Distinct operator comes under Set operators category in LINQ query operators. For example, we have one collection A = { 1, 2, 3, 3, 4, 4, 5}. In this collection 3 and 4 elements are repeated two times and we have to create a new sequence which takes these duplicates only one time. So we use distinct opera...

Continue Reading

LINQ Intersect Operator

LINQ Intersect operator is used to find common elements between two sequences (collections). Intersect opertor comes under Set operators category in LINQ Query operators. For example, we have two collections A = { 1, 2, 3 } and B = { 3, 4, 5 }. Intersect operator will find common elements in both sequences. { 3 } element is common in both sequences. So Intersect operator only shows one element...

Continue Reading

LINQ Union Operator

LINQ Union operator is used for finding unique elements between two sequences (Collections). For example, suppose we have two collections A = { 1, 2, 3 }, and B = { 3, 4, 5 }. Union operator will find unique elements in both sequences. { 3 } element is available in both sequences. So union operator only takes one element in the result. C = { 1, 2, 3, 4, 5 }. Union operator is only supported...

Continue Reading

LINQ Except Operator

LINQ Except operator comes under Set operators category in LINQ. LINQ Set operators is used for compare two sequences (collections) and find common, missing and unique elements. You can find entire list of set operators here. Except operator compares two sequences (collections) classes and find those elements which are not present in second sequence. For example. suppose we have a collection A...

Continue Reading

LINQ OrderByDescending Operator

LINQ OrderByDescending operator sort the elements in a sequence in descending order. You can find LINQ sorting operators list here. Below is the syntax of OrderByDescending operator. public static IOrderedEnumerable<TSource> OrderByDescending<TSource, TKey>(this IEnumerable<TSource> source, Func<TSource, TKey> keySelector); As shown in above syntax, OrderByDesce...

Continue Reading

LINQ ThenBy Operator

LINQ ThenBy Operator is used when we want to sort the elements in a collection by using multiple properties in ascending order. This operator must use after OrderBy or OrderByDescending operator. First OrderBy operator sort the collection based on a single property and then we can use ThenBy operator to sort the collection by second property. We can use multiple ThenBy operator in a collection...

Continue Reading