Datasheet

❑ System.Data.OleDb: Contains the objects used to communicate to databases via OLEDB.
OLEDB provides a common set of features to connect to multiple databases, such as Access,
DBase, and so on.
❑
System.Data.SqlClient: Provides the objects used to communicate with SQL Server.
For some of the objects there are two copies – one in the
OleDb namespace, and one in the SqlClient
namespace. For example, there are two Connection objects – OleDbConnection and SqlConnection.
Having two objects means they can be optimized for particular databases. Look at Figure 8-18 to see
how they relate to each other:
Figure 8-18
270
Chapter 8
57084_08.qxp 30/01/2004 8:03 PM Page 270