To begin with, this post aims to make you understand Grouping Queries in LINQ. Basically, we need to group data whenever the data elements exhibit a certain common feature. In other words, some of the members of a sequence share a specific value for an attribute while other members may have another value for that …
Generic Binary Search in C#
Today I will explain the Generic Binary Search in C#. Basically, Binary Search is a technique that is used to find a target value from a list of values. In general, Binary Search takes a list of values as input and searches for a target value by dividing the list into two equal halves in …
Understanding the Quantifiers in LINQ
In this post on Understanding the Quantifiers in LINQ, I will explain the three quantifier operators – Any, All, and Contains. Basically, we use quantifiers when we need to determine how many elements in a sequence satisfy a particular condition. Nevertheless, we encounter situations where we need to seek whether all members of the sequence …
Join Operation using LINQ
This article will demonstrate the Join Operation using LINQ. Whenever you want to write an SQL-like join query using LINQ, you can use the LINQ join operator. In order to perform the join operation on two or more data sources, it is required that those data sources must have some common value. Significantly, all the join operations that we …
Deferred Query Execution and Immediate Query Execution in LINQ
In this post, I will explain Deferred Query Execution and Immediate Query Execution in LINQ. Basically, a query formulated in LINQ may exhibit one of the two kinds of behaviors during execution. These two kinds of behaviors are called deferred query execution and immediate query execution. In the case of deferred query execution, the query …
Examples of Query Operations using LINQ in C#
In this post, I will demonstrate several Examples of Query Operations using LINQ in C#. In order to get an overview of LINQ, you can read this article on Language-Integrated Query (LINQ) in C#. Examples of Query Operations using LINQ in C# Since LINQ helps us in creating queries that work with various kinds of data …
Language-Integrated Query (LINQ) in C#
Language-Integrated Query (LINQ) in C# allows us to formulate the queries in C# language itself rather than using the syntax of SQL (Structured Query Language). The native data querying capabilities to the .NET languages have become part of the .NET Framework 3.5 with Visual Studio 2008 in the form of Language-Integrated Query (LINQ). With LINQ, …
How Data Binding Works in WPF
In general, Data Binding is a way to communicate the data among the code and UI components. Today I will explain How Data Binding Works in WPF (Windows Presentation Foundation). In order to get familiar with WPF, you can go through this basic article on WPF. While creating a navigation window application in WPF is explained …
Understanding Dispose and Finalize in C#
In this post on Understanding Dispose and Finalize in C#, I will explain the two important methods related to the Garbage Collection. Basically, the garbage collection module of Common Language Runtime (CLR) in .NET Framework frees the programmer for memory management tasks. In fact, the garbage collector maintains three generations of objects – generation 0, …
Examples of Connected and Disconnected Approach in ADO.NET
Today I will give some examples of the Connected and Disconnected Approach in ADO.NET. Basically, the ADO.NET library in .NET Framework provides the functionality for database access. This library offers lots of classes and methods for fetching and manipulating data from any data source. The following examples demonstrate how to perform database operations using these two approaches. As …