iBATIS.NET 学习笔记(二)

在VS.NET2003中使用iBATIS.NET，添加 SqlMap.xsd, SqlMapConfig.xsd, providers.xsd三个文件到C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Packages\schemas\xml
这样在编辑iBATIS.NET配置文件时，有提醒出现，更易用。如下所示：

SqlMap.Config 配置文件示例，(此文件放在web.config同目录)


<?xml version="1.0" encoding="utf-8"?> 
<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >

  <!-- Optional -->
  <properties resource="properties.config"/>

  <settings>
    <setting useStatementNamespaces="false"/>
    <setting cacheModelsEnabled="true"/>
    <setting validateSqlMap="false"/>
  </settings>

  <!-- Not required if providers.config is located in default location -->
  <providers embedded="resources.providers.config, IBatisNet.Test"/>

  <database>
    <provider name="sqlServer1.1"/>
    <dataSource name="NPetshop" 
                connectionString="user id=${username};
                password=${password};
                data source=${datasource};
                database=${database};"/>
  </database>

  <alias>
    <typeAlias alias="Account" type="IBatisNet.Test.Domain.Account, IBatisNet.Test"/>
    <typeAlias alias="YesNoBool"
         type="IBatisNet.Test.Domain.YesNoBoolTypeHandlerCallback, IBatisNet.Test"/>
  </alias>

  <typeHandlers>
    <typeHandler type="bool" dbType="Varchar" callback="YesNoBool"/>
  </typeHandlers>

  <sqlMaps>
    <sqlMap resource="${root}Maps/Account.xml"/>
    <sqlMap resource="${root}Maps/Category.xml"/>
    <sqlMap resource="${root}Maps/Product.xml"/>
  </sqlMaps> 
</sqlMapConfig>



iBATIS.NET提供了多种访问数据库的provider，如下所示：
sqlServer1.0 - Microsoft SQL Server 7.0/2000 provider available with .NET Framework 1.0 sqlServer1.1 -Microsoft SQL Server 7.0/2000 provider available with .NET Framework 1.1 OleDb1.1 - OleDb provider available with .NET Framework 1.1 Odbc1.1 - Odbc provider available with .NET Framework 1.1 oracle9.2 - Oracle provider V9.2.0.401 oracle10.1 - Oracle provider V10.1.0.301 oracleClient1.0 - MS Oracle provider V1.0.5 available with .NET Framework 1.1 ByteFx - ByteFx MySQL provider V0.7.6.15073 MySql - MySQL provider V1.0.4.20163 SQLite3 - SQLite.NET provider V0.21.1869.3794 Firebird1.7 - Firebird SQL .NET provider V1.7.0.33200 PostgreSql0.7 - Npgsql provider V0.7.0.0 iDb2.10 - IBM DB2 iSeries provider V10.0.0.0

转载于:https://www.cnblogs.com/yknb/archive/2006/07/18/454100.html