C#操作firebird数据库

Download firebird下：http://www.firebirdsql.org/en/downloads/

FAQ:

。Can I use a relative path to the database in the connection string?

Yes. It can be relative to the working directory.

。How many concurrent connections can you open using the embedded Firebird?

It's not limited. However, only one application can open a database at a time. The application can be a regular Firebird

server or your application using the fbembed.dll.

。What files are required to use the embedded Firebird?

The following files are required:

·fbembed.dll (the embedded Firebird itself)

·FirebirdSql.Data.Firebird.dll (the Firebird ADO.NET Provider assembly)

The following files are recommended:

·firebird.msg (friendly error messages)

The following files are optional:

·aliases.conf

·firebird.conf

·ib_util.dll

·intl/fbintl.dll

·udf/fb_udf.dll

·udf/ib_udf.dll

。Where should I put the embedded Firebird files in my application?

Put them in the working folder of your application. Typically it will be the directory where your .exe file lies.

Connect to a embedded database

Firebird ADO.NET provider supports a new class (FbConnectionStringBuilder) that makes the work with connection strings much easier:

You can create a connection string by specifying the properties item by item:

 

FbConnectionStringBuilder csb = new FbConnectionString(); 

csb.ClientLibrary = "fbembed.dll";//把该文件放入应用程序所在目录 

csb.UserID = "SYSDBA"; 

csb.Password = "masterkey"; 

csb.Database = "lix.fdb"; 

csb.ServerType = FbServerType.Embedded; //csb.ServerType = 1, embedded Firebird 

FbConnection c = new FbConnection(csb.ToString());

FbConnectionStringBuilder Properties Overview

补充：软件开发 , C# ,