LINQ Basics, LINQ Query Operators, LINQ Joins, LINQ Grouping, LINQ to SQL, LINQ to XML
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<...
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...
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...
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...
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...
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...
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...
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...
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...
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...
