Re: [Firebird-net-provider] DbProviderServices

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

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: ran...@ou...
To: fir...@li...
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: di...@ci...
> To: fir...@li...
> 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
> 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