Its me again. :)
Not sure if thats a known issue and needs some attention, but let me ask anyway.
I have it now running, atleast the code runs.
But I am facing problems with the designer.
There are 2 kinda connected problems with this.
First, when I have the following line in my machine.config
<add name="FirebirdClient Data Provider"
invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data
Provider for Firebird EF6"
type="FirebirdSql.Data.FirebirdClient.FbProviderServices,
FirebirdSql.Data.FirebirdClient, Version=3.2.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c"/>
I can open the edmx, without problems but I cannot "Update Model from
Database". When I try to do so I am getting the following:
An exception of Type 'System.ArgumentException' occurred while attempting to
update from database. The exception message is: 'Unable to convert runtime
connection string to its design-time equivalent. Connection string: character
set=UTF8;initial catalog=C:\DB.FDB;data source=localhost;user
id=SYSDBA;password=masterkey'.
When I run the application EntityModel gets initialized successful, but when I
try to run a simple LINQ query I am getting the following message:
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.
This Additional Information also comes when I open the EDMX in xml format as an
tooltip (mouseover).
So I thought, okay neither the designer nor the execution is running smoothly
so change the machine.config back to FirebirdClientFactory, but I am getting
the following when I do so:
I cannot open the edmx, when I double click the edmx I am getting the message
The operation could not be completed.
Running the same simple LINQ query from above works now without problems.
In both scenarios, I cannot add a new server (connect to database) in visual
studio, the firebird isnt listed in this dialog (same with the Add New Item -->
Ado .Net Entity Model when you have to pick a database and say new connection).
I there a way to have the designer work 100%, or do I need to wait for a new
release?
From: rand.ran...@outlook.com
To: firebird-net-provider@lists.sourceforge.net
Date: Tue, 22 Oct 2013 13:18:13 +0000
Subject: Re: [Firebird-net-provider] DbProviderServices
So.....
After deinstalling the msi package again, checking the C:\windows\assembly once
more and again seeing no firebird dll entry.
I tried the console command gacutil and voila there were a dll still
registered, so I uninstalled the FirebirdSql assembly myself with
gacutil -u FirebirdSql.Data.FirebirdClient
Tough I am still getting a message saying that the version 3.0.2.0 is still
registered but cannot be uninstalled because its in use from some other
application...
(Maybe firebird server or Sql Manager Lite for Firebird ?!?)
Its now finally working, thanks for your patience. :D
> Date: Tue, 22 Oct 2013 14:15:27 +0200
> From: disk...@cincura.net
> To: firebird-net-provider@lists.sourceforge.net
> Subject: Re: [Firebird-net-provider] DbProviderServices
>
> Yes, in config you're missing the DbProviderFactories, that also
> means, given the error, that the provider is loaded from somewhere
> else, very likely GAC,
>
>
> --
> 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
------------------------------------------------------------------------------
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