Share via


Connecting to Data in Visual Studio

Visual Studio provides tools to connect your application to data from many different sources, such as databases, Web services, and objects. Connections to data are created either programmatically (in code), as the result of dropping data objects onto a form or component designer, or through the completion of one of the data wizards. The following topics explain how to create connections to databases, Web services, and objects from your application.

In This Section

Reference

  • SqlConnection
    Represents a unique session to a SQL Server data source.

  • ConnectionString
    Represents the connection string used to connect to a SQL Server database.

  • OleDbConnection
    Represents a unique connection to a data source.

  • ConnectionString
    Represents the connection string used to open an OLE DB data source.

  • OdbcConnection
    Represents a unique connection to a data source created by using a connection string or ODBC data source name (DSN).

  • OdbcConnection.ConnectionString
    Represents the connection string used to connect to an ODBC data source.

  • OracleConnection
    Represents a unique connection to an Oracle database.

  • OracleConnection.ConnectionString
    Represents the connection string used to connect to an Oracle database.

  • ADO.NET
    Describes the ADO.NET classes, which expose data-access services to the .NET programmer.

  • System.Data
    Describes the ADO.NET classes, which expose data-access services to the .NET programmer.

  • System.Transactions
    The System.Transactions namespace contains classes that allow you to write your own transactional application and resource manager.