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

Does executenonquery return a value?

898


What is the significance of CommandBehavior.CloseConnection ?

1115


Describe the disconnected architecture of ADO.NET’s data access model.

1009


What is the difference between oledb sql server and oledbdotnet provider?

974


What is connection string?

964


What is two way data binding android?

939


How can we save all data from dataset?

952


Name which operations can you not perform on an ado.net dataset?

945


Which property is used to check whether a DataReader is closed or opened?

1007


What are the benefits of ADO.NET?

1079


What does executequery return?

919


What is data control techniques?

906


How can you add or remove rows from the datatable object of dataset?

982


What is the difference between dataset and datatable?

955


Describe briefly an ADO.NET Dataset ?

1022