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
Describe ado.net object model in detail.
What you mean by filtering of data?
How to generate a single aggregate?
What is ado.net explain with diagram?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Which provider is used to connect ms access, oracle, etc…?
What does sqldatareader return?
What is ado connection?
How to maintain the relation between two tables in ADO.NET?
How can I retrieve two tables of data at a time by using data reader?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What is untyped dataset?
describe the dataset object in ado.net.
What is variable view?
What are the benefits of using ado.net?