Where LINQ to SQL shines as compared to other ORM tools in the market is the fact that it abstracts away the database structure behind our business objects, it also supports a query language called LINQ.

An overview of LINQ: how LINQ leverages different execution, what support C# provides query over datasets and data tables (LINQ to dataset), etc.

This article covers things from syntax to constraints and implementation details for lambda expression in C#