Which DataAdapters are available for use with different Databases in ADO.NET?
ADO.NET makes these data adapters available for use with databases:
The OleDbDataAdapter object is suitable for use with any data source exposed by an OLE DB provider.
The SqlDataAdapter object is specific to SQL Server. Because it does not have to go through an OLE DB layer, it is faster than the OleDbDataAdapter. However, it can only be used with SQL Server 7.0 or later.
The OdbcDataAdapter object is optimized for accessing ODBC data sources.
The OracleDataAdapter object is optimized for accessing Oracle databases.