C# ADO.NET Connection

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.

csharp-connection

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# SQL Server Connection

C# OLEDB Connection

C# ODBC Connection






Related Topics
  1. C# SQL Server Connection
  2. C# OLEDB Connection
  3. C# ODBC Connection
  4. C# ADO.NET Command
  5. C# ADO.NET SqlCommand - ExecuteNonQuery
  6. C# ADO.NET OleDbCommand - ExecuteNonQuery
  7. C# ADO.NET SqlCommand - ExecuteScalar
  8. C# ADO.NET OleDbCommand - ExecuteScalar
  9. C# ADO.NET SqlCommand - ExecuteReader
  10. C# ADO.NET OleDbCommand - ExecuteReader
  11. C# ADO.NET DataReader
  12. C# ADO.NET SqlDataReader
  13. C# ADO.NET OleDbDataReader
  14. C# Multiple Result Sets
  15. C# Table Schema from SqlDataReader
  16. C# Table Schema from OleDbDataReader
  17. C# ADO.NET DataAdapter
  18. C# ADO.NET SqlDataAdapter
  19. C# ADO.NET OleDbDataAdapter
  20. C# ExecuteReader and ExecuteNonQuery
  21. System.Data.SqlClient.SqlException: Login failed for user


Related Topics
  1. Stored Procedures in C#
  2. C# Stored Procedure with Parameter