Subject Error finding .Net provider but only in unit tests
Author GregB
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)

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 originally posted about this issue back in September 2009 and because of other priorities put it to bed for a while.

I have since took it up again and 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.


Greg B.