LINQ- Difference between First and FirstOrDefault- First vs FirstOrDefault

In my previous post Single vs SingleOrDefault, we talk about Single and SingleOrDefault method and difference between these methods. In this post we are going to explore two more extension methods First and FirstOrDefault.


You can find some other useful topics and posts here. Below is a chart explaining about First() and FirstOrDefault(). You can easily differentiate these methods from this chart. I have also given examples of each method.

LINQ- Difference between Single and SingleOrDefault- Single vs SingleOrDefault

In today's development, we all are frequently users of LINQ. So In this post and some incoming posts, I will try to explain about some LINQ's extension methods that seems trivial, but can really helpful to improve your code by making it easier.

Here, In this post I am going to explain you about Single and SingleOrDefault method and difference between these methods.

You can find some other useful topics and posts here. Below is a chart explaining about Single() and SingleOrDefault(). You can easily differentiate these methods from this chart. I have also given examples of each method.

How To- Find Duplicate Records in DataTable Using LINQ

This is a simple tip post . Here, I am explaining how to find the duplicate records in DataTable using LINQ.

In my previous posts, I explained Constructor Chainning in C#, Convert a Generic List to a Datatable, Get Property Names using Reflection in C#, Hard drive information using C#, Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C# and some other articles related to C#, ASP.Net,  jQuery, Java Script and SQL Server.

Query for finding duplicate records in  DataTable using LINQ is very simple. For example, We have the following DataTable.

LINQ Operators:Partition Operators

This post is the part of series called LINQ Operators that brings the practical examples of LINQ operators. In previous posts we have learned about Filtering and Projection operators.Today we will see the Partition Operators in LINQ.

 

LINQ Operators: Projection Operators

In previous article we discussed about Filtering operators in LINQ. So moving forward today we will see the Projection Operators in LINQ. 

LINQ Operators : Filtering Operators

LINQ operators are a collection of methods that form the heart and soul of the LINQ(Language Integrated Query). The best thing of these operators is how they can execute against different data sources. You can use these operators not only to query object in memory but you can use same operators to query object stored in relational database, in XML, datasets and more.