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?

Answers were Sorted based on User's Feedback



If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle mea..

Answer / alok saxena

Hey!

You are giving clue in your question.

First We have to use select case option, In each case we
have to use respective database connection,pwd,

Mind you must have to select approrpiate provider e.x. Sql
u must use System.Data.Sql

Wish u a good luck

Is This Answer Correct ?    3 Yes 1 No

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle mea..

Answer / ganesh

Create appropriate provider at run time(use factory
patterns) based on some configurations setting (probably a
XML file).This will allow user to decide providers
dynamicallly and enable connecting to whatever database he
wants

Is This Answer Correct ?    2 Yes 1 No

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle mea..

Answer / koteswara rao.chava

SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
Get_Conn("TSQL");
//Get_Conn("ACCESS");
//Get_Conn("ORACLE");


}
protected void Get_Conn(string con_condition_Str)
{
switch (con_condition_Str)
{
case ("ACCESS"):
//SET CON = access constring
break;
case ("TSQL"):
// SET CON = SQL SERVER constring
break;
case ("ORACLE"):
// SET CON = ORACLE constring
break;
}
}

Is This Answer Correct ?    0 Yes 1 No

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle mea..

Answer / 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

More ADO.NET Interview Questions

Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,


What is the role of the dataset object in ado.net?

0 Answers  


How can you implement sub data grid in a master datagrid?

1 Answers  


What are the ado.net objects?

0 Answers  


What are the key events of sqlconnection class?

0 Answers  


What are the advantages and drawbacks of using ado.net?

0 Answers  


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

0 Answers   Infosys, Wipro,


Explain ODP.net

0 Answers  


List all the steps in order, to access a database through ado.net?

0 Answers  


What are the several execute methods of ado.net?

0 Answers  


What are the advantages of using datalist?

0 Answers  


What is the difference in an abstract class and an interface?

0 Answers  


Categories