This topic presents a brief description of the classes and components included in dotConnect for SQL Server. Click on the name of each component for more information.

Core ADO.NET Classes

Class	Description
SqlConnection	Establishes a connection to SQL Server and manages transactions.
SqlCommand	Executes SQL statements and stored procedures at SQL Server.
SqlDataReader	Exposes and reads a forward-only stream of data from SQL Server.
SqlDataAdapter	Populates a DataSet and resolves updates with SQL Server.
SqlTransaction	Starts, commits, or rolls back server transactions.
SqlParameter	Represents input, output, and return value parameters for commands.
SqlException	Represents an error encountered at SQL Server. For an error encountered at the client, dotConnect for SQL Server throws a .NET Framework exception.

Complementary ADO.NET Classes

Class	Description
SqlCommandBuilder	A helper object that automatically generates command properties of SqlDataAdapter and populates the SqlParameter collection of SqlCommand object.
SqlConnectionStringBuilder	Constructs a connection string by assigning values to appropriate properties.
SqlDataSourceEnumerator	Retrieves list of available servers in the network.

dotConnect for SQL Server Advanced Classes

Class	Description
SqlDataTable	Provides all of the functionality needed to retrieve and manipulate data from a SQL Server data source. Combines connected and disconnected data access models.
SqlDataSet	Represents typed and untyped SQL Server-specific datasets. Bases on SqlDataTable objects to build the schema.
DataLink	Serves to establish flexible cross-form data binding.

dotConnect for SQL Server Auxiliary Classes

Class	Description
SqlScript	Serves to execute series of SQL statements.
SqlLoader	Serves to load external data into the SQL Server.
SqlMonitor	Serves to monitor dynamic SQL execution in applications that use dotConnect for SQL Server.