C# Class 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.

Inheritance: IDisposable

Afficher le fichier Open project: niik/DtaSpy Class Usage Examples

Méthodes publiques

Méthode	Description
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.

Méthodes protégées

Méthode	Description
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.

Private Methods

Méthode	Description
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

Method Details

BizTalkTrackingDb() public méthode

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.
Résultat	System

DeserializeMessageFromRecord() protected méthode

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

protected DeserializeMessageFromRecord ( IDataRecord record, int spoolId ) : BizTalkTrackedMessage
record	IDataRecord
spoolId	int
Résultat	BizTalkTrackedMessage

DeserializeMessagePartFromRecord() protected méthode

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

protected DeserializeMessagePartFromRecord ( IDataReader record, int spoolId ) : BizTalkTrackedMessagePart
record	IDataReader
spoolId	int
Résultat	BizTalkTrackedMessagePart

IDisposable() public méthode

public IDisposable ( ) : void
Résultat	void

LoadTrackedMessage() public méthode

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.
Résultat	BizTalkTrackedMessage

LoadTrackedMessage() public méthode

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.
Résultat	BizTalkTrackedMessage

LoadTrackedMessageContext() public méthode

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.
Résultat	BizTalkPropertyBag

LoadTrackedMessages() public méthode

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

public LoadTrackedMessages ( ) : IEnumerable
Résultat	IEnumerable

LoadTrackedMessages() public méthode

Loads all tracked messages in the given spool.

public LoadTrackedMessages ( int spoolId ) : IEnumerable
spoolId	int	The spool id.
Résultat	IEnumerable

LoadTrackedPart() public méthode

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.
Résultat	BizTalkTrackedMessagePart

LoadTrackedPartFragment() public méthode

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.
Résultat	BizTalkFragment

LoadTrackedParts() public méthode

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.
Résultat	IEnumerable