Quantcast

Reverse engineering in Visual Studio 2013 (.Net 4.5.1, FirebirdClient-EF6 v4.1 and EF6) fails with 'no compatible EF database provider'

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Reverse engineering in Visual Studio 2013 (.Net 4.5.1, FirebirdClient-EF6 v4.1 and EF6) fails with 'no compatible EF database provider'

Morten Myrvold
This post was updated on .
Hi,

 

I've been trying to get the Firebird ADO.NET Provider to work in Visual
Studio2013 in order to reverse engineer my Firebird database in EF6, but no
matter how I go about installing, I keep getting "a ton of" different error
messages and weird behavior. Many of these, I have later been able to
eliminate by reinstalling my .Net versions.

I think maybe there were some configuration errors there, but that should be
sorted out now. All .Net verification tests I have run says they're all OK.

 

I have messed around with both the MSI installers (NetProvider 4.1.0.0 and
DDEX  3.0.1) found on http://www.firebirdsql.org/en/net-provider/, and NuGet
packages in Visual Studio 2013.

It seems to me that I needed to "manually" download the MSI installers for
NetProvider and DDEX in order to get the Server Explorer connection to
function in VStudio, and that the NuGet packages are only necessary for the
project references?

 

Anyway; at this point, I have a situation where I can successfully add the
database to the Server Explorer in VS, but when I try to "Update model from
database" on an empty edmx file in my project, it says:

"Your project references the latest version of Entity Framework; however, an
Entity Framework database provider compatible with this version could not be
found for your data connection. Exit this wizard, install a compatible
provider, and rebuild your project before performing this action." Above
this text, the only option is "Entity Framework 6.0", and it is checked and
disabled (as it's the only choice).

Viewing NuGet packages for project, I do have both the "EntityFramework"
(v6.0.2) and "Firebird ADO.NET Data provider (Entity Framework 6)" (v6.0.2),
but anyhow it still says the NetProvider is not compatible with EF6? I have
tried both .Net framework 4 and 4.5, but they both failed the same way.

 

I've scoured the net (and this list) in search of correct installation
procedures, but have come up short so far...

 

Does anyone have any idea what could be wrong?  This is really getting quite
frustrating now.

Any tips would be greatly appreciated! J

 

 

Regards,

Morten



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reverse engineering in Visual Studio 2013 (FirebirdClient-EF6 v4.1 and EF6) fails

Jiří Činčura
On Tue, Feb 25, 2014 at 9:31 PM, Morten Myrvold <[hidden email]> wrote:
>
> Does anyone have any idea what could be wrong?  This is really getting quite frustrating now…


VS is very likely loading version from GAC and hence it cannot see EF6
version. Maybe you also didn't changed the config (NuGet package is
not currently doing it automatically) so the designer is falling back
to non-EF6 mode. Maybe you'll hit also
http://tracker.firebirdsql.org/browse/DNET-542
(https://github.com/cincuranet/NETProvider/tree/ef6-schema3).


--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Reverse engineering in Visual Studio 2013 (FirebirdClient-EF6 v4.1 and EF6) fails

Morten Myrvold
Thanks! Your tip got me a step further!

I uninstalled the NetProvider msi package, and un-GAC'ed all the remaining FirebirdClients (yes, I actually had several). Then, I added the NetProvider-EF6 NuGet package (for the x'th time) and made sure my config was correct. Now, when I try to reverse engineer, I run into the DNET-542 issue you mention.
But anyhow; I got past the other problems at least! :-) I'll just wait for the update then...

Regards,
Morten

Loading...