[Firebird-net-provider] Error finding .Net provider but only in unit tests

[Bradburn, G. (LNG-RDU) <gre...@le...>]

Greetings,

We are using Firebird 2.0.1 in embedded mode and everything works fine in the
application but whenever I try to run unit tests against Firebird I get either:
System.ArgumentException: Unable to find the requested .Net Framework Data
Provider. It may not be installed. at
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)

or
System.Configuration.ConfigurationErrorsException: Failed to find or load the
registered .Net Framework Data Provider. at
System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)

The former if have an entry in machine.config for
FirebirdSql.Data.FirebirdClient and the latter if I remove it.

I have spent days trying to diagnose this. I have verified that all the required dlls and supporting files for Firebird
embedded get copied to the TestResults\Out folder.

I had this issue in VS 2010 and am still having the issue after migrating my
projects to VS 2012 and .Net 4.5.

I tried upgrading Firebird to 2.5.2 and the Firebird Client to 3.0.2 and had the
exact same results.

Thanks in advance for any help you can offer on this.

Regards,

Greg B.

Regards,
Greg.
Greg Bradburn
Sr. Software Engineer
LexisNexis - Business of Law Software Solutions
2000 Regency Pkwy, Suite 600
Cary, NC 27518
919-297-1788 Direct