| |
The BLToolkit.DbManager component is a data provider independent wrapper for ADO.NET.
It means that the DbManager does not use any specific data source classes such as SqlConnection,
SqlCommand, etc. It uses common classes and interfaces instead.
All data source specific logic is encapsulated in special classes called DataProviders.
The following table lists providers available with BLToolkit:
The first five providers are preregistered in the library and are ready to use.
The remaining providers need additional configuration as they require references to 3rd party components.
You can add a listed above or your own data provider into your project and register it as shown below:
AddDataProvider.cs
using System;
using NUnit.Framework;
using BLToolkit.Data;
using BLToolkit.Data.DataProvider;
namespace HowTo.Data.DataProvider
{
[TestFixture]
public class AddDataProvider
{
const string connectionString =
"Provider=ASEOLEDB;Data Source=server;Catalog=database;User Id=user;Password=pwd;";
[Test]
public void Test()
{
// 3rd party data provider registration.
//
DbManager.AddDataProvider(new SybaseAdoDataProvider());
// It can be configured by App.config.
// We use this way for the demo purpose only.
//
DbManager.AddConnectionString(
"SybaseAdo", // Provider name
"Default", // Configuration
connectionString); // Connection string
using (DbManager db = new DbManager("SybaseAdo", "Default"))
{
}
}
}
} |
Also a data provider can be registered by configuration file:
App.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add
key = "BLToolkit.DataProviders"
value = "BLToolkit.Data.DataProvider.OracleDataProvider, SomeAssembly"/>
</appSettings>
</configuration> |
Also you can use BLToolkit config section.
<?xml version="1.0"?>
<configuration>
<configSections>
<section name="bltoolkit" type="BLToolkit.Configuration.BLToolkitSection, BLToolkit.3"/>
</configSections>
<bltoolkit>
<dataProviders>
<add type="BLToolkit.Data.DataProvider.DB2DataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.FdpDataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.InformixDataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.MySqlDataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.OdpDataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.PostgreSQLDataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.SqlCeDataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.SQLiteDataProvider, UnitTests.Linq" />
<add type="BLToolkit.Data.DataProvider.SybaseDataProvider, UnitTests.Linq" />
</dataProviders>
</bltoolkit>
<connectionStrings>
<add name="Access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Data\BLToolkitData.mdb;Locale Identifier=1033;Jet OLEDB:Engine Type=5;Persist Security Info=True"/>
<add name="DB2" connectionString="Server=DBHost:50000;Database=BLTD;UID=TestUser;PWD=TestPassword;" providerName="IBM.Data.DB2"/>
<add name="Fdp" connectionString="DataSource=DBHost;Database=C:\Data\BLToolkitData.fb2;User Id=SYSDBA;Password=masterkey"/>
<add name="Informix" connectionString="Host=DBHost;Service=9090;Server=ol_ids_1150_1;Protocol=onsoctcp;Database=BLToolkitData;UID=sysmaster;PWD=TestPassword;" providerName="IBM.Data.Informix"/>
<add name="MySql" connectionString="Server=DBHost;Port=3306;Database=bltoolkitdata;Uid=root;Pwd=TestPassword;" providerName="MySql.Data.MySqlClient"/>
<add name="Oracle" connectionString="..." providerName="Oracle.DataAccess.Client"/>
<add name="PostgreSQL" connectionString="Server=DBHost;Port=5432;Database=BLToolkitData;User Id=postgres;Password=TestPassword;" providerName="Npgsql"/>
<add name="Sql2008" connectionString="Server=.;Database=BLToolkitData;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
<add name="Sql2005" connectionString="Server=DBHost;Database=BLToolkitData;User Id=TestUser;Password=TestPassword;" providerName="System.Data.SqlClient"/>
<add name="SqlCe" connectionString="Data Source=..\..\..\..\Data\BLToolkitData.sdf"/>
<add name="SQLite" connectionString="Data Source=..\..\..\..\Data\BLToolkitData.sqlite"/>
<add name="Sybase" connectionString="Data Source=DBHost;Port=5000;Database=BLToolkitData;Uid=sa" providerName="Sybase.Data.AseClient"/>
<add name="Northwind" connectionString="Data Source=.;Database=Northwind;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration> |
Here UnitTests.Linq assembly name should be replaces by your own.
| |