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

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
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