NET Framework Data Providers

MSDN article NET Framework Data Providers  helps us to understand several .NET Framework Data Providers  and how to choose a proper Data Provider between

.NET Framework Data Provider for SQL Server
.NET Framework Data Provider for OLD DB
.NET Framework Data Provider for ODBC
.NET Framework Data Provider for Oracle