TraceReader 클래스

The TraceReader class is an abstract Trace Object class that is used in the construction of the TraceServer class, the TraceTable class, and the TraceFile class.

상속 계층

System.Object
  Microsoft.SqlServer.Management.Trace.TraceReader
    Microsoft.SqlServer.Management.Trace.TraceReaderWriter
    Microsoft.SqlServer.Management.Trace.TraceServer

네임스페이스:  Microsoft.SqlServer.Management.Trace
어셈블리:  Microsoft.SqlServer.ConnectionInfoExtended(Microsoft.SqlServer.ConnectionInfoExtended.dll)

구문

‘선언
<ComVisibleAttribute(False)> _
Public Class TraceReader _
    Implements IDataReader, IDisposable, IDataRecord
‘사용 방법
Dim instance As TraceReader

[ComVisibleAttribute(false)]
public class TraceReader : IDataReader, 
    IDisposable, IDataRecord

[ComVisibleAttribute(false)]
public ref class TraceReader : IDataReader, 
    IDisposable, IDataRecord

[<ComVisibleAttribute(false)>]
type TraceReader =  
    class 
        interface IDataReader 
        interface IDisposable 
        interface IDataRecord 
    end

public class TraceReader implements IDataReader, IDisposable, IDataRecord

TraceReader 유형에서 다음 멤버를 표시합니다.

생성자

	이름	설명
	TraceReader	Initializes a new instance of the TraceReader class.

맨 위로 이동

속성

	이름	설명
	Depth	Gets the depth value for the trace reader.
	FieldCount	Gets the number of columns in the data.
	IsClosed	Gets the Boolean property value that specifies whether the trace reader is closed.
	Item[Int32]	Gets the column specified by the index position.
	Item[String]	Gets the column with the specified name.
	RecordsAffected	Gets the number of records of data.

맨 위로 이동

메서드

	이름	설명
	Close	Closes the trace reader.
	Dispose	Deletes the trace reader information.
	Equals	(Object에서 상속됨)
	Finalize	(Object에서 상속됨)
	GetBoolean	Returns a Boolean value from the record at the specified column position.
	GetByte	Returns a Byte value from the record at the specified column position.
	GetBytes	Gets a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset.
	GetChar	Gets a character value of the specified column.
	GetChars(Int32, array<Char[], Int32, Int32, Int32)	Gets a character array value from the record at the specified column position.
	GetChars(Int32, Int64, array<Char[], Int32, Int32)	Gets a character array value from the record at the specified column position.
	GetData	Returns IDataReader object used when the field points to a remote data structure.
	GetDataTypeName	Gets the data type of the data value at the specified column position.
	GetDateTime	Gets a DateTime value of the data value at the specified column position.
	GetDecimal	Gets a Decimal value of the data value at the specified column position.
	GetDouble	Gets a floating point value of the data value at the specified column position.
	GetFieldType	Returns the field type of the data value at the specified column position.
	GetFloat	Gets a floating point value of the data value at the specified column position.
	GetGuid	Gets a Guid system value of the data value at the specified column position.
	GetHashCode	(Object에서 상속됨)
	GetInt16	Gets a small integer value of the data value at the specified column position.
	GetInt32	Gets an integer value of the data value at the specified column position.
	GetInt64	Gets a long integer value of the data value at the specified column position.
	GetName	Gets the name of the field at the specified column position.
	GetOrdinal	Gets the ordinal value of the data value at the specified column position.
	GetSchemaTable	Gets a table that describes the schema.
	GetStream	Gets the stream of data.
	GetString	Gets a String value at the specified column position.
	GetTimeSpan	Gets a TimeSpan value of the data value at the specified column position.
	GetType	(Object에서 상속됨)
	GetValue	Gets a value of the data value at the specified column position.
	GetValues	Gets an array of values from the data value at the specified column position.
	IsDBNull	Specifies whether the specified column is set to null.
	IsNull	Gets a Boolean value that specifies whether value of the data at the specified column position is null.
	MemberwiseClone	(Object에서 상속됨)
	NextResult	Moves to the next result in the trace.
	Read	Reads the trace record.
	ToString	(Object에서 상속됨)
	TranslateSubclass	Translates the sub class.

맨 위로 이동

필드

	이름	설명
	currentRow	Specifies the current row.

맨 위로 이동

주의

The TraceReader class provides trace data reading functionality and access to data that is common to both the TraceServer class, the TraceTable class, and the TraceFile class.

The trace data reading functionality is also available on the TraceReaderWriter class, which is derived from the TraceReader class and is used in the construction of the TraceTable class and TraceFile class.

Thread Safety

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

예

Using SQL Server Profiler

스레드 보안

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

Microsoft.SqlServer.Management.Trace 네임스페이스

관련 자료

추적 플래그(Transact-SQL)

SQL Server Profiler 템플릿 및 권한