Server Error in '/WareHouse2' Application.

---

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 74:                             _providers = new NetTiersProviderCollection();
Line 75: 
Line 76:                             ProvidersHelper.InstantiateProviders(section.Providers, _providers, typeof(NetTiersProvider));
Line 77:                             _provider = _providers[section.DefaultProvider];
Line 78: 

[NullReferenceException: Object reference not set to an instance of an object.]
   NetTier.DAL.DataRepository.LoadProviders() in c:\C_WH\WareHouse2\App_Code\DAL\NetTier\NetTier.DAL\DataRepository.cs:76
   NetTier.DAL.DataRepository.get_ProductsProvider() in c:\C_WH\WareHouse2\App_Code\DAL\NetTier\NetTier.DAL\DataRepository.cs:302
   WareHouse.DAL.DataObjects.SqlServer.SqlServerProductDao.GetProducts() in c:\C_WH\WareHouse2\App_Code\DAL\DataObjects\SqlServer\SqlServerProductDao.cs:58
   WareHouse.BLL.Facade.ProductFacade.GetProducts() in c:\C_WH\WareHouse2\App_Code\BLL\Facade\ProductFacade.cs:32

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
   System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +17
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +676
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2664
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +84
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +154
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +99
   C1.Web.C1WebGrid.C1WebGrid.DataBind(Boolean keepGroups) +280
   C1.Web.C1WebGrid.C1WebGrid.DataBind() +39
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +92
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +100
   System.Web.UI.Control.EnsureChildControls() +134
   System.Web.UI.Control.PreRenderRecursiveInternal() +109
   System.Web.UI.Control.PreRenderRecursiveInternal() +233
   System.Web.UI.Control.PreRenderRecursiveInternal() +233
   System.Web.UI.Control.PreRenderRecursiveInternal() +233
   System.Web.UI.Control.PreRenderRecursiveInternal() +233
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4437

if (_provider == null)

{

      #region Find NetTiersServiceSection

    // Get a reference to the <netTiersService> section

    //NetTiersServiceSection section = (NetTiersServiceSection)WebConfigurationManager.GetSection("netTiersService");

      Configuration config = null;

      // load specific config file

      if ( HttpContext.Current != null )

      {

            config = WebConfigurationManager.OpenWebConfiguration("~");

      }

      else

      {

            string configFile = AppDomain.CurrentDomain.SetupInformation.ConfigurationFile.Replace(".config", "").Replace(".temp", "");

            config = ConfigurationManager.OpenExeConfiguration(configFile);

      }

      // find the specific NetTiersServiceSection for this assembly

          foreach ( ConfigurationSection temp in config.Sections )

          {

                if ( temp is NetTiersServiceSection )

                {

                      section = temp as NetTiersServiceSection;

                      break;

                }

          }

          #endregion Find NetTiersServiceSection

        // Load registered providers and point _provider to the default provider

        _providers = new NetTiersProviderCollection();

        ProvidersHelper.InstantiateProviders(section.Providers, _providers, typeof(NetTiersProvider));

        _provider = _providers[section.DefaultProvider];

    if (_provider == null)

    {

        throw new ProviderException("Unable to load default NetTiersProvider");

    }

}

========================================================================

This is the NetTierServiceSection that should be picking up the provider

Here is the code for  my web.config which has the NetTierSection:

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<configSections>

    <section name="netTiersService" type="NetTier.DAL.Bases.NetTiersServiceSection, NetTier.DAL"/>

  </configSections>

  <connectionStrings>

    <remove name="aspnetdbConnectionString"/>

    <add name="aspnetdbConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=aspnetdb;Integrated Security=True" providerName="System.Data.SqlClient"/>

    <add name="WareHouseConnectionString" connectionString="Data Source=PROB001\SQL2005TEST;Initial Catalog=WareHouse;Integrated Security=True" providerName="System.Data.SqlClient"/>

  </connectionStrings>

  <appSettings/>

  <system.web>

    <membership defaultProvider="LocalMembershipProvider">

      <providers>

        <add connectionStringName="aspnetdbConnectionString" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression="" name="LocalMembershipProvider" type="System.Web.Security.SqlMembershipProvider"/>

      </providers>

    </membership>

</system.web>

  <netTiersService defaultProvider="SqlNetTiersProvider">

    <providers>

      <add name="SqlNetTiersProvider" type="NetTier.DAL.SqlClient.SqlNetTiersProvider, NetTier.DAL.SqlClient"

           useStoredProcedure="true" connectionStringName="WareHouseConnectionString" applicationName="WareHouseWeb"  providerInvariantName="System.Data.SqlClient"/>

    </providers>

  </netTiersService>

</configuration>

Has anyone seen this problem or see something obvious.  This has been driving me Nuts for about 3 days now.

Thanks

Nick

{

}

so my section = null

================================================================

The _Provider seems to show _providers = {NetTier.DAL.Bases.NetTiersProviderCollection}

<netTiersService defaultProvider="SqlNetTiersProvider">

<providers>

<add name="SqlNetTiersProvider" type="NetTier.DAL.SqlClient.SqlNetTiersProvider, NetTier.DAL.SqlClient"

useStoredProcedure="true" connectionStringName="WareHouseConnectionString" applicationName="WareHouseWeb" providerInvariantName="System.Data.SqlClient"/>

</providers>

</netTiersService>

The type in NetTiersService starts with NetTier.DAL

The project explorer shows: NetTier.DAL  and NetTier.DAL.sqlClient folders.

The version of  template for NetTiers says

<%--
 * $Id: NetTiers.cst,v 1.19 2006/03/07 09:51:43 jroland Exp $
 * Last modified by $Author: goofsr $
 * Last modified at $Date: 2006-05-24 03:22:50 +0200 (mer., 24 mai 2006) $
 * $Revision: 188 $

 Description:
  NetTiers main templates. Internally call sub templates to genereate entities and dal. 
 
 Originally written By Ryan Hurdon
 ReWritten and maintained by John Roland since Oct. 2004
--%>

thanks

Nick