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


Please Help Members By Posting Answers For Below Questions

What is ole db and odbc?

685


What is execute reader in ado.net?

680


What is datatable in ado.net?

688


What is the role of data provider in ado.net?

731


What is ado.net explain with diagram?

699


Describe ado.net object model in detail.

740


What are different layers of ADO.Net?

783


Explain sqlconnection object?

742


Which is the best method to get two values from the database?

708


What are the core objects of ADO.NET?

771


What is ado or jdbc?

687


What is bubbled event can you please explain?

730


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

730


Explain the role of data provider in ado.net?

731


Does executenonquery return a value?

699