Firebird Documentation IndexFirebird 3.0 Developer's GuideDeveloping Firebird Applications with Microsoft Entity Framework → Setting Up for Firebird in Visual Studio 2015
Firebird Home Firebird Home Prev: Methods of Interacting with a DatabaseFirebird Documentation IndexUp: Developing Firebird Applications with Microsoft Entity FrameworkNext: Creating a Project

Setting Up for Firebird in Visual Studio 2015

Table of Contents

The Installation Process

To prepare for working with Firebird, you will need to install the following:

There is nothing difficult in installing the first two. They are currently distributed and installed into a project by means of the NuGet package manager. The DDEX Provider library, designed for operating Visual Studio wizards, is not so easy to install and may take more time and effort.

Efforts have been made to automate the installation process and include all components in a single installer package. However, you might need to install all of the components manually under some conditions. If so, you can download the following:

The Installation Process

Table of Contents

Steps
Testing the Installation

Important!

Because the installation involves operations in protected directories, you will need administrator privileges to do it.

Steps

  1. Install FirebirdSql.Data.FirebirdClient-4.10.0.0.msi
  2. Unpack EntityFramework.Firebird-4.10.0.0-NET45.7z to the folder with the installed Firebird client. In my case, it is the folder c:\Program Files (x86)\FirebirdClient\.

  3. You need to install a Firebird build into the GAC. For your convenience, specify the path to the gacutil utility for .NET Framework 4.5 in the environment variable %PATH%. In my case, the path is c:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.1 Tools\

  4. Run the command shell cmd.exe as administrator and go to the directory with the installed client, e.g.,

      chdir "c:\Program Files (x86)\FirebirdClient"
                  

  5. Now make sure that FirebirdSql.Data.FirebirdClient is installed into the GAC by typing the following command:

      gacutil /l FirebirdSql.Data.FirebirdClient
                  

    If FirebirdSql.Data.FirebirdClient has not been installed into the GAC, use the following command to do it now:

      gacutil /i FirebirdSql.Data.FirebirdClient.dll
                  

  6. Now install EntityFramework.Firebird into the GAC

      gacutil /i EntityFramework.Firebird.dll
                  

  7. Unpack DDEXProvider-3.0.2.0.7z to a directory convenient for you. Mine was unpacked to c:\Program Files (x86)\FirebirdDDEX\.

  8. Unpack the contents of the /reg_files/VS2015 subdirectory from the archive DDEXProvider-3.0.2.0-src.7z there as well.

    Author's remark

    For some strange reason these files are absent from the archive with the compiled dll libraries, but they are present in the source code archive.

  9. Open the FirebirdDDEXProvider64.reg file in Notepad. Find the line that contains %path% and change it to the full path to the file FirebirdSql.VisualStudio.DataTools.dll, e.g.,

    "CodeBase"="c:\\Program Files (x86)\\FirebirdDDEX\\FirebirdSql.VisualStudio.DataTools.dll"
                  

  10. Save this Registry file and run it. Click YES to the question about adding the information to the Registry.

  11. Now you need to edit the machine.config file. In my installation, the path is as follows:

      C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
                  

    Open this file in Notepad. Find the following section:

      <system.data>
          <DbProviderFactories>
                        

    Add the following lines to this section:

    <add name="FirebirdClient Data Provider"
         invariant="FirebirdSql.Data.FirebirdClient"
         description=".Net Framework Data Provider for Firebird"
         type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
               FirebirdSql.Data.FirebirdClient, Version=4.10.0.0, Culture=neutral,
               PublicKeyToken=3750abcc3150b00c" />
                  

    Note

    The settings we have configured here are valid for version 4.10.0.

    Do the same for machine.config located at c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\

This completes the installation.

Testing the Installation

To make sure that everything has been installed successfully, start Visual Studio 2015. Find the Server Explorer and try to connect to an existing Firebird database.

Figure 4.1. Choose data source for testing installation

Choose data source for testing installation


Figure 4.2. Locate a database

Locate a database


Figure 4.3. Test and confirm the connection

Test and confirm the connection


Prev: Methods of Interacting with a DatabaseFirebird Documentation IndexUp: Developing Firebird Applications with Microsoft Entity FrameworkNext: Creating a Project
Firebird Documentation IndexFirebird 3.0 Developer's GuideDeveloping Firebird Applications with Microsoft Entity Framework → Setting Up for Firebird in Visual Studio 2015