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
- 9726 Views
- Honeywell, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the 3 major types of connection objects in ado.net?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What are the data providers used in ado.net
What is the difference between executequery and executenonquery?
Explain the namespaces in which .net has the data functionality class.
What is a dataview?
Explain how do you connect to sql server database without using sqlclient?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is difference between datareader and dataadapter?
Define table relations?
Define partial class?
Which is faster sqldataadapter and sqldatareader?
How do you update a dataset in ado.net and how do you update database through dataset?
Which architecture does Datasets follow?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
