Re: [Firebird-net-provider] DbProviderServices

[Rand R. <ran...@ou...>]

So am I a lost case, or is there a possibility to fix it?

From: ran...@ou...
To: fir...@li...
Date: Thu, 24 Oct 2013 10:39:37 +0000
Subject: Re: [Firebird-net-provider] DbProviderServices




Hi.

Thanks for the post on your website, I am already able to run the EF6 solution I have, but I am unable to use the edmx file.

Still getting the same errors.
And your post only has the following entry 
You might want to use the Entity Framework's designer for instance and 
use DDEX in which case you need to install some other parts, but the 
core concept is the same. Once you understand these few steps (try 
changing or not doing something to see what goes wrong) you should have 
no problems doing it.

afraid to say it, but I still have problems doing it.
Since I am using Model-First I rely on the entity model to work 100%.

Deleting the entry out of machine.config, and only relying to app.config results in edmx file not opening as a whole. (Application is running without problems)
Message:
The ADO.NET provider with invariant name FirebirdSql.Data.FirebirdClient is either not registerd in the machine or application config file, or could not be loaded. See the inner exception for details.
(Notice that the message is saying that it cant find the invariant name in machine or application config file, as I mentioned I deleted it from machine config, but it exists in the application config as you have it in your sample solution)

Setting the DbProviderFactories in machine.config, results in the edmx showing up (but again I cannot do an "Update model from database", select firebird from database connections, and so on) additional to the lack of design time, I am also not able to run the application because its telling me its finding the invariant name twice - in machine/app config.
Message:
An exception of type 'System.Configuration.ConfigurationErrorsException' occurred in System.Configuration.dll but was not handled in user code

Additional information:An error occurred creating the configuration section handler for "system.data".: The column 'InvariantName' has to be unique. The value 'FirebirdSql.Data.FirebirdClient' exists already.

Than deleting the entry in app.config and soley relying on the entry in machine.config, results in edmx gets opened (but still the design support is broke no update model, no firebird selection in db connections, and so on...), and again not able to run the application this time getting the error:
An exception of type 'System.InvalidOperationException' occurred in System.Data.dll but was not handled in user code


Additional information: The requested .Net Framework Data 
Provider's implementation does not have an Instance field of a 
System.Data.Common.DbProviderFactory derived type.

So to atleast have a displaying model and a running application, I have now done the following.
I have the DbProviderFactories in both machine.config and app.config, in app.config I have added the following line to DbProviderFactories:
<remove invariant="FirebirdSql.Data.FirebirdClient" />

The whole thing looks like this now:
  <system.data>
    <DbProviderFactories>
      <remove invariant="FirebirdSql.Data.FirebirdClient" />
      <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>

This solution is far from being perfect, all the problems with the designer still exist "Update model from database", cant pick firebird as a new database connection, when I have edmx open my error list shows the error:
The requested .Net Framework Data Provider's implementation does not have an Instance field of a System.Data.Common.DbProviderFactory derived type.

Any help to fix the designer would be nice, since the application is running now for a while, when you first told me about FirebirdClientFactory being wrong in the providers config and it should be FbServiceProviders, from that point on I only had problems with designer which resulted into application running problems on my modfications trying to fix the designer.


> Date: Wed, 23 Oct 2013 18:03:55 +0200
> From: di...@ci...
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] DbProviderServices
> 
> Read this http://blog.cincura.net/233426-entity-framework-6-with-firebird/
> and *understand* it. Then you should be able to go thru tooling as
> well.
> 
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider