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
Does executenonquery return a value?
What is the significance of CommandBehavior.CloseConnection ?
Describe the disconnected architecture of ADO.NET’s data access model.
What is the difference between oledb sql server and oledbdotnet provider?
What is connection string?
What is two way data binding android?
How can we save all data from dataset?
Name which operations can you not perform on an ado.net dataset?
Which property is used to check whether a DataReader is closed or opened?
What are the benefits of ADO.NET?
What does executequery return?
What is data control techniques?
How can you add or remove rows from the datatable object of dataset?
What is the difference between dataset and datatable?
Describe briefly an ADO.NET Dataset ?