| DotNetFirebird Using Firebird SQL in .NET. |
|
Home
Features
Download
Documentation
FAQ
Tools and Code
About
Blog
|
Thursday, September 29, 2005
New Downloads: Provider 1.7.1 RC, Provider 2.0 Alpha, Firebird 1.5.3 RCThe following items were added to the downloads section:
See the downloads. Firebird for Experta: Episode 5 - Locking and Record VersionsAnother article by Ann Harris about the Firebird internals: Firebird for the Database Expert: Episode 5 - Locking and Record Versions. See also: Creating a New Database using Embedded Firebird and ADO.NET Provider 1.7I've been playing with the FbConnection.CreateDatabase method recently: It's now really easy to create a new database using the embedded Firebird. When using the version 1.6 of the Firebird ADO.NET Provider it was necessary to use feed the parameters into a Hashtable. It was also necessary to specify username and password (although it makes no sense for the embedded Firebird - see Embedded Firebird Security). Before Firebird ADO.NET Provider 1.7 you needed a code like this:
Hashtable parameters = new Hashtable();
parameters.Add("User", "SYSDBA");
parameters.Add("Password", "masterkey");
parameters.Add("Database", "database.fdb");
parameters.Add("ServerType", "1");
FbConnection.CreateDatabase(parameters);
The method FbConnection.CreateDatabase(Hashtable) is now obsolete. You can simply use the connection string. The username and password are no longer needed. The code for ADO.NET Provider 1.7 can be really simple: FbConnection.CreateDatabase(@"Database=database.fdb;ServerType=1"); You can still use the FbConnectionStringBuilder to create the connection string. Related: Wednesday, September 21, 2005
Firebird Global Usage Survey
If you are using Firebird database please take a look at the following survey: Firebird Global Usage Survey.
Previous
Archives
Copyright © 2005 - 2007 DotNetFirebird |