How to configure a data provider

• Download and install a 3^rd party data provider.
• Add a reference to the provider assembly in your project.
• Add a corresponding C# file with a BLToolkit data provider implementation in your project. All providers are located in the Data\DataProvider folder of the BLToolkit project or in the same folder of the bltoolkit_bin archive if you use compiled version of the library.
• Register the data provider using one of the following method:
  

using System;

using NUnit.Framework;

using BLToolkit.Data;
using BLToolkit.Data.DataProvider;

namespace HowTo.Data.DataProvider
{
    [TestFixture]
    public class AddDataProvider
    {
        const string connectionString = 
            "Data Source=DBHost;Port=5000;Database=BLToolkitData;Uid=sa";

        [Test]
        public void Test()
        {
            // 3rd party data provider registration.
            //
            DbManager.AddDataProvider(new SybaseDataProvider());

            // It can be configured by App.config.
            // We use this way for the demo purpose only.
            //
            DbManager.AddConnectionString(
                "Sybase",          // Provider name
                "Sybase",          // Configuration
                connectionString); // Connection string

            using (var db = new DbManager("Sybase"))
            {
            }
        }
    }
}

<?xml version="1.0"?>
<configuration>
    <configSections>
        <section name="bltoolkit" type="BLToolkit.Configuration.BLToolkitSection, BLToolkit.3"/>
    </configSections>
    <bltoolkit>
        <dataProviders>
            <add type="BLToolkit.Data.DataProvider.SybaseDataProvider, MyProjectName" />
        </dataProviders>
    </bltoolkit>
    <connectionStrings>
        <add name="Sybase" connectionString="Data Source=DBHost;Port=5000;Database=BLToolkitData;Uid=sa" providerName="Sybase.Data.AseClient"/>
    </connectionStrings>
</configuration>