Updates a database table via Bulk operations of the specific database driver. Falls back to Insert Data Table if the database driver does not support Bulk operations.

Arguments

Updates a compatible DataTable in an existing database table. The activity also updates all the columns that are not in the collection of column names used as a primary key. Returns the number of rows affected.

Arguments

Properties

Connects to a database by using a standard connection string

Arguments

Closes a connection to a database

Arguments

Connects to a database and features a Sequence which can perform multiple transactions with the database. It returns a DatabaseConnection variable, providing a scope for Database activities. If UseTransaction is set to True, the contained operations are executed in a single transaction, and applied at the end if none of the them failed. If UseTransaction is set to False, all operations are committed individually. When this activity ends, the connection to the database is closed.

Arguments

Properties

Executes an SQL statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.

Arguments

Properties

Executes a query on a database and returns the query result as a Data Table

Arguments

Properties

Inserts a compatible DataTable in an existing database table. Returns the number of rows affected.

Arguments