This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries. We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.
Latest Database Articles - Page 2
SQLiteTbl, a C++ Class that Provides a CRecordSet-Like Interface to SQLite
Explore a CRecordSet-like interface to a SQLite database table.
Deploying and Configuring SQL Server Integration Services Packages Without the Wizard
By Dee Quang - Ever get confused by or dislike using the SQL Server Integration Services deployment wizard? Learn how to manually deploy the packages to SQL Server 2005 and configure the packages in a multitude of ways as well.
Faster and Friendlier Access to Oracle's OCI API
Why get bogged down in the quicksand of the Oracle Call Interface (OCI) when you can get the same service with less code and fewer headaches with Vincent Rogier's OCILIB?
Create MySQL 5.1 Storage Engine Plugins Under Win32
A MySQL Storage engine requires functions that MySQL provides. Therefore, you normally need to link it into mysqld-core under Windows because mysqld.exe doesn't export all required functions (because it's an .exe, not a .dll). So, you're unable to import the required functions in our Plugin. Learn a possible way to circumvent this limitation by using the .map files that are provided with MySQL.
Importing Data into SQL Server
by William R. Vaughn - Having problems importing large amounts of data? ADO.NET has only one method designed to help with this task: the SqlBulkCopy class exposed in ADO.NET 2.0.
Latest Developer Videos
More...Latest CodeGuru Developer Columns
MFC Integration with the Windows Transactional File System (TxF)
The Transactional File System (TxF), which allows access to an NTFS file system to be conducted in a transacted manner through extensions to the Windows SDK API. MFC 10, has been extended to support TxF and related technologies. This support allows existing MFC applications to be easily extended to support kernel transactions.
.NET Framework: Collections and Generics
The original release of the .NET Framework included collections as .NET was introduced to the Microsoft programming world. The .NET Framework 2.0 introduced generics to complement the System.Collections namespace and provide a more efficient and well performing option. Read on to learn more...

Adding File Associations
For some reason, setting file associations is still somewhat of a mystery to many a developer. Hannes du Preez shows you how to create an installer package to do it for you!
Implementing a WCF Message Contract
WCF implementations normally take two different approaches; a Document style or an API style. Document style implementations are more flexible and often easier to extend and version. Also, Document style or rather, Message Contract service implementations, work well between systems with a shared message assembly. Jeffrey Juday guides you through architecting a WCF Message Contract implementation.


