如何在单个asp.net项目中使用多个数据库？ [英] How to use multiple databases in single asp.net project?

问题描述

如何在单个asp.net项目中使用多个数据库？

假设我有两个名为A&的数据库B.现在我想在我的一个项目中使用它们。有可能吗？

我可以使用一个带有以下连接字符串的数据库



< connectionstrings>

< add name =ConStrconnectionstring =Password = password; Persist Security Info = True; User ID = userid; Initial Catalog = databasename; Data Source = database-servernameprovidername =System.Data.SqlClient>





我可以在一个asp.net项目中使用多个.config文件吗？或者什么是多个数据库的连接字符串。



提前谢谢

How to use multiple databases in single asp.net project?
Suppose I have two database named A & B. Now I want to use both of them in my one project. Is it possible?
I can use one database with the following connection string

<connectionstrings>
<add name="ConStr" connectionstring="Password=password;Persist Security Info=True;User ID=userid;Initial Catalog=databasename;Data Source=database-servername" providername="System.Data.SqlClient">


Can I use multiple .config file in a one asp.net project? Or what will be the connection string for multiple database.

Thanks in advance

推荐答案

你可以拥有多少你想要的。



在我的项目中我的设置，您可以继续添加连接字符串。它所做的就是将多个ConnectionString项添加到设置集合中，如下所示;



<？xml version =1.0encoding =utf-8？ >

< configuration>

< configSections>

< / configSections>

< connectionStrings> ;

< add name =WindowsApplication1.My.MySettings.SettingconnectionString =asdfasfasdfas/>

< add name =WindowsApplication1.My.MySettings .Setting1connectionString =asvsdvsadvasdv\svsv\cvv/>

< / connectionStrings>

< startup>

< supportedRuntime version =v2.0.50727/>

< / startup>

< / configuration>

You can have as many as you want.

In the My Project | My Settings, you can keep adding connection strings in there. All it will do is add multiple ConnectionString items to the settings collection just like below;

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="WindowsApplication1.My.MySettings.Setting" connectionString="asdfasfasdfas" />
<add name="WindowsApplication1.My.MySettings.Setting1" connectionString="asvsdvsadvasdv\svsv\cvv" />
</connectionStrings>
<startup>
<supportedRuntime version="v2.0.50727" />
</startup>
</configuration>

这篇关于如何在单个asp.net项目中使用多个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！