Firebird + EntityFramework with Visual Studio 2015

Navigation
0

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

I want to build my software with EntityFramework (edmx) to make it easier on the bank transactions, but I was not able to create the connection yet! I already added the provider, but when I create my EDMX file it does not display the Firebird connection.

PS: I have already installed the bin on the Firebird site (the provider), I checked and the installer has already added the features in the Machine.config file

Thanks in advance,

I'll leave the links on the videos below. Link1 Link2

    
asked by anonymous 10.02.2017 / 19:13

1 answer

2

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

link

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

And look for <DbProviderFactories> you'll see that the DDEX installer inserted two lines into Firebird, remove one and leave 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>
    
23.02.2017 / 19:01
Error entering data into JPA PHP href redirect