How would u connect to database using .NET?
Answer Posted / vivek
using Connection object
SqlConnectin cn=new SqlConnection();
from .net we can connect to any backend with middlleware
and direct connections.
middleware means ODBC,OleDb,ISAM etc.
we can directly connect to Sqlserver and Oracle
we can connect to sql server in 4 ways
1)direct connection
2)ODBC way
3)OleDb way
4)Express way
for oracle we can connect in 3 ways.
1)direct connection
2)ODBC way
3)OleDb way
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a datareader and a dataset?
What are the various methods provided by the DataSet object to generate XML?
What is ado.net and its architecture?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is difference between entity framework and ado.net?
What are the main differences between classic ado and ado.net?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
Explain all the classes those are used for database connections between sql server and asp.net?
Where is adodb dll located?
What is the difference between SqlCommand and SqlCommandBuilder?
Is it possible to load multiple tables in a Dataset?
Define different execute methods of ADO.NET command object ?
describe the dataset object in ado.net.
What do you know about ado.net's objects?