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

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

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...
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.