1.1

DescriptionMethod
explicitly (by invoking Prepare). The new command string will be
added to the batch in order and the result of ExecuteBatch() will have
the update count in the integer array result in that order. For an
example of usage see the ExecuteBatch() method.
Clears the list of commands or parameter lists in the current batch.ClearBatch()
Submits the current batch of commands for execution to the SQLFire
system. If all commands in the batch execute successfully, it returns
ExecuteBatch()
the result as an array of update counts in order. If one or more
commands throw an SQLFException, a
VMware.Data.SQLFire.BatchUpdateException is thrown, with all
exceptions linked in the NextException field.
Additional SQLFire extensions
Additional SQLFire extension methods and properties are described below. The MSDN documentation for
IDbCommand and DbCommand provides details on all other API methods.
DescriptionMethod or property name
Creates a named VMware.Data.SQLFire.SQLFParameter with given
VMware.Data.SQLFire.SQLFType.
CreateParameter(string name, SQLFType type)
Returns a new VMware.Data.SQLFire.SQLFDataAdapter associated
with this command.
CreateDataAdapter()
Gets or sets the number of rows that are attempted to be fetched from
the server in one group when using a DataReader
FetchSize
(VMware.Data.SQLFire.SQLFDataReader). A value of <= 0 indicates
using the default fetch size of the SQLFire servers (currently 16). A
larger number can reduce the number of round-trips between the
client and servers, but requires more memory and can result in a
higher latency due to larger transportation size in some rare cases.
A small number can cause a large number of round-trips between
the client and servers that can hit both the latency and throughput
badly. Increasing this size can boost performance for cases when you
expect large number of rows as the result.
Property to get or set the type of DataReader returned by the
ExecuteReader methods. Possible values for the DataReaderType
enumeration of the type of this property are:
ReaderType
• ForwardOnly: Indicates that the DataReader can move only in one
direction, forward. This is the default value.
• ScrollInsensitive: Indicates that the DataReader can freely move
forward or back on the results, and corresponds to the
scroll-insensitive ResultSets in JDBC. The underlying result set is
insensitive to any changes made to the underlying data.
• ScrollSensitive: Indicates that the DataReader can freely move
forward or back on the results, and corresponds to the
scroll-sensitive ResultSets in JDBC. The underlying result set is
sensitive to any changes made to the underlying data and may reflect
the changes made via the cursor in the reader.
vFabric SQLFire User's Guide672
vFabric SQLFire Reference