RWDBMultiRow
In previous sections, we explained how class
RWDBOSql encapsulates SQL statements, and class
RWDBTBuffer<T> encapsulates buffers of data for binding to SQL statements. In this section, we explore class
RWDBMultiRow, another component of the Open SQL API.
Class
RWDBMultiRow is a collection of
RWDBTBuffers. It allows you to add Open SQL to applications using value-based classes like
RWDBResult,
RWDBReader,
RWDBRow, and
RWDBValue. With
RWDBMultiRow, you can:
Assemble
RWDBTBuffers into a collection that provides row operations on its entries, enabling you to group together an entire result set or set of input values.
Automatically create an appropriate set of
RWDBTBuffers from an
RWDBSchema, allowing you to create buffers from the schema of a database table or from the schema of a result set.
Create an
RWDBRow containing
RWDBValues from a slice across several
RWDBTBuffers, so you can easily pass database data in your application without knowing its type.
Let’s look at several examples that show how
RWDBMultiRow can be used in an application.