Developer Workstation Installation

Configure the Providers (SQL Provider)

By default both SQL and NAV providers are configured in the 'web.config' files of the Starter Site and backoffice. Therefore the configuration of the providers for the NAV Connector must be deleted.

Configuration of providers for users of Sana Commerce - SQL Provider is shown below:

• Open the 'web.config' file of the Sana Commerce Starter Site project in VS2008
  (do the same for the 'web.config' file of the 'Sana.Commerce.BackOffice' project in VS2008);
• Locate the <modules> configuration section and delete the configuration of the providers for the NAV Connector or just copy the code below and replace the <modules> section in the 'web.config' files:

<modules>
        <catalog defaultProvider="SanaCommerceSqlCatalogProvider">
          <providers>
            <clear />
           <add name="SanaCommerceSqlCatalogProvider" type="Sana.Commerce.Customization.Catalog.DatabaseExtendedCatalogProvider, Sana.Commerce.Sdk, Culture=neutral" description="CatalogProvider which retrieves catalog information from Sql server" serviceConnection="localSqlServer" />
          </providers>
        </catalog>
        <customer defaultProvider="SanaCommerceSqlCustomerProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlCustomerProvider" type="Sana.Commerce.Customization.Customer.DatabaseExtendedCustomerProvider, Sana.Commerce.Sdk, Culture=neutral" description="CustomerProvider which retrieves catalog information from Sql server" serviceConnection="localSqlServer" />
          </providers>
        </customer>
        <order defaultProvider="SanaCommerceSqlOrderProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlOrderProvider" type="Sana.Commerce.Customization.Order.DatabaseExtendedOrderProvider, Sana.Commerce.Sdk, Culture=neutral" description="OrderProvider which retrieves catalog information from Sql server" serviceConnection="LocalSqlServer" />
          </providers>
        </order>
        <shop defaultProvider="SanaSqlShopProvider">
          <providers>
            <clear />
            <add name="SanaSqlShopProvider" type="Sana.Commerce.Customization.Shop.DatabaseExtendedShopProvider, Sana.Commerce.Sdk, Culture=neutral" description="ShopProvider which retrieves shop information (baskets, ect) from SQL database" serviceConnection="LocalSqlServer" />
          </providers>
        </shop>
        <common defaultProvider="SanaCommerceSqlCommonProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlCommonProvider" type="Sana.Commerce.Customization.Common.DatabaseExtendedCommonProvider, Sana.Commerce.Sdk, Culture=neutral" description="CommonProvider which retrieves catalog information from Sql server" serviceConnection="localSqlServer" />
          </providers>
        </common>
        <content defaultProvider="SanaSqlContentProvider">
          <providers>
            <clear />
            <add name="SanaSqlContentProvider" type="Sana.Commerce.Customization.Content.LinqContentProvider, Sana.Commerce.Sdk, Culture=neutral" description="Content provider which retrives content information(content pages, product descriptions) from SQL DB" serviceConnection="LocalSqlServer" />
          </providers>
        </content>
</modules>