Compartilhar via

GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL)

Aplica-se:SQL Server

Retorna um token que representa o contexto da transação atual de uma sessão. O token é usado por um aplicativo para associar operações de fluxo contínuo do sistema de arquivos de FILESTREAM à transação. Para obter uma lista de artigos FILESTREAM, consulte Dados de Objeto Binário Grande (Blob) (SQL Server).

Convenções de sintaxe de Transact-SQL

Sintaxe

GET_FILESTREAM_TRANSACTION_CONTEXT()

Tipos de retorno

varbinary(max)

Valor de retorno

NULL será retornado se a transação não tiver sido iniciada ou tiver sido cancelada ou confirmada.

Comentários

A transação deve ser explícita. Use BEGIN TRANSACTION seguido por COMMIT TRANSACTION ou ROLLBACK TRANSACTION.

Quando você chama GET_FILESTREAM_TRANSACTION_CONTEXT, o chamador recebe acesso do sistema de arquivos à transação durante a transação. Para permitir que outro usuário acesse a transação por meio do sistema de arquivos, use EXECUTE AS para ser executado GET_FILESTREAM_TRANSACTION_CONTEXT como o outro usuário.

Exemplos

O exemplo a seguir usa GET_FILESTREAM_TRANSACTION_CONTEXT em uma transação do Transact- SQL para obter o contexto da transação.

using System;
using System.Data.SqlClient;
using System.Data;

namespace ConsoleApplication
{
    /// <summary>
    /// This class is a wrapper that contains methods for:
    ///
    ///     GetTransactionContext() - Returns the current transaction context.
    ///     BeginTransaction() - Begins a transaction.
    ///     CommitTransaction() - Commits the current transaction.
    ///
    /// </summary>

    class SqlAccessWrapper
    {
        /// <summary>
        /// Returns a byte array that contains the current transaction
        /// context.
        /// </summary>
        /// <param name="sqlConnection">
        /// SqlConnection object that represents the instance of SQL Server
        /// from which to obtain the transaction context.
        /// </param>
        /// <returns>
        /// If there is a current transaction context, the return
        /// value is an Object that represents the context.
        /// If there is not a current transaction context, the
        /// value returned is DBNull.Value.
        /// </returns>

        public Object GetTransactionContext(SqlConnection sqlConnection)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "SELECT GET_FILESTREAM_TRANSACTION_CONTEXT()";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = sqlConnection;

            return cmd.ExecuteScalar();

        }

        /// <summary>
        /// Begins the transaction.
        /// </summary>
        /// <param name="sqlConnection">
        /// SqlConnection object that represents the server
        /// on which to run the BEGIN TRANSACTION statement.
        /// </param>

        public void BeginTransaction(SqlConnection sqlConnection)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "BEGIN TRANSACTION";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = sqlConnection;

            cmd.ExecuteNonQuery();
        }

        /// <summary>
        /// Commits the transaction.
        /// </summary>
        /// <param name="sqlConnection">
        /// SqlConnection object that represents the instance of SQL Server
        /// on which to run the COMMIT statement.
        /// </param>

        public void CommitTransaction(SqlConnection sqlConnection)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "COMMIT TRANSACTION";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = sqlConnection;

            cmd.ExecuteNonQuery();
        }
    }

    class Program
    {
        static void Main(string[] args)
        {
            //Open a connection to the local instance of SQL Server.

            SqlConnection sqlConnection = new SqlConnection("Integrated Security=true;server=(local)");
            sqlConnection.Open();

            SqlAccessWrapper sql = new SqlAccessWrapper();

            //Create a transaction so that sql.GetTransactionContext() will succeed.
            sql.BeginTransaction(sqlConnection);

            //The transaction context will be stored in this array.
            Byte[] transactionToken;

            Object txObj = sql.GetTransactionContext(sqlConnection);
            if (DBNull.Value != txObj)
            {
                transactionToken = (byte[])txObj;
                Console.WriteLine("Transaction context obtained.\n");
            }

            sql.CommitTransaction(sqlConnection);
        }
    }
}

Conteúdo relacionado

  • Last updated on