System.Data

Contains all the objects that are generic to ADO.NET and that do not belong to a specific data provider.

System.Data.OleDb.

Contains classes that give access to Microsoft SQL Server 6.5 and earlier. Also provides access to Oracle, sybase, Access etc

System.Data.SqlClient

Contains classes that give optimised access to Microsoft SQL Server 7.0 and later