LINQ (Language Integrated Query) is a powerful querying tool in .NET that allows you to perform complex queries directly in C#. The System.Linq.Expressions namespace is a part of LINQ that provides classes, interfaces, enumerations and structures to work with lambda expressions and expression trees. Lambda expressions are a way to create anonymous methods inline where they’re used, usually with the purpose of manipulating data. For example, let’s say you have a list...

In this article, I’ll show you what the basic steps are for converting a SQL query into LINQ. You’ll learn the basic steps needed while we convert an example query. In this article, it's assumed that you have a basic understanding of SQL, and know how to write C# code. Introduction Structured Query Language (SQL) is a powerful language for working with relational databases. It is widely used to retrieve and manipulate data...

Language Integrated Query (LINQ) is a powerful feature in C# .NET that allows developers to query various data sources using a consistent syntax. In this article, we’ll explore some advanced LINQ techniques to help you level up your skills and write more efficient code. LINQ Extension Methods LINQ comes with many built-in extension methods, but you can also create your own custom methods to extend LINQ’s capabilities. Custom Extension Methods By creating your own...

Writing code can be very exciting but it also can be very frustrating if your code is based on nested loops. Iterations are still one the most important parts of coding. So how can we avoid using ugly nested loops in our code? LINQ — Language Integrated Query Microsoft language developers provided a way to express queries directly in their languages. LINQ extends the language by the addition of query expressions, which...

In this article, I will show the most performant way to write queries for a collection of objects in .Net Core. The article discusses the common methods of LINQ and their comparison. After reading this article, you may have to review your project code! Comparisons were made between query syntax, called LINQ, and method syntax called LAMBDA. 💡 Connect with me on LinkedIn: https://www.linkedin.com/in/hussein-nm/ ✨ Where() LINQ_Where (Method name): LAMBDA_Where: 🚀 Performance Which one do you think...