Search code examples
firebirdembedded-database

Using embedded firebird database with .NET

I want to use Embedded FireBird with .NET 3.5. I have few queries:

(1) Are there any new developments done on the embedded version by the FireBird community?

(2) Are there any database file repair & optimize (shrink etc.) features in it?

(3) Does it supports Triggers, Foreign Keys, PL/SQL type of things etc.?

Solution

  • Answering your questions:

    1. The Embedded version is like a normal Firebird but encapsulated in a DLL and with some minor limitations. The Firebird Team just released some days ago the 2.5 version of SuperServer, Classic and Embedded flavors. More info at Embedded Firebird Server and Firebird website.

    2. There are tools to repair and optimize databases. Check How to repair a corrupt Firebird database

    3. Firebird is SQL:2003 conformant as stated in Firebird: SQL Conformance. It has triggers, foreiggn keys and stored procedures.

    Hope that helps