1.1

IsolationLevel
Property to get the isolation level for the current transaction, if any. If no transaction is in progress then this
returns System.Data.IsolationLevel.Unspecified.
Open(Dictionary<string, object>)
Open the connection providing an optional set of properties. This set of properties can also be provided as part
of the connection string as semi-colon separated <key>=<value> pairs..The available properties are:
• load-balance: (Boolean) Indicates whether to attempt load-balancing for this connection by selecting a less
loaded server for actual connection. Load balancing for clients works only if there is a locator in the SQLFire
cluster, and clients should preferably use the locator for creating the connection. Default is true.
• disable-streaming: (Boolean) If set to false then queries executed on the SQLFire servers will stream results
as soon as some members have data. If set to true then streaming will be disabled and the query result will not
be sent back till all servers in the cluster have completely sent back their results. If set to false then this has
implications in the way failover works when servers fail – if a server happens to fail while some result has
already been consumed by the client using a SQLFDataReader then the driver cannot transparently failover to
the new server rather the client will receive a SQLFException with State “X0Z01”. Default is false.
• user: (String) The user name to be used for this connection if authentication is enabled on the servers.
• password: (String) The password to be used for this connection if authentication is enabled on the servers.
Rollback
Rollback the active transaction in progress on this connection. There is no support for nested transactions in
SQLFire so at most one transaction can be in progress at a given time on a connection.
Example: Connect to a single server with defaults and disable-streaming property
// Start a SQLFire server that starts a network server on localhost:1527
$ sqlf server start
Starting SQLFire Server using multicast for peer discovery:
239.192.81.1[10334]
Starting network server for SQLFire Server at address
localhost/127.0.0.1[1527]
...
// 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();
// perform operations
conn.Close();
}
// Open a new connection to the server with streaming disabled
using (SQLFClientConnection conn = new SQLFClientConnection(connectionStr))
{
Dictionary<string, string> props = new Dictionary<string, string>();
props.Add("disable-streaming", "true");
conn.Open(props);
// perform operations
conn.Close();
}
667
ADO.NET Driver Reference