CASE Statement Equivalent in LINQ

Last Friday while having a discussion on various LINQ standard query operators the topic of expressing T-SQL CASE statement in LINQ came up.

ADO.NET Entity Framework Data Loading – Part 2

In my last post we have discussed about how to explicitly load data into related objects using EntityReference class.However in .NET Framework 4.0 there is another new way to explicitly load data into related objects using the LoadProperty method of the System.Data.Objects.ObjectContext as shown below:

ADO.NET Entity Framework Data Loading – Part 1

In any Object Relational Mapping (ORM) framework the client code interacts with the objects.The framework maps the same to relational database tables and manages database connection and all the SQL queries.So in this context it is extremely important to understand what are the various mechanisms using which data can be loaded into the objects.In this series of posts we will discuss on how ADO.NET Entity Framework does the same.To start with we will discuss about how the objects are explicitly populated with data.