 |
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.
more
2010-08-30 - English - .NET, Entity Framework, Database
|
 |
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. more
2005-04-16 - Dutch - Delphi, Database
|
 |
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. more
2004-12-26 - English - Delphi, Database
|
 |
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. more
 (PDF) - 2003-02-01 - Dutch - Database
|
 |
This document shows a lot of examples of SQL and it contains several exercises. more
(PDF) - 2003-02-01 - Dutch - Database
|
