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
Why is ADO.NET serialization slower than ADO ?
What is DataRowCollection?
How to pass multiple tables in datasets simultaneously?
What is the difference between ADO and ADO.Net?
Is ado.net an orm?
What does executequery return?
What is csdl entity framework?
Describe ado.net object model in detail.
What is linq and entity framework?
What is an ADO.Net?
How to check if a datareader is closed or opened? IsClosed()
What is difference between sqldatareader and sqldataadapter?
Why edit is not possible in repeater?
What is row state?
How to identify the updated rows in a dataset?