Asp.net MVC 3中的多数据库服务器连接 [英] Multi DataBase server connection in Asp.net MVC 3

问题描述

我在方法内部使用的是"Bootstrapper"类:

 私有 静态  void  ConfigureNHibernate()
        {
            NHibernate.Cfg.Configuration cfg = 新 NHibernate.Cfg.Configuration().Configure();
            cfg.Properties [" ] = ConfigurationManager.ConnectionStrings [  DefaultConnectionString"].ConnectionString;
           
        } 

并在Web.config中:

 <  配置 > ; 
<  配置节 > 
    <  部分    ="   dataConfiguration" 类型   Microsoft.实践.EnterpriseLibrary.Data.Configuration.DatabaseSettings，Microsoft.Practices.EnterpriseLibrary.Data" / > 
  <  /configsections  > 
  <  连接字符串 > 
    <  添加    ="   sql" 连接字符串  数据源= 192.168.3.250;初始目录= MNTPayroll;用户ID = sa;密码= hbd123 @ 2"  providername   ="    / > 
  <  /connectionstrings  > 
  <  数据配置    ="   sql" / 将NHibernate与多个数据库一起使用 [private static void ConfigureNHibernate()
        {
            NHibernate.Cfg.Configuration cfg = new NHibernate.Cfg.Configuration().Configure();
            cfg.Properties["connection.connection_string"] = ConfigurationManager.ConnectionStrings["DefaultConnectionString"].ConnectionString;
           
        }

And in Web.config:

<configuration>
<configsections>
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data" />
  </configsections>
  <connectionstrings>   
    <add name="sql" connectionstring="Data Source=192.168.3.250;Initial Catalog=MNTPayroll;User ID=sa;Password=hbd123@2" providername="System.Data.SqlClient" />    
  </connectionstrings>
  <dataconfiguration defaultdatabase="sql" />

I want to use multi-DataBase server. how can I do this and how can I use the second or third Database connection string to my application when to access...

解决方案

What about googling a little bit: Using NHibernate with Multiple Databases[^]

这篇关于Asp.net MVC 3中的多数据库服务器连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！