Re: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

[Joël G. <J.G...@fa...>]

Hi Firebird-net-provider,

Still no solution, has anyone an idea how to fix this? I have the idea, EF still finds traces of the old version of the Firebird .Net provider… What I also saw is that the Firebird .Net provider EF6 is only on NuGet and not as an install, so Windows has no notice of the new driver.

Kind regards,

Joël Gijbels.

Van: Joël Gijbels
Verzonden: woensdag 19 maart 2014 9:29
Aan: 'mc...@mc...'; fir...@li...
Onderwerp: RE: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

HI Marco,

Thanks for your response. I forgot to mention that in my initial quest. Yes, I did do that. Here is the content of my App.config fil:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <system.data>
    <DbProviderFactories>
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>

Kind regards,

Joël Gijbels

Van: Marco Castro - McSoft [mailto:mc...@mc...]
Verzonden: dinsdag 18 maart 2014 19:19
Aan: Joël Gijbels; fir...@li...<mailto:fir...@li...>
Onderwerp: RE: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.



Hello Joel,
Did you configured your App.config file with this provider configuration?
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.1" />
  </startup>
  <system.data>
    <DbProviderFactories>
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
    </providers>
  </entityFramework>
</configuration>

          Best  regards,
Marco Aurelio Castro
Director
McSoft
McSoft<http://www.mcsoft.com.br> | A Empresa<http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnEmpresa.htm> | Nosso sistema<http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnSolucoes.htm>
[Facebook]<http://www.facebook.com/McSoftBH>[Twitter]<http://twitter.com/mcsoft>


----- Original Message -----
From: Joël Gijbels [mailto:J.G...@fa...]
To: fir...@li...<mailto:fir...@li...>
Sent: Tue, 18 Mar 2014 11:00:26 +0000
Subject: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.
Hi Firebird-net-provider,

As a .Net developer I have been asked to connect to a Firebird database via Entity Framework. I installed both the Data Provider and the DDEX.

[cid:image002.jpg@01CF3497.1BAF19C0]

Via NuGet I added Entity Framework 6.0.2 and the Firebird ADO.NET Data Provider (Entity Framework 6).

[cid:image004.jpg@01CF3497.1BAF19C0]

So far so good, I managed to open the ADO.Net Entity Data Model wizard, select the correct database for a database first approach. But then I get this confusing error according to the version of the database provider I have installed.

[cid:image009.jpg@01CF3497.1BAF19C0]

Any help would be appreciated. If you need more info, please let me know.

Thanks in advance for your advice.

Kind regards,

Joël Gijbels.