Multiple Providers

Hello,

I have two databases that I am trying to use. I generated both of them thru nettiers templates. I modified and here is my webconfig file.

<configSections>

<section name="netTiersService"
type="TSC.DataAccessLayer.Bases.NetTiersServiceSection, TSC.DataAccessLayer"
allowDefinition="MachineToApplication"
restartOnExternalChanges="true" />

<section name="netTiersService2"
type="SFMembership.DataAccessLayer.Bases.NetTiersServiceSection, SFMembership.DataAccessLayer"
allowDefinition="MachineToApplication"
restartOnExternalChanges="true" />
</configSections>

<connectionStrings>
<add name="netTiersConnectionString" connectionString="Data Source=ALYHOME\SQLEXPRESS;Initial Catalog=Test1;Integrated Security=true;Connection Timeout=1;" />
<add name="netTiersConnectionString2" connectionString="Data Source=ALYHOME\SQLEXPRESS;Initial Catalog=DB1Test;Integrated Security=true;Connection Timeout=1;" />

</connectionStrings>
<netTiersService defaultProvider="SqlNetTiersProvider">

<providers>

<add
name="SqlNetTiersProvider2"
type="SFMembership.DataAccessLayer.SqlClient.SqlNetTiersProvider, SFMembership.DataAccessLayer.SqlClient"
connectionStringName="netTiersConnectionString2"
useStoredProcedure="false"
providerInvariantName="System.Data.SqlClient"/>

<add
name="SqlNetTiersProvider"
type="TSC.DataAccessLayer.SqlClient.SqlNetTiersProvider, TSC.DataAccessLayer.SqlClient"
connectionStringName="netTiersConnectionString"
useStoredProcedure="false"
providerInvariantName="System.Data.SqlClient"/>
</providers>
</netTiersService>
<appSettings/>

I am getting the following error.

Provider must implement the class 'TSC.DataAccessLayer.Bases.NetTiersProvider'.

Any suggestions?

<configSections>
<section name="netTiersService"
type="TSC.DataAccessLayer.Bases.NetTiersServiceSection, TSC.DataAccessLayer"
allowDefinition="MachineToApplication"
restartOnExternalChanges="true" />

<section name="netTiersService2"
type="SFMembership.DataAccessLayer.Bases.NetTiersServiceSection, SFMembership.DataAccessLayer"
allowDefinition="MachineToApplication"
restartOnExternalChanges="true" />
</configSections>

<connectionStrings>
<add name="netTiersConnectionString" connectionString="Data Source=ALYHOME\SQLEXPRESS;Initial Catalog=Test1;Integrated Security=true;Connection Timeout=1;" />
<add name="netTiersConnectionString2" connectionString="Data Source=ALYHOME\SQLEXPRESS;Initial Catalog=DB1Test;Integrated Security=true;Connection Timeout=1;" />
</connectionStrings>

<netTiersService defaultProvider="SqlNetTiersProvider">
<providers>
<add
name="SqlNetTiersProvider"
type="TSC.DataAccessLayer.SqlClient.SqlNetTiersProvider, TSC.DataAccessLayer.SqlClient"
connectionStringName="netTiersConnectionString"
useStoredProcedure="false"
providerInvariantName="System.Data.SqlClient"/>
</providers>
</netTiersService>

<netTiersService2 defaultProvider="SqlNetTiersProvider2">
<providers>
<add
name="SqlNetTiersProvider2"
type="SFMembership.DataAccessLayer.SqlClient.SqlNetTiersProvider, SFMembership.DataAccessLayer.SqlClient"
connectionStringName="netTiersConnectionString2"
useStoredProcedure="false"
providerInvariantName="System.Data.SqlClient"/>
</providers>
</netTiersService2>

In addition to modifying your web.config file as shown above you also need to edit the nettiers template file DataRepository.cst file under DataAccessLayer/

Edit the following line:

_section = WebConfigurationManager.GetSection("netTiersService") as NetTiersServiceSection;

And change it to

_section = WebConfigurationManager.GetSection("<insert your own section here") as NetTiersServiceSection;

Cheers,

Hugo