1.1

DescriptionMethod or property name
If set, this boolean indicates that the underlying rows are requested
to be locked on the SQLFire servers when an ExecuteReader is
ReaderLockForUpdate
invoked. However, rows are not locked unless the SQL statement is
a “SELECT … FOR UPDATE” statement. In addition this takes
effect only in the context of a transaction and not otherwise, and
these follow the normal transactional semantics of SQLFire. No
explicit updatable cursor on the returned DataReader is provided.
Instead users can fire explicit update DML statements as required
while holding the locks on the rows. These locks are released at the
end of the transaction.
Close this command object. Subsequent operations throw an
exception.
Close()
Returns true if the command has been closed by an explicit invocation
of Close(), or if the command object has been disposed.
IsClosed
Example: Using positional parameters
// Open a new connection to the network server running on localhost:1527
string host = "localhost";
int port = 1527;
string connectionStr = string.Format("server={0}:{1}", host, port);
using (SQLFClientConnection conn = new SQLFClientConnection(connectionStr))
{
conn.Open();
// create a table
SQLFCommand cmd = new SQLFCommand(
"create table t1 (id int primary key, addr varchar(20))", conn);
cmd.ExecuteNonQuery();
// insert into the table using positional parameters
cmd = new SQLFCommand("insert into t1 (id, addr) values (?, ?)", conn);
cmd.Prepare();
for (int i = 0; i < 1000; i++) {
cmd.Parameters.Clear();
cmd.Parameters.Add(i);
cmd.Parameters.Add("addr" + i);
cmd.ExecuteNonQuery();
}
// drop the table
cmd = new SQLFCommand("drop table t1", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
Example: Using named parameters
// Open a new connection to the network server running on localhost:1527
string host = "localhost";
int port = 1527;
string connectionStr = string.Format("server={0}:{1}", host, port);
using (SQLFClientConnection conn = new SQLFClientConnection(connectionStr))
673
ADO.NET Driver Reference