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?
Answer Posted / 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 |
Post New Answer View All Answers
What is data relation in ado.net?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
Explain the difference in record set and dataset?
What is ado.net components?
Difference between sqlcommand and sqlcommandbuilder?
Which is faster sqldataadapter and sqldatareader?
What are the ado.net connection pooling parameters?
Explain which name space is used to get assembly details?
What is ado.net tutorial?
Why do we serialize data?
How to bind the controls(best practice) comboboxes to the data in the dataset?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
How to generate a single aggregate?
What is the significance of CommandBehavior.CloseConnection ?
How can we perform transactions in .net?