Type of database connection in ADO.NET

SQL Connection
This object connects to the SQL Server.

Oracle Connection
This object is used to connect oracle database.

Oledb connection
This object is used to connect MS Access or MySQL(third party database).

Apart from these connections, ADO.NET also allows access to XML files using Dataset object's ReadXML and WriteXML method