MyBatis.Net入门之指定配置文件位置及多类型数据库支持（二）-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_36036735/article/details/90606117

本文档介绍了如何在MyBatis.Net中指定配置文件的位置，并演示了如何在项目中实现对多种数据库的支持，包括配置文件的统一管理、配置类的创建以及在Global.asax中的初始化设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1，将配置文件统一修改至Configs文件夹
2，在App_Start文件夹中，新增配置类

 namespace MyBatisNetTest.App_Start
 {
   
     public class IBatisConfig
     {
   
         public static ISqlMapper GetInstance {
    get; private set; }
         public static void Register()
         {
   
             DomSqlMapBuilder builder = new DomSqlMapBuilder();
             GetInstance = builder.Configure(ConfigurationSettings.AppSettings["rootPath"] + "Configs\\SqlMap.config");
         }
     }
 }

3，在Global.asax中，启动配置

namespace MyBatisNetTest
{
   
    public class MvcApplication : HttpApplication
    {
   
        protected void Application_Start()
        {
   
            AreaRegistration.RegisterAllAreas();
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);
            IBatisConfig.Register();//增加启动项配置
        }
    }
}

4，其它数据支持

<?xml version="1.0" encoding="utf-8"?>
<providers
xmlns="http://ibatis.apache.org/providers"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <clear/>
  <provider
   name="sqlServer1.0"
   description="Microsoft SQL Server 7.0/2000, provider V1.0.3300.0 in framework .NET V1.0"
   enabled="false"
   assemblyName="System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.SqlClient.SqlConnection"
   commandClass="System.Data.SqlClient.SqlCommand"
   parameterClass="System.Data.SqlClient.SqlParameter"
   parameterDbTypeClass="System.Data.SqlDbType"
   parameterDbTypeProperty="SqlDbType"
   dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
   commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
   usePositionalParameters="false"
   useParameterPrefixInSql="true"
   useParameterPrefixInParameter="true"
   parameterPrefix="@"/>
  <provider
   name="sqlServer1.1"
    description="Microsoft SQL Server 7.0/2000, provider V1.0.5000.0 in framework .NET V1.1"
    enabled="false"
    assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" connectionClass="System.Data.SqlClient.SqlConnection"
    commandClass="System.Data.SqlClient.SqlCommand"
    parameterClass="System.Data.SqlClient.SqlParameter"
    parameterDbTypeClass="System.Data.SqlDbType"
    parameterDbTypeProperty="SqlDbType"
    dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
    commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
    usePositionalParameters="false"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix="@"/>
  <provider
     name="sqlServer2.0"
     enabled="false"
     description="Microsoft SQL Server 2005, provider V2.0.50215.0 in framework .NET V2.0"
     assemblyName="System.Data, Version=2.0.50215.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
     connectionClass="System.Data.SqlClient.SqlConnection"
     commandClass=