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 data access pattern?
What are all components of ADO.Net data provider?
What is connection in ado.net?
What are the different methods available under the sqlcommand class to access the data?
What is an example of ordinal data?
What are two important objects of ADO.Net?
How to identify the controls which can be used for binding data?
What is the default Timeout for SqlCommand.CommandTimeout property?
What is executequery?
What are dataproviders?
Why do we need ado.net?
What is difference between datareader and dataadapter?
Which database is the ado.net?
What is sqldatareader in ado.net?
Explain executenonquery?