System.Data.SQLClient
Can only be used for connecting to SQL Server 2000 and later. But you will get optimal performance when connecting to those databases.
System.Data.OledbClient
Can be used to connected to SQL 6.5
OLEDBClient gives you ability to connect to other database like ORALCE or Access. But for working with SQL Server you will get better performance using SQLClient.
Note: For connecting to ORALCE Microsoft also has ORACLEClient.
System.Data.ODBCClient- provides connection to legacy databases ( e.g. MS Access 97) using ODBC drivers.
Can only be used for connecting to SQL Server 2000 and later. But you will get optimal performance when connecting to those databases.
System.Data.OledbClient
Can be used to connected to SQL 6.5
OLEDBClient gives you ability to connect to other database like ORALCE or Access. But for working with SQL Server you will get better performance using SQLClient.
Note: For connecting to ORALCE Microsoft also has ORACLEClient.
System.Data.ODBCClient- provides connection to legacy databases ( e.g. MS Access 97) using ODBC drivers.
