Stored Procedures

RapTier generates the following stored procedures:

_<TableCodeName>_GetAll

Gets all records from the table.

_<TableCodeName>_GetByPrimaryKey

Gets a record from the table using the primary key value.

_<TableCodeName>_GetBy_<ForeignKeyColumnName>

Gets all records for the specified foreign key.

_<TableCodeName>_Insert

Inserts a new record into the table.

_<TableCodeName>_Update

Updates a record in the table.

_<TableCodeName>_DeleteByPrimaryKey

Deletes a record from the table using the primary key value.

_<TableCodeName>_DeleteBy_<ForeignKeyColumnName>

Delete records from the table using a foreign key.

_<TableCodeName>_DeleteAll

Deletes all records from the table.