|
0
|
1 <% order # 20 %>
|
|
|
2 <p class="j">
|
|
|
3 The <b>BLToolkit.DbManager</b> component is a data provider independent wrapper for ADO.NET.
|
|
|
4 It means that the <b>DbManager</b> does not use any specific data source classes such as <b>SqlConnection</b>,
|
|
|
5 <b>SqlCommand</b>, etc. It uses common classes and interfaces instead.
|
|
|
6 All data source specific logic is encapsulated in special classes called <b>DataProviders</b>.
|
|
|
7 </p>
|
|
|
8 <p class="j">
|
|
|
9 The following table lists providers available with <b>BLToolkit</b>:
|
|
|
10 </p>
|
|
|
11
|
|
|
12 <table class='data'>
|
|
|
13 <tr><th>Class</th> <th>Provider Name</th><th>Namespace</th> <th>Vendor</th></tr>
|
|
|
14 <tr><td><a href='..\..\..\Source\Data\DataProvider\AccessDataProvider.cs.htm' >AccessDataProvider</a></td> <td>Access</td> <td>System.Data.OleDb</td> <td>Microsoft</td></tr>
|
|
|
15 <tr><td><a href='..\..\..\Source\Data\DataProvider\OdbcDataProvider.cs.htm' >OdbcDataProvider</a></td> <td>Odbc</td> <td>System.Data.Odbc</td> <td>Microsoft</td></tr>
|
|
|
16 <tr><td><a href='..\..\..\Source\Data\DataProvider\OleDbDataProvider.cs.htm' >OleDbDataProvider</a></td> <td>OleDb</td> <td>System.Data.OleDb</td> <td>Microsoft</td></tr>
|
|
|
17 <tr><td><a href='..\..\..\Source\Data\DataProvider\OracleDataProvider.cs.htm' >OracleDataProvider</a></td> <td>Oracle</td> <td>System.Data.OracleClient</td> <td>Microsoft</td></tr>
|
|
|
18 <tr><td><a href='..\..\..\Source\Data\DataProvider\SqlDataProvider.cs.htm' >SqlDataProvider</a></td> <td>Sql</td> <td>System.Data.SqlClient</td> <td>Microsoft</td></tr>
|
|
|
19 <tr><td colspan='4' class='hr' style='padding:0'><img width='1' height='1' alt=''/></td></tr>
|
|
|
20 <tr><td><a href='..\..\..\Source\Data\DataProvider\DB2DataProvider.cs.htm' >DB2DataProvider</a></td> <td>DB2</td> <td>IBM.Data.DB2</td> <td><a href='http://www.ibm.com/software/data/db2/ad/dotnet.html'>IBM</a></td></tr>
|
|
|
21 <tr><td><a href='..\..\..\Source\Data\DataProvider\FdpDataProvider.cs.htm' >FdpDataProvider</a></td> <td>Fdp</td> <td>FirebirdSql.Data.FirebirdClient</td><td><a href='http://www.firebirdsql.org/'>Firebird</a></td></tr>
|
|
|
22 <tr><td><a href='..\..\..\Source\Data\DataProvider\InformixDataProvider.cs.htm' >InformixDataProvider</a></td> <td>Informix</td> <td>IBM.Data.Informix</td> <td><a href='http://www.informix.com'>IBM</a></td></tr>
|
|
|
23 <tr><td><a href='..\..\..\Source\Data\DataProvider\MySqlDataProvider.cs.htm' >MySqlDataProvider</a></td> <td>MySql</td> <td>MySql.Data.MySqlClient</td> <td><a href='http://www.mysql.com/'>Sun Microsystems</a></td></tr>
<tr><td><a href='..\..\..\Source\Data\DataProvider\OdpDataProvider.cs.htm' >OdpDataProvider</a></td> <td>ODP</td> <td>Oracle.DataAccess.Client</td> <td><a href='http://www.oracle.com/technology/tech/windows/odpnet/index.html'>Oracle</a></td></tr>
|
|
|
24 <tr><td><a href='..\..\..\Source\Data\DataProvider\SqlCeDataProvider.cs.htm' >SqlCeDataProvider</a></td> <td>SqlCe</td> <td>System.Data.SqlServerCe</td> <td><a href='http://www.microsoft.com/sql/editions/compact/default.mspx'>Microsoft</a></td></tr>
|
|
|
25 <tr><td><a href='..\..\..\Source\Data\DataProvider\SQLiteDataProvider.cs.htm' >SQLiteDataProvider</a></td> <td>SQLite</td> <td>System.Data.SQLite</td> <td><a href='http://sqlite.phxsoftware.com/'>SQLite.org</a></td></tr>
|
|
|
26 <tr><td><a href='..\..\..\Source\Data\DataProvider\SybaseAdoDataProvider.cs.htm'>SybaseAdoDataProvider</a></td><td>SybaseAdo</td><td>System.Data.OleDb</td> <td>Support for <a href='http://www.datadirect.com/products/ado/index.ssp'>DataDirect Sybase ADO Provider</a></td></tr>
|
|
|
27 <tr><td><a href='..\..\..\Source\Data\DataProvider\SybaseDataProvider.cs.htm' >SybaseDataProvider</a></td> <td>Sybase</td> <td>Sybase.Data.AseClient</td> <td><a href='http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit'>Sybase</a></td></tr>
|
|
|
28 <tr><td colspan='4' class='hr' style='padding:0'><img width='1' height='1' alt=''/></td></tr>
|
|
|
29 </table>
|
|
|
30
|
|
|
31 <p class="j">
|
|
|
32 The first five providers are preregistered in the library and are ready to use.
|
|
|
33 The remaining providers need additional configuration as they require references to 3rd party components.
|
|
|
34 </p>
|
|
|
35
|
|
|
36 <p class="j">
|
|
|
37 You can add a listed above or your own data provider into your project and register it as shown below:
|
|
|
38 </p>
|
|
|
39
|
|
|
40 AddDataProvider.cs
|
|
|
41 <% ..\..\..\HowTo\Data\DataProvider\AddDataProvider.cs %>
|
|
|
42
|
|
|
43 <p class="j">
|
|
|
44 Also a data provider can be registered by configuration file:
|
|
|
45 </p>
|
|
|
46
|
|
|
47 App.config
|
|
|
48 <% Doc\Data\DataProvider\App.config %>
|
|
|
49
|
|
|
50 Also you can use BLToolkit config section.
|
|
|
51
|
|
|
52 <% ..\..\..\UnitTests\Linq\App.config %>
|
|
|
53
|
|
|
54 Here <i>UnitTests.Linq</i> assembly name should be replaces by your own.
|
