News
Photos
Articles
Components
Applications
Kleinkunst

LINQ to SQL articles

On this page you will find an overview of all articles that I have written myself. The more recent articles deal with software development with .NET (C#, Visual Studio, VSTS, Azure, LINQ, Entity Framework, Web services, WPF, Silverlight, ...) in particular. The older articles were often written for the purposes of courses or demonstrations at my computerclub and these articles are mostly about Delphi, PHP, databases, Javascript, Windows, Office, Multimedia applications, Atari, ...

Use the left panel to filter the more than 110 articles by category. These articles can be used freely for personal use. Placing the full articles on other websites is not allowed without the permission of the author.

.NET - LINQ AsHierarchy() extension method - part 2
English
.NET
LINQ
Entity Framework
LINQ to SQL
A few months ago I published an article about my LINQ AsHierarchy extension method. This extension method can be used to convert a flat collection of records to a hierarchical structure of nested collections. I got a lot of enthusiastic responses and questions so I decided to improve this technique a little further. This new article will describe the new features and demonstrates how to use the LINQ to Objects and the new LINQ to SQL AsHierarchy extension methods.
.NET - LINQ AsHierarchy() extension method - part 1
English
.NET
LINQ
Entity Framework
LINQ to SQL
This article explains how to convert data from a self referencing table (adjacency model) to a hierarchy of nested collections (nested set model). The new LINQ AsHierarchy() extension method can be used to convert data and bind it to WPF TreeViews.
.NET - LINQ to SQL - part 4
English
.NET
LINQ to SQL
LINQ
Fourth part of this series of articles about LINQ to SQL (.NET 3.5). This article shows the features of the 2 provided visualizers (LINQ to SQL Visualizer & Expression Tree Visualizer), the use of the Refresh method and how to create dynamic strong-typed Where- and OrderBy-clauses. Powerful expression trees can be created easily by using the PredicateBuilder class.
.NET - WPF/Silverlight treeviews and LINQ to SQL
English
.NET
WPF
Silverlight
LINQ to SQL
LINQ
A few examples about .NET WPF applications using LINQ to SQL. This article will describe how to create nice looking treeviews which are populated with data using LINQ to SQL (or LINQ to Entities). Of course resources, templates, styles, datatriggers, value converters, ... will be utilized. Most examples will also work with Silverlight.
.NET - LINQ to SQL - part 3
English
.NET
LINQ to SQL
LINQ
Third part of this series of articles about LINQ to SQL (.NET 3.5). This article includes some useful tips about adding sequences and using variables in a LINQ query. Further more the techniques of eager loading and query compiling are covered.
.NET - LINQ to SQL - part 2
English
.NET
LINQ to SQL
LINQPad
LINQ
An article about LINQ to SQL with examples of how to use the LINQPad tool and how to implement inheritance with LINQ.
.NET - LINQ to SQL - part 1
English
.NET
LINQ to SQL
LINQ
An article about LINQ to SQL (Visual Studio 2008 b├Ęta 2) with a lot of code examples using the Northwind database. Following topics are being covered : querying, view entities, view SQL statements, local data shaping, non-mapped properties in partial entity classes, object Relation Diagram versus Class Diagram, data shaping with non-mapped properties, change tracking, bulk operations.