string connectionString = "\[Insert valid connection strign here\]";
        connection = new FbConnection\(connectionString\);
        connection\.Open\(\);

        string sql = "EXECUTE BLOCK AS\\r\\n " \+
            "DECLARE VARIABLE ADDRESSID INT = @X;\\r\\n" \+
            "DECLARE VARIABLE STREET VARCHAR\(50\) = @Y;\\r\\n" \+
            "DECLARE VARIABLE LAST\_MOD DATE = @Z;\\r\\n" \+
            "BEGIN\\r\\n" \+
            "    IF \(EXISTS\(SELECT ADDRESSID FROM ADDRESS WHERE ADDRESSID = :ADDRESSID\)\) THEN\\r\\n" \+
            "        UPDATE ADDRESS SET STREET = :STREET, LAST\_MOD = :LAST\_MOD WHERE ADDRESSID = :ADDRESSID AND LAST\_MOD < :LAST\_MOD;\\r\\n" \+
            "    ELSE\\r\\n" \+
            "        INSERT INTO ADDRESS\(ADDRESSID, STREET, LAST\_MOD\) VALUES\(:ADDRESSID, :STREET, :LAST\_MOD\);\\r\\n" \+
            "END;";

        FbCommand fbCommand = new FbCommand\(sql, connection\);

        FbParameter fbParameter = new FbParameter\("@X", FbDbType\.Integer\);
        fbParameter\.Value = 5;
        fbCommand\.Parameters\.Add\(fbParameter\);

        fbParameter = new FbParameter\("@Y", FbDbType\.VarChar\);
        fbParameter\.Size = 50;
        fbParameter\.Value = "Fred";
        fbCommand\.Parameters\.Add\(fbParameter\);

        fbParameter = new FbParameter\("@Z", FbDbType\.Date\);
        fbParameter\.Value = DateTime\.Now;
        fbCommand\.Parameters\.Add\(fbParameter\);

        fbCommand\.ExecuteNonQuery\(\);

	private void Prepare\(bool returnsSet\)
	\{
		LogCommand\(\);

		FbConnectionInternal innerConn = this\.connection\.InnerConnection;

		// Check if	we have	a valid	transaction
		if \(this\.transaction == null\)
		\{
			if \(innerConn\.IsEnlisted\)
			\{
				this\.transaction = innerConn\.ActiveTransaction;
			\}
			else
			\{
				this\.implicitTransaction = true;
				this\.transaction = new FbTransaction\(this\.connection, this\.connection\.ConnectionOptions\.IsolationLevel\);
				this\.transaction\.BeginTransaction\(\);

				// Update Statement	transaction
				if \(this\.statement \!= null\)
				\{
					this\.statement\.Transaction = this\.transaction\.Transaction;
				\}
			\}
		\}

		// Check if	we have	a valid	statement handle
		if \(this\.statement == null\)
		\{
			this\.statement = innerConn\.Database\.CreateStatement\(this\.transaction\.Transaction\);
		\}

		// Prepare the statement if	needed
		if \(\!this\.statement\.IsPrepared\)
		\{
			// Close the inner DataReader if needed
			this\.CloseReader\(\);

			// Reformat the SQL statement if needed
			string sql = this\.commandText;

			if \(this\.commandType == CommandType\.StoredProcedure\)
			\{
				sql = this\.BuildStoredProcedureSql\(sql, returnsSet\);
			\}

			try
			\{
                //Work around for "EXECUTE BLOCK" with FbParameters\.
                if \(sql\.ToUpper\(\)\.StartsWith\("EXECUTE BLOCK"\) && sql\.ToUpper\(\)\.Contains\("DECLARE VARIABLE"\) && this\.parameters\.Count \> 0\)
                \{
                    sql = this\.SubstituteParameters\(sql\);
                \}

                // Try to prepare the command
				this\.statement\.Prepare\(this\.ParseNamedParameters\(sql\)\);
			\}
			catch
			\{
				// Release the statement and rethrow the exception
				this\.statement\.Release\(\);
				this\.statement = null;

				throw;
			\}

			// Add this	command	to the active command list
			innerConn\.AddPreparedCommand\(this\);
		\}
		else
		\{
			// Close statement for subsequently	executions
			this\.Close\(\);
		\}
	\}

                    case FbDbType\.Boolean:
                        bool boolValue = \(bool\)fbParameter\.Value;
                        string boolStringValue = "0";
                        if \(boolValue\)
                        \{
                            boolStringValue = "1";
                        \}
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, boolStringValue\);
                        break;

                    case FbDbType\.Char:
                    case FbDbType\.Text:
                    case FbDbType\.VarChar:
                        string strValue = \(string\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, "'" \+ strValue\.Replace\("'", "''"\) \+ "'"\);
                        break;

                    case FbDbType\.Date:
                    case FbDbType\.Time:
                    case FbDbType\.TimeStamp:
                        DateTime dateValue = \(DateTime\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, "'" \+ dateValue\.ToString\("yyyy\-MM\-dd HH:mm:ss"\) \+ "'"\);
                        break;

                    case FbDbType\.Decimal:
                        decimal decValue = \(decimal\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, decValue\.ToString\(\)\);
                        break;

                    case FbDbType\.Double:
                        double dblValue = \(double\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, dblValue\.ToString\(\)\);
                        break;

                    case FbDbType\.Float:
                        float floatValue = \(float\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, floatValue\.ToString\(\)\);
                        break;

                    case FbDbType\.Guid:
                        Guid guid = \(Guid\)fbParameter\.Value;
                        string guidString = "CHAR\_TO\_UUID\('" \+ guid\.ToString\(\) \+ "'\)";
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, guidString\.ToString\(\)\);
                        break;

                    case FbDbType\.Integer:
                        int intValue = \(int\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, intValue\.ToString\(\)\);
                        break;

                    case FbDbType\.Numeric:
                        double numValue = \(double\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, numValue\.ToString\(\)\);
                        break;

                    case FbDbType\.SmallInt:
                        short shtValue = \(short\)fbParameter\.Value;
                        sqlCommand = sqlCommand\.Replace\(fbParameter\.ParameterName, shtValue\.ToString\(\)\);
                        break;

                    default:
                        throw new NotImplementedException\("Parameter of " \+ fbParameter\.FbDbType\.ToString\("G"\) \+ " not implemented in 'EXECUTE BLOCK' commands\."\);

                \}
            \}

        \}
        return sqlCommand;
    \}