1.1

It is not possible to create an instance of this class directly. Applications must use the Parameters property of
the SQLFCommand to be executed for obtaining an instance of this and for adding parameters to it (either
SQLFParameters or the values directly).
When the parameter added to the collection is not a SQLFParameter but is rather the raw .NET value, the
ParameterDirection of the parameter is always assumed to be Input and the SQLFType of the parameter is
determined from the .NET class of the object. If no class can be automatically determined then the type is set to
a generic Other type and it is up to the server to determine whether the parameter can be converted to the actual
expected type for the column or expression.
The methods and properties provided in addition to those of DbParameterCollection are as follows.
DescriptionMethod or property name
Adds a new parameter with given name and type to the collection
and returns the created SQLFParameter.
Add(string parameterName, SQLFType type)
Adds a new parameter with given name, type, and value to the
collection and returns the created SQLFParameter.
Add(string parameterName, SQLFType type, object val)
Returns true if the collection contains the given parameter using the
name of parameter if non-null. Otherwise, searches for the parameter
by reference in the list.
Contains(SQLFParameter parameter)
Gets the parameter at given index in this collection. The returned
value is whatever was added to the collection before, and can be
Get(int index)
either a SQLFParameter or the raw value of the parameter. This has
the same result as when using the index ([]) operator.
Gets the set of all named SQLFParameters in this collection.GetNamedParameters()
Inserts the given parameter at the specified index in this collection.Insert(int index, SQLFParameter parameter)
Sets the parameter at given index in this collection. The passed object
can be an instance of SQLFParameter encapsulating the actual value
Set(int index, object val)
to be bound, or directly the .NET value itself. This has the same
result as when using the index ([]) operator.
Adds a new named SQLFParameter to the collection. If the name
passed is null, the parameter is added as a positional parameter that
SetParameter(string parameterName, SQLFParameter parameter)
is bound to the CommandText of SQLFCommand by its position in
the list. This has the same result as when using the index ([]) operator.
Adds a new SQLFParameter to the collection at given index. If the
name of the parameter is null, the parameter is added as a positional
SetParameter(int index, SQLFParameter parameter)
parameter that is bound to the CommandText of SQLFCommand by
its position in the list alone. This has the same result as when using
the index ([]) operator.
For examples of usage, see the sections on named and positional parameters under
VMware.Data.SQLFire.SQLFCommand on page 670.
The MSDN documentation for IDataParameterCollection and DbParameterCollection provides more details
about the API methods and usage.
VMware.Data.SQLFire.SQLFTransaction
VMware.Data.SQLFire.SQLFTransaction implements the System.Data.IDbTransaction interface, which controls
distributed transactions for a SQLFire system.
This class also extends the abstract System.Data.Common.DbTransaction class, so applications requiring generic
coding can make use of the base class for transactional operations.
A SQLFTransaction object cannot be explicitly created. To begin a new transaction in SQLFire, use the
BeginTransaction methods of the SQLFClientConnection class. It is also possible to control transactions directly
using the SQLFClientConnection using the BeginSQLFTransaction, Commit and Rollback methods without
683
ADO.NET Driver Reference