組件依 providerName 判斷資料庫類型,載入對應方言與參數格式。v1.5 修正數個 Bug 並改善 Oracle 支援。
| 資料庫 | providerName 可用值 |
|---|---|
| SQL Server 2000 | System.Data.SqlClient Hxj.Data.SqlServer |
| SQL Server 2005/2008/2012+ | Hxj.Data.SqlServer9 |
| MS Access | Hxj.Data.MsAccess |
| SQLite | System.Data.SQLite Hxj.Data.Sqlite |
| Oracle | System.Data.OracleClient Hxj.Data.Oracle |
| MySQL (v1.7+) | Hxj.Data.MySql |
<connectionStrings>
<add name="Sql2005" connectionString="Data Source=.;Initial Catalog=Northwind;Integrated Security=True"
providerName="Hxj.Data.SqlServer9" />
<add name="OracleDb" connectionString="Data Source=ORCL;User Id=scott;Password=tiger;"
providerName="Hxj.Data.Oracle" />
<add name="MySqlDb" connectionString="server=localhost;uid=root;pwd=123;database=test;"
providerName="Hxj.Data.MySql" />
<add name="SqliteDb" connectionString="Data Source=|DataDirectory|\app.db;"
providerName="System.Data.SQLite" />
</connectionStrings>
var sqlDb = new DbSession("Sql2005");
var oracleDb = new DbSession("OracleDb");
var mySqlDb = new DbSession("MySqlDb");
var sqliteDb = new DbSession("SqliteDb");
核心 API(From/Insert/Update/Delete/FromSql/FromProc)完全一致,切換資料庫零學習成本。