Export (0) Print
Expand All

SqlTrackingService Class

Note: This API is now obsolete.

Represents a tracking service that uses a SQL database to store tracking information.

Namespace:  System.Workflow.Runtime.Tracking
Assembly:  System.Workflow.Runtime (in System.Workflow.Runtime.dll)

[ObsoleteAttribute("The System.Workflow.* types are deprecated.  Instead, please use the new types from System.Activities.*")]
public sealed class SqlTrackingService : TrackingService, 
	IProfileNotification

The SqlTrackingService type exposes the following members.

  NameDescription
Public methodSqlTrackingService(NameValueCollection)Initializes a new instance of the SqlTrackingService class by using the specified NameValueCollection.
Public methodSqlTrackingService(String)Initializes a new instance of the SqlTrackingService class by using the specified database connection string.
Top

  NameDescription
Public propertyConnectionStringGets the connection string for the tracking database.
Public propertyEnableRetriesGets and sets a value specifying whether the SqlTrackingService will retry when performing a database operation.
Public propertyIsTransactionalGets or sets a value that indicates whether SqlTrackingService participates in workflow transactions.
Public propertyPartitionOnCompletionGets or sets a value that specifies whether tracking data for a workflow instance should be moved to the currently active partition in the database when the workflow instance is completed.
Public propertyProfileChangeCheckIntervalGets or sets a value that specifies the interval at which the database should be checked for changes to one or more of its tracking profiles.
Public propertyUseDefaultProfileGets or sets a value specifying whether a default TrackingProfile should be used for workflow types that do not have a tracking profile.
Top

  NameDescription
Public methodEquals(Object)Determines whether the specified object is equal to the current object. (Inherited from Object.)
Public methodGetHashCodeServes as the default hash function. (Inherited from Object.)
Protected methodGetProfile(Guid)Must be overridden in the derived class, and when implemented, returns the tracking profile for the specified workflow instance. (Inherited from TrackingService.)
Protected methodGetProfile(Type, Version)Must be overridden in the derived class, and when implemented, returns the tracking profile, qualified by version, for the specified workflow Type. (Inherited from TrackingService.)
Protected methodGetTrackingChannelMust be overridden in the derived class, and when implemented, returns the channel that the run-time tracking infrastructure uses to send tracking records to the tracking service. (Inherited from TrackingService.)
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Protected methodStartWhen overridden in a derived class, starts the service and changes the State to Starting. (Inherited from WorkflowRuntimeService.)
Protected methodStopWhen overridden in a derived class, stops the service and changes the State to Stopping. (Inherited from WorkflowRuntimeService.)
Public methodToStringReturns a string that represents the current object. (Inherited from Object.)
Protected methodTryGetProfileMust be overridden in the derived class, and when implemented, retrieves the tracking profile for the specified workflow type if one is available. (Inherited from TrackingService.)
Protected methodTryReloadProfileMust be overridden in the derived class, and when implemented, retrieves a new tracking profile for the specified workflow instance if the tracking profile has changed since it was last loaded. (Inherited from TrackingService.)
Top

  NameDescription
Public eventProfileRemovedOccurs when the SqlTrackingService detects that a TrackingProfile has been deleted.
Public eventProfileUpdatedOccurs when the SqlTrackingService detects that a TrackingProfile has been changed.
Top

NoteNote

This material discusses types and namespaces that are obsolete. For more information, see Deprecated Types in Windows Workflow Foundation 4.5.

The SqlTrackingService class represents a fully functional tracking service. You can use this service out-of-box to collect and store tracking information, and to store tracking profiles and provide them when requested by the workflow runtime engine. The SQL tracking service writes tracking data sent to it by the runtime tracking infrastructure to a SQL database.

In many scenarios it is important for the SqlTrackingService to maintain consistency between its database and the state of the workflow runtime engine. Therefore, the SqlTrackingChannel class makes use of the IPendingWork interface to participate in the workflow transaction batching functionality provided by the WorkflowCommitWorkBatchService. You can set IsTransactional or pass the appropriate parameters to the constructor to configure the SqlTrackingService to participate in batching and add objects that represent pending changes to the SQL database to the WorkBatch.

The SqlTrackingService also maintains tracking profiles in its database. The workflow runtime engine must be kept apprised of changes to any of the tracking profiles that it is using. The SqlTrackingService implements the IProfileNotification interface and periodically examines the tracking profiles in its database in order to notify the workflow runtime engine of changes to a TrackingProfile stored in its database. You can set ProfileChangeCheckInterval or pass the appropriate parameter to the constructor in order to set the interval at which the SqlTrackingService examines its tracking profiles to notify the tracking runtime of any profile changes.

NoteNote

When using both the SqlTrackingService and the SqlWorkflowPersistenceService in a workflow application, it is recommended that you use a single database for both persistence and tracking.

.NET Framework

Supported in: 4, 3.5, 3.0
Obsolete (compiler warning) in 4.5
Obsolete (compiler warning) in 4.5.1
Obsolete (compiler warning) in 4.5.2

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft