LINQ Tutorial

Here we will see how we can sort rows in a group using LINQ.Also we will select only the top n rows in a group. This is useful in scenario where we are working on data which consists of different groups.For Sorting and selecting top n rows in a group using in LINQ in C# we […]

What is LINQ? LINQ stands for Language Integrated Query.Before LINQ developers have to use different technologies when working with different data sources. For example to query databases developers have to use SQL.To query XML they need to use XPath.LINQ enables us to use the same language which we use to develop our application ,to query data […]

LINQ provides us operator for different tasks such as selection,filtering,ordering.Usually we filter and select the same type as the original type when working with LINQ. In many scenarios we want to filter and map items to a different list type.For example we are performing LINQ operations on a list of type Product and we want to […]

System.Linq namespace defines many useful extension methods.Following extension methods are used to return single value from the collection. FirstOrDefault SingleOrDefault FirstOrDefault FirstOrDefault is an extension method defined in the System.Linq namespace.It can be called byt the collections implementing IEnumerable.It returns the default value for the type if the collection doesn’t contain any elements.If the collection contains […]

There are two ways in which we can execute the LINQ queries ,Immediate and Deferred .Immediate and Deferred query execution in LINQ means when the query is executed.This is because the query declaration in LINQ is different from query execution. When we write a LINQ query we declare a query variable which contains the result […]