Thanks again for the reply,
My LocalTestRun.testrunconfig has the following deployment items:
<Deployment>
<DeploymentItem filename="Core\Core Unit Tests\FirebirdEmbedded\" />
<DeploymentItem
filename="Core\Juris.DataAccessLayer.CacheManagement\InitialCache.fdb.zip" />
</Deployment>
The FirebirdEmbedded folder contains:
aliases.conf
doc <dir>
fbembed.dll
firebird.conf
firebird.msg
ib_util.dll
icudt30.dll
icuin30.dll
icuuc30.dll
IDPLicense.txt
Intl <dir>
IPLicense.txt
Microsoft.VC80.CRT.manifest
msvcp80.dll
msvcr80.dll
Readme.txt
Udf <dir>
My test class has the following attributes decorating it:
[TestClass]
[DeploymentItem(@"InitialCache.fdb.zip")]
[DeploymentItem(@"FirebirdEmbedded\aliases.conf")]
[DeploymentItem(@"FirebirdEmbedded\fbembed.dll")]
[DeploymentItem(@"FirebirdEmbedded\firebird.conf")]
[DeploymentItem(@"FirebirdEmbedded\firebird.msg")]
[DeploymentItem(@"FirebirdEmbedded\ib_util.dll")]
[DeploymentItem(@"FirebirdEmbedded\icudt30.dll")]
[DeploymentItem(@"FirebirdEmbedded\icuin30.dll")]
[DeploymentItem(@"FirebirdEmbedded\icuuc30.dll")]
[DeploymentItem(@"FirebirdEmbedded\IDPLicense.txt")]
[DeploymentItem(@"FirebirdEmbedded\IPLicense.txt")]
[DeploymentItem(@"FirebirdEmbedded\Microsoft.VC80.CRT.manifest")]
[DeploymentItem(@"FirebirdEmbedded\msvcp80.dll")]
[DeploymentItem(@"FirebirdEmbedded\msvcr80.dll")]
[DeploymentItem(@"FirebirdEmbedded\intl")]
[DeploymentItem(@"FirebirdEmbedded\udf")]
My unit test Setup method also has code to manually copy the firebird files to
the executing folder (this is ancient code that I inherited).
I have verified that the
C:\Users\Bradbuga\AppData\Local\Temp\TestResults\bradbuga_LNGRDUB-4157824
2013-07-31 15_41_36\Out folder contains all of those files, including the intl
and Udf folders with all their contents, along with all the assemblies needed
to run the tests.
There is also a couple of "Deploy" folders under TestResults but nothing is in
them.
Thanks in advance for anything else you can think of. Since, I take it, your
unit tests run fine, and that I must be doing something wrong.
Regards,
Greg.
-----Original Message-----
From: Hernan Martinez [mailto:hernan.marti...@obi-corp.com]
Sent: Friday, August 02, 2013 3:35 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Error finding .Net provider but only in
unit tests
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)"
<gregory.bradb...@lexisnexis.com> 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.NetTiersServic
> eSection, 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.NetTiersServic
> eSection, 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:hernan.marti...@obi-corp.com]
> Sent: Thursday, August 01, 2013 4:57 PM
> To: For users and developers of the Firebird .NET providers
> Cc: firebird-net-provider@lists.sourceforge.net
> 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)"
> <gregory.bradb...@lexisnexis.com> 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.c
> lktrk _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> 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.c
> lktrk_______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> 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
Firebird-net-provider@lists.sourceforge.net
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
