News

Photos

Articles

Components

Applications

Kleinkunst

LINQPad 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 - New connection providers in LINQPad

Entity Framework

LINQPad was introduced in 2007 and nowadays it is a very mature tool which should be in the toolbox of every .NET developer. Version 1.35 offers new connection providers and it has native support for LINQ to SQL and the ADO.NET Entity Framework data models. It also provides new query types like SQL and Entity-SQL. In this small article I will highlight some of the new features.

.NET - Cleaning up and organizing Outlook mailboxes

This small article contains a few C# scripts which can be executed in LINQPad to clean up and organize Outlook mailboxes. If you want to keep Outlook performing as fast as possible and to reduce the size of mailboxes then these scripts and my OutlookProvider component can simplify this job.

.NET - Querying Excel worksheets with LINQ

A while ago I was looking for a way to query Excel with LINQ. I needed a simple solution that allowed me to query tables in Excel worksheets in a tool like LINQPad. This article will describe how I implemented my ExcelProvider and it will demonstrate its features by giving an example of a LINQ query and the result in LINQPad.

.NET - ADO.NET Entity Framework & LINQ to Entities - part 2

Entity Framework

Second part of my series of articles about the ADO.NET Entity Framework. This article covers a few handy testing and learning tools like eSqlBlast and LINQPad. It also describes a few techniques on how to view the generated T-SQL statements when executing Entity SQL or LINQ to Entities queries.

.NET - Execute queries on Office data with LINQPad

This short article is an addition to my 'Querying Outlook and OneNote with LINQ' article. It describes how you can utilize the free LINQPad tool to execute queries on Office data.

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