Firebird + Entityframework with Visual Studio 2015

Asked

Viewed 297 times

0

Hello, I need to create a Firebird connection with visual studio, but I’m having problems with the integration, I searched videos on the internet, and only have reference 2012, I did not find anything more current.

I want to build my software with Entityframework (edmx) to facilitate transactions with the bank, however, I could not create the connection yet! I already added the Provider, but when I create my EDMX file does not display the Firebird connection.

PS: I already installed the bin on the Firebird website (the Provider), checked and the installer has already added the resources in the Machine.config file

Ever since I thank,

I’ll leave the links of the videos below. Link1 Link2

1 answer

2


Close your Visual Studio and install the DDEX Provider for Visual Studio and the ADO.NET Data Provider, both can be downloaded at the following link:

https://www.firebirdsql.org/en/additional-downloads/

After the installation go to the Machine.config file located in %windir%\Microsoft.NET\Framework\[version]\config\machine.config for 32 Bits or %windir%\Microsoft.NET\Framework64\[version]\config\machine.config to 64 Bits

And look for <DbProviderFactories> you see that the DDEX installer inserted two lines into Firebird, removing one and leaving only one.

Here’s an example of how it should look:

  <system.data>
    <DbProviderFactories>
      <add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
      <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=5.7.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
    </DbProviderFactories>
  </system.data>

Browser other questions tagged

You are not signed in. Login or sign up in order to post.