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
What is a dataview?
What is the difference between sqldatareader and sqldataadapter?
Is ado.net an orm?
What is a non query?
What is an example of ordinal data?
What is the use of adodc?
What is the difference in an abstract class and an interface?
What is meant by executenonquery?
How can we serialize the dataset object?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is connection pooling and what is the maximum pool size in ado.net connection string?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
Define bubbled event?
How can we add/remove row's in "datatable" object of "dataset"?
What is a control toolbox?