다음을 통해 공유


GET_FILESTREAM_TRANSACTION_CONTEXT(Transact-SQL)

세션의 현재 트랜잭션 컨텍스트를 나타내는 토큰을 반환합니다. 응용 프로그램은 이 토큰을 사용하여 FILESTREAM 파일 시스템 스트리밍 작업을 트랜잭션에 바인딩합니다. FILESTREAM 항목 목록은 FILESTREAM 저장소 디자인 및 구현을 참조하십시오.

항목 링크 아이콘Transact-SQL 구문 표기 규칙

구문

GET_FILESTREAM_TRANSACTION_CONTEXT ()

반환 형식

varbinary(max)

반환 값

트랜잭션이 시작되지 않았거나 취소 또는 커밋된 경우 NULL이 반환됩니다.

주의

트랜잭션은 명시적이어야 합니다. BEGIN TRANSACTION을 사용한 다음 COMMIT TRANSACTION 또는 ROLLBACK TRANSACTION을 사용합니다.

GET_FILESTREAM_TRANSACTION_CONTEXT를 호출하면 호출자에게 트랜잭션 기간 동안 트랜잭션에 대한 파일 시스템 액세스 권한이 부여됩니다. 다른 사용자가 파일 시스템을 통해 트랜잭션에 액세스할 수 있도록 하려면 EXECUTE AS를 사용하여 GET_FILESTREAM_TRANSACTION_CONTEXT를 다른 사용자로 실행합니다.

다음 예에서는 Transact-SQL 트랜잭션에 GET_FILESTREAM_TRANSACTION_CONTEXT를 사용하여 트랜잭션 컨텍스트를 구합니다.

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

namespace ConsoleApplication
{
    /// <summary>
    /// This class is a wrapper that contains methods for:
    /// 
    ///     GetTransactionContect() - Returns the current transaction context.
    ///     BeginTransaction() - Begins a transaction.
    ///     CommmitTransaction() - 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);
        }
    }
}
Imports System
Imports System.Data.SqlClient
Imports System.Data

Namespace ConsoleApplication
    ''' <summary> 
    ''' This class is a wrapper that contains methods for: 
    ''' 
    ''' GetTransactionContect() - Returns the current transaction context. 
    ''' BeginTransaction() - Begins a transaction. 
    ''' CommmitTransaction() - 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 Function GetTransactionContext(ByVal sqlConnection As SqlConnection) As Object
            Dim cmd As New SqlCommand()
            cmd.CommandText = "SELECT GET_FILESTREAM_TRANSACTION_CONTEXT()"
            cmd.CommandType = CommandType.Text
            cmd.Connection = sqlConnection

            Return cmd.ExecuteScalar()

        End Function

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

        Public Sub BeginTransaction(ByVal sqlConnection As SqlConnection)
            Dim cmd As New SqlCommand()

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

            cmd.ExecuteNonQuery()
        End Sub

        ''' <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 Sub CommitTransaction(ByVal sqlConnection As SqlConnection)
            Dim cmd As New SqlCommand()

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

            cmd.ExecuteNonQuery()
        End Sub
    End Class

    Class Program
        Shared Sub Main()
            '''Open a connection to the local instance of SQL Server.

            Dim sqlConnection As New SqlConnection("Integrated Security=true;server=(local)")
            sqlConnection.Open()

            Dim sql As New SqlAccessWrapper()

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

            '''The transaction context will be stored in this array. 
            Dim transactionToken As Byte()

            Dim txObj As Object = sql.GetTransactionContext(sqlConnection)

            '''If the returned object is not NULL, there is a valid transaction
            '''token, and it must be converted into a format that is usable within
            '''the application.

            If Not txObj.Equals(DBNull.Value) Then
                transactionToken = DirectCast(txObj, Byte())
                Console.WriteLine("Transaction context obtained." & Chr(10) & "")
            End If

            sql.CommitTransaction(sqlConnection)
        End Sub
    End Class
End Namespace