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 serialization and de-serialization in .net? How can we serialize the dataset object?
What is ole db query?
What is a dataview?
Which control of the BindingNavigator returns the current position within the data source?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is ado.net code?
What is an ado?
What is ado.net objects?
What is an ado connection?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is a non query?
Which object of ado contains datarow datacolumn collection?
Can we load multiple tables in a dataset?
What is an example of ordinal data?
What are the benefits of using ado.net?