I was recently asked to help with a LINQ To SQL query where the resulting T-SQL query was to have CASE statements. Having CASE statements in T-SQL queries is a common scenario but how do we it in LINQ To SQL? The solution is simple and straight-forward. As you will see below, using C#'s &... [More]

 

Well, it's official - LINQ to SQL is NOT dead in .NET 4.0. I'll say it again - LINQ to SQL is not dead. Damian G, a developer at Microsoft working on LINQ to SQL for .NET 4.0, recently made a list of changes that will be coming out in the next release of .NET. Change list Performa... [More]

 

Often we have to get a count of duplicate items in a list. An easy way to do this is to group the list on the property we want to count, then use LINQ's GroupBy's Count feature. Below is a quick example using an employee list.   private static void Main() {  &nb... [More]

 

In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ. LINQ is the new initiative of Microsoft to support Object-Relational Mapping concepts and design patterns. LINQ provides a full type-safety and compile... [More]

 

Sometimes you have a list, and you need to return a single element from the list. There are several ways to get the element to return. Below are two ways using LINQ with Lambda expressions. Consider the following class: 1: public class Person 2: { 3... [More]