Select and SelectMany are projection operators. Select operator is used to select value from a collection and SelectMany operator is used to select values from a collection of collection i.e. nested collection. Select operator produce one result value for every source value while SelectMany produce a single result that contains… Continue reading
LINQ to DataSet is useful to run strongly typed queries on multiple datasets. SQL query is able to populate the dataset from the database but not able to retrieve a particular value from the dataset. LINQ is the best way to do further data manipulation operations (like searching, filtering, sorting)… Continue reading
A LINQ provider is a library which helps you to execute a given query against a data source. The different types of LINQ providers are LINQ to Objects, LINQ to SQL, LINQ to XML LINQ to Datasets and LINQ to Entities.
FirstOrDefault usually perform faster as compared SingleOrDefault, since these iterate the collection until they find the first match. While SingleOrDefault iterate the whole collection to find one single match.
You should take care of following points while choosing Single, SingleOrDefault, First and FirstOrDefault. When you want an exception to be thrown if the result set contains many records, use Single or SingleOrDefault. When you want a default value is returned if the result set contains no record, use SingleOrDefault…. Continue reading
Single – It returns a single specific element from a collection of elements if element match found. An exception is thrown, if none or more than one match found for that element in the collection. SingleOrDefault – It returns a single specific element from a collection of elements if element… Continue reading
Element operators return a single element or a specific element from a collection. The elements operators are Single, SingleOrDefault, First, FirstOrDefault, Last, LastOrDefault. List < int > data = new List < int > { 10, 20, 30, 40, 50 }; //Try to get element at specified position Console.WriteLine(data.ElementAt(1)); //result:20… Continue reading
Conversion operators convert the type of input objects into a specific type or sequence. The aggregate operators are AsEnumerable, Cast, ToList, ToArray and ToDictionary. List < int > data = new List < int > { 10, 20, 30, 40, 50 }; //Cast to Array int[] strArray = data.Cast <… Continue reading
Aggregate operators perform calculations on a set of values and return a single value. The aggregate operators are Average, Count, Max, Min, and Sum. List < int > data = new List < int > { 10, 20, 30, 40, 50 }; //Sum of numbers Console.WriteLine(data.Sum()); //result:150 //Average of numbers… Continue reading
LINQ provides you various operators to write a LINQ query. Various types of operators are given below: Operator Type Operator Name Aggregate Aggregate, Average, Count, LongCount, Max, Min, Sum Concatenation Concat Conversions Cast, OfType, ToList, ToArray, ToLookup, ToDictionary, AsEnumerable Element Single, SingleOrDefault, First, FirstOrDefault, Last, LastOrDefault, ElementAt, ElementAtOrDefault Equality SequenceEqual… Continue reading