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.