The OutSystems Platform RuntimePublic.Db API provides functionality to allow you to integrate with your external databases.

With this API you enable your extension modules to call the databases configured in the environment management console. It is, by default, imported to your extension project when you create it in Integration Studio. To use this API you only need to reference its classes in your extension's project.

It is available for both .NET and Java stacks:

Classes

Name

Description

Command

Represents a command to execute queries.

CommittableTransaction

Represents a transaction that needs to be explicitly managed using commit and roll back operations. Can be used for selecting, inserting, updating, and deleting data.

Connection

Represents a connection to a database.

DatabaseAccess

Creates DatabaseProvider instances to access a database.

DatabaseProvider

Provides access to a specific database.

DataParameter

Represents the query parameters associated with a command.

RequestTransaction

Represents the transaction that is automatically managed by the platform. The transaction starts at the beginning of the web request, and is committed when the response is sent to the client. Can be used for selecting, inserting, updating, and deleting data.

SqlHelper

Functions to assist on the manipulation of SQL statements members.

Using the API

See Also

About APIs