1、动态创建一个配置文件,保存
2、读取配置文件
3、读取数据库配置文件链接字符串,创建EL的数据库实例
//保存配置文件
string path = System.AppDomain.CurrentDomain.BaseDirectory;
//生成配置文件
XmlTextWriter writer = new XmlTextWriter(Path.Combine(path,"DataConnect.config"), Encoding.UTF8);
// start writing!
writer.WriteStartDocument();
writer.WriteStartElement("configuration");//configuration节点
writer.WriteStartElement("connectionStrings");//connectionStrings节点
//*--数据库连接字符串 开始*/
writer.WriteStartElement("add");
writer.WriteAttributeString("name", "dbConnection1");
writer.WriteAttributeString("connectionString", "Data Source=.;Initial Catalog=cppei_Platform;Integrated Security=True");
writer.WriteAttributeString("providerName", "System.Data.SqlClient");
writer.WriteEndElement();
//*--数据库连接字符串 结束*/
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Close();
//读取新建的配置文件
FileConfigurationSource dbDataSource = new FileConfigurationSource("DataConnect.config");
DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory(dbDataSource);
//创建实例
Database db = databaseProviderFactory.Create("dbConnection1");
enterprise 动态同时加载2个数据库
最新推荐文章于 2022-01-13 10:53:13 发布