Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Why is ADO.NET serialization slower than ADO ?

1043


What is DataRowCollection?

1102


How to pass multiple tables in datasets simultaneously?

1054


What is the difference between ADO and ADO.Net?

1076


Is ado.net an orm?

954


What does executequery return?

966


What is csdl entity framework?

1012


Describe ado.net object model in detail.

990


What is linq and entity framework?

997


What is an ADO.Net?

976


How to check if a datareader is closed or opened? IsClosed()

1023


What is difference between sqldatareader and sqldataadapter?

928


Why edit is not possible in repeater?

940


What is row state?

972


How to identify the updated rows in a dataset?

1013