Re: [Firebird-net-provider] Help generating an EDMX on EF6

[Jiří Č. <ji...@ci...>]

Hi,

Your set up looks correct, but EF cannot load the provider for some reason.

What I haven’t tried is using embedded FB with EF6 and EDMX – as the provider with embedded needs some IL emit and the provider is now executed in copyied sandboxed environment it might be an issue. Just guessing. Maybe try (for development) use server.

Or maybe you can get this https://github.com/cincuranet/EF6_Firebird/tree/master/EDMX and start from it.

--
Mgr. Jiří Činčura
Independent IT Specialist

From: Brian Liedtke [mailto:li...@fr...]
Sent: Sunday, May 3, 2015 3:45 AM
To: fir...@li...
Subject: [Firebird-net-provider] Help generating an EDMX on EF6

Hey all,

I’ve been beating my head against the wall this past week trying to get this solved.
After reading Jiri’s blog on upgrading to EF6 and going through the email archives,
I haven’t found a solution. After trying everything I can think of I am out of ideas.

Here what is happening. I am trying to upgrade to EF6. Everything looks good on the install.
I can build and run but when I try to generate an EDMX, I get the following error.

[image]

Environment is:
OS: Windows 8.1
Visual Studio 2013 Version 12.0.31101.00 Update 4
.Net Provider 4.6.2.0
DDEX 3.0.1.0
.Net Framework 4.5.1
Language C#
Firebird embedded server

And yes, I have removed all bin and obj directories and then do a clean build.
I can then run the application with no problems.

I first removed the old .NET Provider from the GAC and uninstalled it.
I then installed the latest and greatest .NET provider through NuGet in Visual Studio.
install-package EntityFramework
install-package EntityFramework.Firebird
update-package

[image]

The app.config file for the main project is also shown.

I can setup and view a data connection through the server explorer. So I believe I have the DDEX working.

[image]

Since I didn’t get the EDMX to generate. I heeded Jiri’s comment on his blog
http://blog.cincura.net/233472-entity-framework-6-with-firebird-updated/
to make sure that the DDEX is using the same FirebirdClient as the project and
added the new provider to the GAC.

[image]

The machine.config file for both 32 and 64 bit have the following entry.

[image]

I have run both versions of the DbProviderFactories  FirebirdClient Data Provider entry with the same result.

I then checked to see if there were any other versions of FirebirdSql.Data.FirebirdClient on my system.

[image]

Nope. Only the libraries in the GAC and the project’s packages directory.
C:\Windows\Microsoft.NET\assembly\GAC_MSIL\FirebirdSql.Data.FirebirdClient\v4.0_4.6.2.0__3750abcc3150b00c
C:\Users\liedtke\Documents\Visual Studio 2013\Projects\MyGen\packages\FirebirdSql.Data.FirebirdClient.4.6.2.0\lib\net40-client
C:\Users\liedtke\Documents\Visual Studio 2013\Projects\MyGen\packages\FirebirdSql.Data.FirebirdClient.4.6.2.0\lib\net45

The one in the GAC is the net45 library. (See above)

So, either I have missed a something (probably in a config file), or there is a bug. I lean toward the former.

Thanks in advance,
Brian