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 stored procedure used in ado.net?

1197


What is the difference between Data adaptor and Data set?

1090


What are different layers of ADO.Net?

1144


What is ado.net explain with diagram?

1018


Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1179


What is an orm, and why would you use one instead of plain old ado.net?

1096


What is DataReader Object?

1091


How is it possible to get 2 tables of data at a time by using data reader?

987


What are the data access namespaces in .NET?

1256


What is ado.net components?

1001


Explain executenonquery?

1214


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

1076


What are advantages of microsoft-provided data provider classes in ado.net?

1035


What is isolation?

1071


Is ado.net an orm?

1001