Interested to Buy Any Domain ? << Click Here >> for more details...
If we want to connect to many databases in dataaccess layer
such as MSAccess,Sql server,oracle means not to a particular
database depends on condition we have to connect to
appropriate database in this scenario if we without changing
code Ho wdo you handle this situation?
- 4 Answers
- 9721 Views
- Honeywell, I also Faced
- E-Mail Answers
Answer Posted / suresh jayaraman
<configuration>
<appSettings>
<add key="AccessDatabase" value="Data
Source=servername;Initial
Catalog=databasename;uid=userid;pwd=password"/>
<add key="SqlServerDatabase" value="Data
Source=servername;Initial
Catalog=databasename;uid=userid;pwd=password"/>
</appSettings>
</configuration>
and use this Key name where it is needed
If you need SqlServer DataBase
using System.Data.SqlClient;
in DataAcess Layer
public SqlConnection Connection()
{
try
{
con = new SqlConnection
(ConfigurationManager.AppSettings
["SqlServerDatabase"].ToString().Trim());
return con;
}
catch (Exception exp)
{
throw exp;
}
}
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is ole db query?
What is data relation?
Does dapper use ado.net?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What are the parameters that control most of connection pooling behaviours?
What are the ado.net connection pooling parameters?
What does ado stand for?
Explain the two fundamental objects in ado.net?
What are good ado.net object to replace to ado recordset object.
What is difference between sqldatareader and sqldataadapter?
What is data reader in ado.net?
How can we perform transactions in .net?
How can we load multiple tables in to dataset?
What is oledb connection?
How can we load multiple tables in a dataset?
