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: disk...@cincura.net
> To: firebird-net-provider@lists.sourceforge.net
> 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
> Firebird-net-provider@lists.sourceforge.net
> 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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
