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 115 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

Entity Framework

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

Entity Framework

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

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

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

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

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

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.