Connecting to SQLFire with the ADO.NET Driver

Use the SQLFClientConnection class to create a new connection to a SQLFire cluster. You must specify a connection URL of the form "server=hostname:port".

For example:
string sqlfHost = "localhost";
int sqlfPort = 1527;
string connectionStr = string.Format(@"server={0}:{1}", sqlfHost, sqlfPort);

SQLFClientConnection connection = null;

try
{
    // Initialize and open connection
    connection = new SQLFClientConnection(connectionStr);
    connection.Open();

    ///
    /// Execute SQLFire commands 
    ///
}
catch (Exception e)
{
    ///
    /// Log or re-throw exception
    /// 
}
finally
{
    connection.Close();
}

This creates a client connection to a SQLFire server running on the local machine and listening on the default port 1527. After you obtain a connection you can execute DDL and DML statements as necessary.