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 are the benefits of using ado.net?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is the default provider in ado.net?
What are the ado.net objects?
What is disconnected data?
What is Serialization in .NET? what are the types of Serialization?
What is disconnected architecture in ado.net?
Which object needs to be closed?
How to find the given query is optimised one or not?
What is dataset and datatable in ado.net?
What is serialization and de-serialization in .net?
Explain the differences between oledb sql server, oledbdotnet provider?
What connected data?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
How to connect and retrieve data from database using dataset