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 the advantage of ado.net?
What is commandbuilder in ado.net?
What are the types of databinding?
What is difference between ado.net and asp net?
What is the use of SqlCommandBuilder?
What is the purpose of using adodb?
Compare Data Reader & Dataset in ado.net?
Which object is used to add relationship between two Datatables?
What is serialization and de-serialization in .net?
What are the different ado.net namespaces?
How to pass multiple tables in datasets simultaneously?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
Explain how to create dynamic gridview?
What is the difference between sqlcommand and sqldataadapter?
What is dataset object? Explain the various objects in dataset.