News

Photos

Articles

Components

Applications

Kleinkunst

Database 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 - Functions in the Entity Framework 4.0: part 3

Entity Framework

In this third article about the Entity Framework 4.0 I will explore some SqlClr features and show how to call custom .NET functions and aggregates in LINQ to Entities queries.

.NET - Functions in the Entity Framework 4.0: part 2

Entity Framework

In this second article about the Entity Framework version 4.0 user defined functions and the new Model Defined Functions will be explored. Based on a series of simple examples I will show how to map UDF's and Entity SQL expressions to Model Defined Functions and how to call them in LINQ to Entities queries.

.NET - Functions in the Entity Framework 4.0: part 1

Entity Framework

The Entity Framework together with LINQ to Entities are very powerful technologies to access and manipulate data from a database. But when you need to gain performance or need extra security, stored procedures and user defined functions are often required. In this first article in a series of three I will focus on how to use stored procedures in the Entity Framework 4.0.

Delphi - Handle SQL Server errors with ADO

This article, which is written in Dutch, describes which exceptions/errors can occur in MS SQL Server and how they can be handled in stored procedures and with ADO components in Delphi. Furthermore this article describes some ideas of how to develop your own error message window to show errors in the language of the end user.

Delphi - Returning data with stored procedures

A comprehensive article about all features in Delphi to use stored procedures to return data to the client. The examples are tested with ADO (ActiveX Data Objects), DBX (dbExpress) and IBX (InterBase Express) components and databases like Microsoft SQL Server, Oracle en Firebird/Interbase.

Databases and SQL

This document has been used in a brief training about databases and SQL. It explains all the key concepts of a database (tables, records, fields, keys, referential integrity, indexes, triggers, stored procedures, transactions, ...). Furthermore it gives an overview of the different databases and tools and it gives an introduction to SQL for querying and modifying a database.

SQL examples and exercises

This document shows a lot of examples of SQL and it contains several exercises.