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


Please Help Members By Posting Answers For Below Questions

Describe ado.net object model in detail.

529


What provider ado.net use by default? Explain the role of data provider in ado.net?

528


How to create dynamic gridview?

588


Why is stored procedure used in ado.net?

549


What are the usages of the command object in ado.net?

550






Explain why edit is not possible in repeater?

538


What are the uses of Stored Procedure?

553


What is the usage of the dataset object in ado.net?

485


What DataReader class do in ADO.NET ?

582


What are the main differences between classic ado and ado.net?

519


What is a non query?

516


What is the difference between Dataset. clone and Dataset.copy?

557


Which is better entity framework or ado.net?

509


What is the difference between data reader and data adapter?

534


What is ole in excel?

517