Firebird is a database with 20 years of history, full set of features (including transactions, stored procedures, hot-backup, excellent scalability, etc.) and a friendly open source license. It is an overlooked but compelling alternative to Microsoft Jet and Microsoft MSDE 2000/SQL Express 2005. Let's take a look at how it can be used embedded in your desktop application. What makes Embedded Firebird ideal for embedding:
- The embedded runtime is < 2 MB (starting at just one DLL + one .NET assembly). The runtime is deployed by simple copying, no installation or component registration is required.
- The database file (it's just a single file) can have any name and extension. You can associate the extension with your application.
- The migration to a standalone server couldn't be easier. Just copy the database file to the server and change a connection string on your client.
Compare Firebird with other database engines.
Firebird in .NET：http://www.dotnetfirebird.org
DDEX and Firebird .NET Data Provider
Deploying the ASP.NET application which is using Firebird .NET Data Provider (with design-time support)
Data Application Block for Firebird SQL