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 are the parameters that control most of connection pooling behaviors?
What are two types of transaction supported by ado.net?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
Which object holds only data and does not interact with data source?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the current version of entity framework?
How do you update database through dataset?
What is a datareader object?
Which object needs to be closed?
Explain what are the steps to connect to a database?
What are disadvantages of microsoft-provided data provider classes in ado.net?
Explain the namespaces in which .net has the data functionality class.
Explain the difference in record set and dataset?
how we can fire event in databound coulm in datagfrid withot using button?
Describe the command object and its method.