System.Data.PickDP Library Overview

The System.Data.PickDP ADO.NET library contains the Pick Data Provider components that automate the movement of data between the application and the back-end database. These components can work with any .NET visual control in a manner consistent with ADO.NET standards.

The System.Data.PickDP ADO.NET library makes use of the RDTA.PickDP.Connector library to present Pick data using ADO.NET standard classes such as the Connection, Command, DataReader, DataAdapter, and DataSet. Those experienced with any industry standard ADO.NET provider and .NET databinding find this library very familiar.

The System.Data.PickDP ADO.NET library supports typed and untyped datasets. For a discussion of these, see Dataset Types.

Key Classes

Key Components

PickDPCommand	Represents a Pick statement or stored procedure to execute against a Pick Server database. This class cannot be inherited.
PickDPConnection	Represents an open connection to a Pick Server database. This class cannot be inherited.
PickDPDataAdapter	Represents a set of data commands and a database connection that are used to fill the System.Data.PickDP.PickDPDataSet and update a Pick Server database. This class cannot be inherited.
PickDPDataSet	Represents an in-memory cache of data.

Class Inheritance Model

Object Reference Model

PickDPCommand	Represents a Pick statement or stored procedure to execute against a Pick Server database. This class cannot be inherited.
PickDPConnection	Represents an open connection to a Pick Server database. This class cannot be inherited.
PickDPDataAdapter	Represents a set of data commands and a database connection that are used to fill the System.Data.PickDP.PickDPDataSet and update a Pick Server database. This class cannot be inherited.
PickDPDataAdapterCollection	For internal use only.
PickDPDataReader	Provides a means of reading a forward-only stream of rows from a Pick Server database. This class cannot be inherited.
PickDPDataSet	Represents an in-memory cache of data.
PickDPInvalidConnectionException	Represents the exception that is thrown when incorrectly attempting to connect to the Pick database.
PickDPParameter	Represents a parameter to a System.Data.PickDP.PickDPCommand, and optionally, its mapping to System.Data.PickDP.PickDPDataSet columns. This class cannot be inherited.
PickDPParameterCollection	Represents a collection of parameters relevant to a System.Data.PickDP.PickDPCommand as well as their respective mappings to columns in a System.Data.PickDP.PickDPDataSet. This class cannot be inherited.
PickDPRowUpdatedEventArgs	Provides data for the System.Data.PickDP.PickDPDataAdapter.RowUpdated event. This class cannot be inherited.
PickDPRowUpdatedEventHandler	Represents the method that handles the System.Data.PickDP.PickDPDataAdapter.RowUpdated event of a System.Data.PickDP.PickDPDataAdapter.
PickDPRowUpdatingEventArgs	Provides data for the System.Data.PickDP.PickDPDataAdapter.RowUpdating event. This class cannot be inherited.
PickDPRowUpdatingEventHandler	Represents the method that handles the System.Data.PickDP.PickDPDataAdapter.RowUpdating event of a System.Data.PickDP.PickDPDataAdapter.
PickDPTransaction	Represents a Pick transaction to be made in a Pick Server database. This class cannot be inherited.