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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Well, yours seems fine besides the DLL full name. 
My Test.config is as follows (the rest is just a couple of appSettings keys) :

  <system.data>
    <DbProviderFactories>
      <remove invariant="FirebirdSql.Data.FirebirdClient"/>
      <add name="FirebirdSql Data Provider"
       invariant="FirebirdSql.Data.FirebirdClient"
       description=".Net Framework Data Provider for FirebirdSql"
       type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient,
       Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"
    />
    </DbProviderFactories>
  </system.data>

I have also in my LocalTestRun.testrunconfig the following section to make sure all the DLLs
are in the test execution directory:

  <Deployment>
    <DeploymentItem filename="Externals\icuin30.dll" />
    <DeploymentItem filename="Externals\icudt30.dll" />
    <DeploymentItem filename="Externals\fbembed.dll" />
    <DeploymentItem filename="Externals\icuuc30.dll" />
  </Deployment>

El 02/08/2013, a las 16:00, "Bradburn, Greg (LNG-RDU)" <gre...@le...> escribió:

> Hernán,
>  
> Can you elaborate on what you mean by “Firebird’s entry”?
>  
> The app.config for the application, where Firebird works, has the following relevant entries:
> <configuration>
>   <configSections>
> <section name="cachingConfiguration"type="Microsoft.Practices.EnterpriseLibrary.Caching.Configuration.CacheManagerSettings, Microsoft.Practices.EnterpriseLibrary.Caching, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
>        <section name="dataProviderFactory"type="Juris.DataAccessLayer.Factory.DataProviderFactoryConfiguration, Juris.DataAccessLayer.Factory" allowLocation="true" allowDefinition="Everywhere"restartOnExternalChanges="true"/>
>        <section name="netTiersService"type="Juris.DataAccessLayer.Bases.NetTiersServiceSection, Juris.DataAccessLayer"allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
> </configSections>
>  
> <system.data>
>        <DbProviderFactories>
>               <add name="Firebird Data Provider"invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient"/>
>        </DbProviderFactories>
> </system.data>
>  
> <netTiersService>
>        <providers>
>               <add name="FirebirdNetTiersProvider"type="Juris.DataAccessLayer.FirebirdClient.FirebirdNetTiersProvider, Juris.DataAccessLayer.FirebirdClient" useStoredProcedure="true"providerInvariantName="FirebirdSql.Data.FirebirdClient"providerName="FirebirdSql.Data.FirebirdClient"entityFactoryType="Juris.Entities.EntityFactory" enableEntityTracking="true"enableMethodAuthorization="false" useEntityFactory="true" commandTimeout="30"/>
>               <add name="SqlNetTiersProvider" useStoredProcedure="true"enableEntityTracking="true" type="Juris.DataAccessLayer.SqlClient.SqlNetTiersProvider, Juris.DataAccessLayer.SqlClient" connectionStringName="SqlServerConnectionString"providerInvariantName="System.Data.SqlClient"entityFactoryType="Juris.Entities.EntityFactory" enableMethodAuthorization="false"useEntityFactory="true" commandTimeout="30"/>
>               <add name="WsNetTiersProvider"type="Juris.DataAccessLayer.WebServiceClient.WsNetTiersProvider, Juris.DataAccessLayer.WebServiceClient"url="http://localhost/NetTiersWS/JurisDataAccessLayerWebServices.asmx"commandTimeout="100"/>
>               <add name="MirrorNetTiersProvider" useStoredProcedure="true"enableEntityTracking="true" type="Juris.DataAccessLayer.SqlClient.SqlNetTiersProvider, Juris.DataAccessLayer.SqlClient" connectionStringName="SqlServerConnectionString"providerInvariantName="System.Data.SqlClient"entityFactoryType="Juris.Entities.EntityFactory" enableMethodAuthorization="false"useEntityFactory="true"/>
>        </providers>
> </netTiersService>
>  
> The app.config for the unit test project contains this:
> <configSections>
>   <section name="cachingConfiguration"type="Microsoft.Practices.EnterpriseLibrary.Caching.Configuration.CacheManagerSettings, Microsoft.Practices.EnterpriseLibrary.Caching, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
>   <section name="dataProviderFactory"type="Juris.DataAccessLayer.Factory.DataProviderFactoryConfiguration, Juris.DataAccessLayer.Factory" allowLocation="true" allowDefinition="Everywhere"restartOnExternalChanges="true"/>
>    <section name="netTiersService"type="Juris.DataAccessLayer.Bases.NetTiersServiceSection, Juris.DataAccessLayer"allowDefinition="MachineToApplication" restartOnExternalChanges="true"/>
> </configSections>
>  
> <dataProviderFactory>
>   <providers>
>     <provider dataSource="local" accessMode="local" connectionType="disconnected"name="FirebirdNetTiersProvider"/>
>     <provider dataSource="remote" accessMode="direct" connectionType="directConnect"name="SqlNetTiersProvider"/>
>     <provider dataSource="remote" accessMode="web" connectionType="webConnect"name="WsNetTiersProvider"/>
>   </providers>
> </dataProviderFactory>
>  
>   <system.data>
>     <DbProviderFactories>
>       <add name="Firebird Data Provider" invariant="FirebirdSql.Data.FirebirdClient"description=".Net Framework Data Provider for Firebird"type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient"/>
>     </DbProviderFactories>
>   </system.data>
> <netTiersService>
>     <providers>
>       <add name="FirebirdNetTiersProvider"type="Juris.DataAccessLayer.FirebirdClient.FirebirdNetTiersProvider, Juris.DataAccessLayer.FirebirdClient" useStoredProcedure="true"providerInvariantName="FirebirdSql.Data.FirebirdClient"providerName="FirebirdSql.Data.FirebirdClient"entityFactoryType="Juris.Entities.EntityFactory" enableEntityTracking="true"enableMethodAuthorization="false" useEntityFactory="true" pooling="false"/>
>       <add name="SqlNetTiersProvider" useStoredProcedure="true"enableEntityTracking="true" type="Juris.DataAccessLayer.SqlClient.SqlNetTiersProvider, Juris.DataAccessLayer.SqlClient" providerInvariantName="System.Data.SqlClient"entityFactoryType="Juris.Entities.EntityFactory" enableMethodAuthorization="false"/>
>       <add name="WsNetTiersProvider"type="Juris.DataAccessLayer.WebServiceClient.WsNetTiersProvider, Juris.DataAccessLayer.WebServiceClient"url="http://localhost/NetTiersWS/JurisDataAccessLayerWebServices.asmx"/>
>     </providers>
> </netTiersService>
>  
> What is it that I am missing?
>  
> Thanks,
>  
> Greg.
> From: Hernán Martínez [mailto:her...@ob...] 
> Sent: Thursday, August 01, 2013 4:57 PM
> To: For users and developers of the Firebird .NET providers
> Cc: fir...@li...
> Subject: Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests
>  
> You want to add Firebird's entry also in the test project app.config file.
> Include a remove before the add too.
> 
> Hernán MF S
> 
> El 01/08/2013, a las 22:08, "Bradburn, Greg (LNG-RDU)" <gre...@le...> escribió:
> 
> 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
> 
>  
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent 
> caught up. So what steps can you take to put your SQL databases under 
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent 
> caught up. So what steps can you take to put your SQL databases under 
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk_______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

A powerful, cross platform, SQL database system

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