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 / ganesh
Create appropriate provider at run time(use factory
patterns) based on some configurations setting (probably a
XML file).This will allow user to decide providers
dynamicallly and enable connecting to whatever database he
wants
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain what are acid properties?
Which is the feature of ado.net?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is ado circle?
What does ado stand for in ado.net?
What is the difference between SqlCommand and SqlCommandBuilder?
What are dcl commands?
Which is better ole db or odbc?
What is ado recordset?
What is oledb connection?
What does sqldatareader return?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Does entity framework use ado.net?
Can we load multiple tables in a dataset?