ULDataAdapter class

Represents a set of commands and a database connection used to fill a System.Data.DataSet and to update a database.

Visual Basic syntax

Public NotInheritable Class ULDataAdapter
    Inherits System.Data.Common.DbDataAdapter
    Implements System.ICloneable

C# syntax

public sealed class ULDataAdapter : 
    System.Data.Common.DbDataAdapter, 
    System.ICloneable

Members

All members of the ULDataAdapter class, including all inherited members.

Name	Description
ULDataAdapter constructor	Initializes a ULDataAdapter object.
AddToBatch method (Inherited from System.Data.Common.DbDataAdapter)	Adds a System.Data.IDbCommand to the current batch.
ClearBatch method (Inherited from System.Data.Common.DbDataAdapter)	Removes all System.Data.IDbCommand objects from the batch.
CreateRowUpdatedEvent method (Inherited from System.Data.Common.DbDataAdapter)	Initializes a new instance of the System.Data.Common.RowUpdatedEventArgs class.
CreateRowUpdatingEvent method (Inherited from System.Data.Common.DbDataAdapter)	Initializes a new instance of the System.Data.Common.RowUpdatingEventArgs class.
Dispose method (Inherited from System.Data.Common.DbDataAdapter)	Releases the unmanaged resources used by the System.Data.Common.DbDataAdapter and optionally releases the managed resources.
ExecuteBatch method (Inherited from System.Data.Common.DbDataAdapter)	Executes the current batch.
Fill method (Inherited from System.Data.Common.DbDataAdapter)	Adds or refreshes rows in the System.Data.DataSet.
FillSchema method (Inherited from System.Data.Common.DbDataAdapter)	Adds a System.Data.DataTable named "Table" to the specified System.Data.DataSet and configures the schema to match that in the data source based on the specified System.Data.SchemaType.
GetBatchedParameter method (Inherited from System.Data.Common.DbDataAdapter)	Returns a System.Data.IDataParameter from one of the commands in the current batch.
GetBatchedRecordsAffected method (Inherited from System.Data.Common.DbDataAdapter)	Returns information about an individual update attempt within a larger batched update.
GetFillParameters method	Returns the parameters set by the user when executing a SELECT statement.
InitializeBatching method (Inherited from System.Data.Common.DbDataAdapter)	Initializes batching for the System.Data.Common.DbDataAdapter.
OnRowUpdated method (Inherited from System.Data.Common.DbDataAdapter)	Raises the RowUpdated event of a .NET Framework data provider.
OnRowUpdating method (Inherited from System.Data.Common.DbDataAdapter)	Raises the RowUpdating event of a .NET Framework data provider.
TerminateBatching method (Inherited from System.Data.Common.DbDataAdapter)	Ends batching for the System.Data.Common.DbDataAdapter.
Update method (Inherited from System.Data.Common.DbDataAdapter)	Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the specified array of System.Data.DataRow objects.
DeleteCommand property	Specifies a ULCommand object that is executed against the database when the DbDataAdapter.Update method is called to delete rows in the database that correspond to deleted rows in the System.Data.DataSet.
FillCommandBehavior property (Inherited from System.Data.Common.DbDataAdapter)	Gets or sets the behavior of the command used to fill the data adapter.
InsertCommand property	Specifies a ULCommand object that is executed against the database when the DbDataAdapter.Update method is called to insert rows in the database that correspond to inserted rows in the System.Data.DataSet.
SelectCommand property	Specifies a ULCommand that is used during the System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet) or System.Data.Common.DbDataAdapter.FillSchema(System.Data.DataSet,System.Data.SchemaType) method calls to obtain a result set from the database for copying into a System.Data.DataSet.
TableMappings property	Returns a collection that provides the master mapping between a source table and a System.Data.DataTable
UpdateBatchSize property (Inherited from System.Data.Common.DbDataAdapter)	Gets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.
UpdateCommand property	Specifies a ULCommand object that is executed against the database when the System.Data.Common.DbDataAdapter.Update method is called to update rows in the database that correspond to updated rows in the System.Data.DataSet.
RowUpdated event	Occurs during an update after a command is executed against the data source.
RowUpdating event	Occurs during an update before a command is executed against the data source.
DefaultSourceTableName field (Inherited from System.Data.Common.DbDataAdapter)	The default name used by the System.Data.Common.DataAdapter object for table mappings.

The System.Data.DataSet provides a way to work with data offline; that is, away from your UltraLite database. The ULDataAdapter class provides methods to associate a System.Data.DataSet with a set of SQL statements.

Since UltraLite is a local database and MobiLink has conflict resolution, the use of the ULDataAdapter is limited. For most purposes, the ULDataReader or ULTable classes provide more efficient access to data.