Embedded Firebird: Full-Featured Embedded Database with 2 MB Runtime

Hi, The Embedded Firebird in .NET Link is no longer available

Hi, The Embedded Firebird in .NET is no longer available

<br />
			private void button1_Click(object sender, System.EventArgs e)<br />
			{<br />
				string DbFilePath = @"C:\...\EmbeddedDB\Firebird\Sample\EmbeddedFirebirdExample\bin\x64\Debug\TestingDatabase.FDB";<br />
				string FullConnString = this.connectionString + DbFilePath;<br />
<br />
				// STEP 1. Create (or Re-create) database and database file <br />
				if (!System.IO.File.Exists(DbFilePath))<br />
				{<br />
					FbConnection.CreateDatabase(FullConnString);<br />
				}<br />
				<br />
<br />
				FbConnection conn = new FbConnection(FullConnString);<br />
				conn.Open();<br />
<br />
				// STEP 2. Change default SYSDBA pwd? No!<br />
				// This will not work on embedded Firebird!<br />
				/*<br />
				string AlterPwdCmdSQL = "alter user SYSDBA password 'xyzabc123'";<br />
				FbCommand AlterPwdCmd = conn.CreateCommand();<br />
				AlterPwdCmd.CommandText = AlterPwdCmdSQL;<br />
				AlterPwdCmd.ExecuteNonQuery();<br />
				*/<br />
<br />
				// STEP 3. Create a table<br />
				// NOTE: Can only do this once! <br />
				// REF 1: http://web.firebirdsql.org/dotnetfirebird/blog/2005/01/creating-database-programmatically.html<br />
				// REF 2: http://www.firebirdfaq.org/faq69/<br />
				// STEP 3.1 Check if table exists - CAUTION: Table name upper case!!!<br />
				string SimpleCheckIfTableExists = "select count(1) from rdb$relations where rdb$relation_name = 'EIK'";<br />
				FbCommand CheckTableExistCmd = conn.CreateCommand();<br />
				CheckTableExistCmd.CommandText = SimpleCheckIfTableExists;<br />
				int CountTable = (int)CheckTableExistCmd.ExecuteScalar();<br />
				if (CountTable > 0)<br />
				{<br />
					// Drop table<br />
					string SimpleDropTableIfExists = "drop table EIK;";<br />
					FbCommand DropTableCmd = conn.CreateCommand();<br />
					DropTableCmd.CommandText = SimpleDropTableIfExists;<br />
					DropTableCmd.ExecuteNonQuery();<br />
				}<br />
<br />
				// STEP 3.2 Re-create the table<br />
				// CAUTION: <br />
				// (a) "Timestamp" is a reserved keyword for Firebird.<br />
				// (b) Table name "eik" -- Actual created table name = "EIK" <br />
				string SimpleCreateTableSQL = "create table eik (a int not null primary key, b int not null unique, c timestamp default current_timestamp);";<br />
				FbCommand CreateTableCmd = conn.CreateCommand();<br />
				CreateTableCmd.CommandText = SimpleCreateTableSQL;            <br />
				CreateTableCmd.ExecuteNonQuery();<br />
				<br />
				// STEP 4. Insert row<br />
				// NOTE: Can only do this once! (PK constraint!)<br />
				string SimpleInsertSQL = "insert into eik (a,b) values (123,456);";<br />
				FbCommand InsertRowCmd = conn.CreateCommand();<br />
				InsertRowCmd.CommandText = SimpleInsertSQL;<br />
				InsertRowCmd.ExecuteNonQuery();<br />
				<br />
				// STEP 5. A simple select<br />
				FbDataAdapter da = new FbDataAdapter("SELECT * FROM eik", FullConnString);<br />
				// FbDataAdapter da = new FbDataAdapter("SELECT * FROM table1", this.connectionString + this.textBox1.Text);<br />
				DataTable dt = new DataTable();<br />
				da.Fill(dt);<br />
				this.dataGrid1.DataSource = dt;<br />
			}<br />

<br />
					DataRow[] RowsImported = LoadFromSomeDataTable(MyData);<br />
					bc = new System.Data.SqlClient.SqlBulkCopy(Conn);<br />
                    bc.BulkCopyTimeout = 60 * 60;<br />
                    bc.DestinationTableName = SomeName;<br />
                    bc.WriteToServer(RowsImported);<br />

<br />
			CREATE TABLE ext1 EXTERNAL 'c:\myfile.txt'<br />
			(<br />
				field1 char(20),<br />
				field2 smallint<br />
			);<br />

<br />
				INSERT INTO realtable1 (field1, field2)<br />
				SELECT field1, field2 FROM ext1;<br />

<br />
				string DbFilePath = @"D:\...\SampleData.FDB";<br />
				string FullConnString = this.connectionString + DbFilePath;<br />
				FbConnection conn = new FbConnection(FullConnString);<br />
				conn.Open();<br />
				 <br />
				string AlterPwdCmdSQL = "alter user SYSDBA password 'xyzabc123'";<br />
				FbCommand AlterPwdCmd = conn.CreateCommand();<br />
				AlterPwdCmd.CommandText = AlterPwdCmdSQL;<br />
				AlterPwdCmd.ExecuteNonQuery();<br />

<br />
				+ ex {"unsuccessful metadata update\r\nI/O error during \"CreateFile (open)\" operation for file \"C:\\...\\EMBEDDEDFIREBIRDEXAMPLE\\BIN\\X64\\DEBUG\\SECURITY2.FDB\"\r\nError while trying to open file"} FirebirdSql.Data.Common.IscException<br />

<br />
				The Windows Embedded Server is a Superserver engine plus client rolled into one library, called fbembed.dll. It is available as a separate download package. The embedded server (introduced with Firebird 1.5) was specifically designed to facilitate deployment of applications that ship with a Firebird server included. Installation is just a matter of unpacking the DLL and a few other files to the desired location. The security database is not used at all: anyone can connect to any database, as long as the user running the application has filesystem-level access rights to the database(s) in question... The embedded server has no facility to accept any network connections. Only true local access is possible, with a connect string that doesn't contain a host name (not even localhost).<br />

DbProviderFactories.GetFactory("FirebirdSql.Data.FirebirdClient");      <-- This will blow up!<br />

			<br />
					D:\...\Firebird\ClientProviderSrc\source\FirebirdSql\Data\bin\Debug>gacutil /i FirebirdSql.Data.FirebirdClient.dll<br />
						Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1<br />
						Copyright (c) Microsoft Corporation.  All rights reserved.<br />
						Assembly successfully added to the cache<br />
<br />
				Now, /u will tell you public key of the dll!<br />
				<br />
					D:\...Firebird\ClientProviderSrc\source\FirebirdSql\Data\bin\Debug>gacutil /u FirebirdSql.Data.FirebirdClient<br />
						Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.1<br />
						Copyright (c) Microsoft Corporation.  All rights reserved.<br />
						<br />
					D:\...\Firebird\ClientProviderSrc\source\FirebirdSql\Data\bin\x64\Debug>gacutil /u FirebirdSql.Data.FirebirdClient<br />
					Assembly: FirebirdSql.Data.FirebirdClient, Version=2.7.5.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=AMD64<br />
					Uninstalled: FirebirdSql.Data.FirebirdClient, Version=2.7.5.0, Culture=neutral,<br />
					PublicKeyToken=3750abcc3150b00c, processorArchitecture=AMD64<br />
					Number of assemblies uninstalled = 1<br />
					Number of failures = 0<br />

<br />
				<?xml version="1.0"?><br />
				<configuration><br />
				  <configSections><br />
					... other stuff ...<br />
				  </configSections><br />
<br />
				  <system.data><br />
					<DbProviderFactories><br />
					  <!-- rao: Firebird driver; prefer locally placed driver (any version)--><br />
					  <remove invariant="FirebirdSql.Data.FirebirdClient" /><br />
					  <add name="FirebirdSql.Data.FirebirdClient" invariant="FirebirdSql.Data.FirebirdClient" description="Firebird Data Provider for .NET" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Culture=neutral, PublicKeyToken=3750abcc3150b00c" /><br />
					</DbProviderFactories><br />
				  </system.data><br />
					... other stuff ...<br />
				</configuration><br />