How can you manage database connections in ADO.NET?

In ADO.NET, database connections are managed using the Connection object, such as

SqlConnection for SQL Server. The process involves: