The Connection Object is a part of ADO.NET Data Provider and it is a unique session with the Data Source. The Connection Object is Handling the part of physical communication between the C# application and the Data Source.
The Connection Object connect to the specified Data Source and open a connection between the C# application and the Data Source, depends on the parameter specified in the Connection String . When the connection is established , SQL Commands will execute with the help of the Connection Object and retrieve or manipulate data in the Data Source.
Once the Database activity is over , Connection should be closed and release the Data Source resources .
In C# the type of the Connection is depend on which Data Source system you are working with. The following are the commonly used Connections from the C# applications.
- C# ADO.NET data Providers - Related Contents
- C# SQl Server Connection
- C# OLEDB Connection
- C# ODBC Connection
- C# ADO.NET Command
- C# ADO.NET SqlCommand - ExecuteNonQuery
- C# ADO.NET OleDbCommand - ExecuteNonQuery
- C# ADO.NET SqlCommand - ExecuteScalar
- C# ADO.NET OleDbCommand - ExecuteScalar
- C# ADO.NET SqlCommand - ExecuteReader
- C# ADO.NET OleDbCommand - ExecuteReader
- C# ADO.NET DataReader
- C# ADO.NET SqlDataReader
- C# ADO.NET OleDbDataReader
- C# Multiple Result Sets
- C# Table Schema from SqlDataReader
- C# Table Schema from OleDbDataReader
- C# ADO.NET DataAdapter
- C# ADO.NET SqlDataAdapter
- C# ADO.NET OleDbDataAdapter
- C# ExecuteReader and ExecuteNonQuery
- Sponsored Program
- C# ADO.NET data Providers - Related Programs
- Stored Procedures in C#
- C# Stored Procedure with Parameter