Database activities

Every activity in Velophex.Database.Activities 0.7.1-rc.7.

Not in the supported profile

This pack is published to the activities feed but is not in the supported 0.7 profile. Use it for evaluation; full reference pages come later.

Package Velophex.Database.Activities · version 0.7.1-rc.7 · 13 activities. Generated from build 0.7.1-rc.7.

Database#

• Bulk Insert (velophex.database.bulkInsert): Inserts a DataTable with the provider's bulk path (SQL Server, PostgreSQL), or in one transaction on the others.
• Bulk Update (velophex.database.bulkUpdate): Updates the database rows that match each DataTable row on the key columns, setting every other column, in one transaction.
• Commit Transaction (velophex.database.commitTransaction): Commits the transaction of a Database Transaction scope when its body completed; placed by the scope.
• Create Table (velophex.database.createTable): Creates a database table with the columns, column types, nullability and primary key of a DataTable.
• Database Transaction (velophex.database.beginTransaction): Runs the activities placed inside it in one transaction on the enclosing Use Database connection: committed when they complete, rolled back when they fail.
• Disconnect from Database (velophex.database.disconnect): Closes a database connection before its Use Database scope ends.
• End Use Database (velophex.database.endScope): Ends a Use Database or Database Transaction scope and releases its session; placed by the scope.
• Insert Data Table (velophex.database.insertDataTable): Inserts every row of a DataTable into a database table whose columns have the DataTable's column names.
• Rollback Transaction (velophex.database.rollbackTransaction): Rolls back the transaction of the enclosing Database Transaction scope without failing the workflow.
• Run Command (velophex.database.executeNonQuery): Runs an INSERT, UPDATE, DELETE, DDL statement or stored procedure with parameters and returns the number of affected rows.
• Run Query (velophex.database.executeQuery): Runs a SQL query or stored procedure with parameters and returns its first result set as a DataTable.
• Run Stored Procedure (velophex.database.runProcedure): Calls a stored procedure with parameters and returns its first result set, if any, and its output parameters.
• Use Database (velophex.database.useDatabase): Opens a database connection (SQL Server, PostgreSQL, MySQL, SQLite, ODBC or OLE DB) for the activities placed inside it, and closes it when they end.

Database