C# 클래스 DtaSpy.BizTalkTrackingDb

Database wrapper for retrieval of tracked messages, parts, fragments and context. Normally you'd use an instance of this object to retrieve one or more messages and then use the message instances to access all related objects (parts, fragments and contexts). For all methods to work the connection needs to have EXECUTE permissions for the following stored procedures in the BizTalk DTA database: ops_LoadTrackedMessages, ops_LoadTrackedPartByID, ops_LoadTrackedParts, ops_LoadTrackedMessageContext and ops_LoadTrackedPartFragment.

상속: IDisposable

파일 보기 프로젝트 열기: niik/DtaSpy 1 사용 예제들

공개 메소드들

메소드	설명
BizTalkTrackingDb ( string connectionString ) : System	Initializes a new instance of the BizTalkTrackingDb class with which you can retrieve tracked messages, parts, fragments and contexts.
IDisposable ( ) : void
LoadTrackedMessage ( Guid messageId ) : BizTalkTrackedMessage	Attempts to load the tracked message regardless of which spool it resides in by first testing spool 1 then spool 2. Returns null if no message was found.
LoadTrackedMessage ( Guid messageId, int spoolId ) : BizTalkTrackedMessage	Attempts to load the tracked message regardless from the given spool. Returns null if no message was found.
LoadTrackedMessageContext ( Guid messageId, int spoolId ) : BizTalkPropertyBag	Loads the tracked message context. Returns null if no part fragment was found.
LoadTrackedMessages ( ) : IEnumerable	Loads all tracked messages in the current database (in both pools).
LoadTrackedMessages ( int spoolId ) : IEnumerable	Loads all tracked messages in the given spool.
LoadTrackedPart ( Guid messageId, Guid partId, int spoolId ) : BizTalkTrackedMessagePart	Loads the tracked part. Returns null if no such part was found in the specified spool.
LoadTrackedPartFragment ( Guid partId, int fragmentNumber, int spoolId ) : BizTalkFragment	Loads a tracked part fragment. Returns null if no part fragment was found.
LoadTrackedParts ( Guid messageId, int spoolId ) : IEnumerable	Loads all tracked parts for the given message id.

보호된 메소드들

메소드	설명
DeserializeMessageFromRecord ( IDataRecord record, int spoolId ) : BizTalkTrackedMessage	Given a data record; tranform that record into a message.
DeserializeMessagePartFromRecord ( IDataReader record, int spoolId ) : BizTalkTrackedMessagePart	Given a data record; tranform that record into a message part.

비공개 메소드들

메소드	설명
AddInParameter ( SqlCommand cmd, string parameterName, SqlDbType type, int size, object value ) : SqlParameter
AddInParameter ( SqlCommand cmd, string parameterName, SqlDbType type, object value ) : SqlParameter
CreateStoredProcedureCommand ( SqlConnection connection, string storedProcedureName ) : SqlCommand
LoadTrackedMessages ( Guid messageGuid, int spoolId ) : IEnumerable	Internal message access method; accepts Guid.Empty

메소드 상세

BizTalkTrackingDb() 공개 메소드

Initializes a new instance of the BizTalkTrackingDb class with which you can retrieve tracked messages, parts, fragments and contexts.

public BizTalkTrackingDb ( string connectionString ) : System
connectionString	string	The connection string to the BizTalk DTA database.
리턴	System

DeserializeMessageFromRecord() 보호된 메소드

Given a data record; tranform that record into a message.

protected DeserializeMessageFromRecord ( IDataRecord record, int spoolId ) : BizTalkTrackedMessage
record	IDataRecord
spoolId	int
리턴	BizTalkTrackedMessage

DeserializeMessagePartFromRecord() 보호된 메소드

Given a data record; tranform that record into a message part.

protected DeserializeMessagePartFromRecord ( IDataReader record, int spoolId ) : BizTalkTrackedMessagePart
record	IDataReader
spoolId	int
리턴	BizTalkTrackedMessagePart

IDisposable() 공개 메소드

public IDisposable ( ) : void
리턴	void

LoadTrackedMessage() 공개 메소드

Attempts to load the tracked message regardless of which spool it resides in by first testing spool 1 then spool 2. Returns null if no message was found.

public LoadTrackedMessage ( Guid messageId ) : BizTalkTrackedMessage
messageId	Guid	The message id.
리턴	BizTalkTrackedMessage

LoadTrackedMessage() 공개 메소드

Attempts to load the tracked message regardless from the given spool. Returns null if no message was found.

public LoadTrackedMessage ( Guid messageId, int spoolId ) : BizTalkTrackedMessage
messageId	Guid	The message id.
spoolId	int	The spool id.
리턴	BizTalkTrackedMessage

LoadTrackedMessageContext() 공개 메소드

Loads the tracked message context. Returns null if no part fragment was found.

public LoadTrackedMessageContext ( Guid messageId, int spoolId ) : BizTalkPropertyBag
messageId	Guid	The message id.
spoolId	int	The spool id.
리턴	BizTalkPropertyBag

LoadTrackedMessages() 공개 메소드

Loads all tracked messages in the current database (in both pools).

public LoadTrackedMessages ( ) : IEnumerable
리턴	IEnumerable

LoadTrackedMessages() 공개 메소드

Loads all tracked messages in the given spool.

public LoadTrackedMessages ( int spoolId ) : IEnumerable
spoolId	int	The spool id.
리턴	IEnumerable

LoadTrackedPart() 공개 메소드

Loads the tracked part. Returns null if no such part was found in the specified spool.

public LoadTrackedPart ( Guid messageId, Guid partId, int spoolId ) : BizTalkTrackedMessagePart
messageId	Guid	The message id.
partId	Guid	The part id.
spoolId	int	The spool id.
리턴	BizTalkTrackedMessagePart

LoadTrackedPartFragment() 공개 메소드

Loads a tracked part fragment. Returns null if no part fragment was found.

public LoadTrackedPartFragment ( Guid partId, int fragmentNumber, int spoolId ) : BizTalkFragment
partId	Guid	The part id.
fragmentNumber	int	The fragment number.
spoolId	int	The spool id.
리턴	BizTalkFragment

LoadTrackedParts() 공개 메소드

Loads all tracked parts for the given message id.

public LoadTrackedParts ( Guid messageId, int spoolId ) : IEnumerable
messageId	Guid	The message id.
spoolId	int	The spool id.
리턴	IEnumerable