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 / alok saxena

Hey!

You are giving clue in your question.

First We have to use select case option, In each case we
have to use respective database connection,pwd,

Mind you must have to select approrpiate provider e.x. Sql
u must use System.Data.Sql

Wish u a good luck

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data relation in ado.net?

1079


How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

1042


Explain the difference in record set and dataset?

939


What is ado.net components?

966


Difference between sqlcommand and sqlcommandbuilder?

1135


Which is faster sqldataadapter and sqldatareader?

931


What are the ado.net connection pooling parameters?

983


Explain which name space is used to get assembly details?

970


What is ado.net tutorial?

952


Why do we serialize data?

951


How to bind the controls(best practice) comboboxes to the data in the dataset?

1052


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

870


How to generate a single aggregate?

980


What is the significance of CommandBehavior.CloseConnection ?

1171


How can we perform transactions in .net?

1061