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)


[<Sealed>]
[<ObsoleteAttribute("The System.Workflow.* types are deprecated.  Instead, please use the new types from System.Activities.*")>]
type SqlTrackingService = 
    class
        inherit TrackingService
        interface IProfileNotification
    end

NameDescription
System_CAPS_pubmethodSqlTrackingService(NameValueCollection)

Initializes a new instance of the SqlTrackingService class by using the specified NameValueCollection.

System_CAPS_pubmethodSqlTrackingService(String)

Initializes a new instance of the SqlTrackingService class by using the specified database connection string.

NameDescription
System_CAPS_pubpropertyConnectionString

Gets the connection string for the tracking database.

System_CAPS_pubpropertyEnableRetries

Gets and sets a value specifying whether the SqlTrackingService will retry when performing a database operation.

System_CAPS_pubpropertyIsTransactional

Gets or sets a value that indicates whether SqlTrackingService participates in workflow transactions.

System_CAPS_pubpropertyPartitionOnCompletion

Gets 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.

System_CAPS_pubpropertyProfileChangeCheckInterval

Gets 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.

System_CAPS_pubpropertyUseDefaultProfile

Gets or sets a value specifying whether a default TrackingProfile should be used for workflow types that do not have a tracking profile.

NameDescription
System_CAPS_pubmethodEquals(Object)

Determines whether the specified object is equal to the current object.(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

Serves as the default hash function. (Inherited from Object.)

System_CAPS_protmethodGetProfile(Guid)

Must be overridden in the derived class, and when implemented, returns the tracking profile for the specified workflow instance.(Inherited from TrackingService.)

System_CAPS_protmethodGetProfile(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.)

System_CAPS_protmethodGetTrackingChannel(TrackingParameters)

Must 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.)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_protmethodStart()

When overridden in a derived class, starts the service and changes the State to Starting.(Inherited from WorkflowRuntimeService.)

System_CAPS_protmethodStop()

When overridden in a derived class, stops the service and changes the State to Stopping.(Inherited from WorkflowRuntimeService.)

System_CAPS_pubmethodToString()

Returns a string that represents the current object.(Inherited from Object.)

System_CAPS_protmethodTryGetProfile(Type, TrackingProfile)

Must 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.)

System_CAPS_protmethodTryReloadProfile(Type, Guid, TrackingProfile)

Must 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.)

NameDescription
System_CAPS_pubeventProfileRemoved

Occurs when the SqlTrackingService detects that a TrackingProfile has been deleted.

System_CAPS_pubeventProfileUpdated

Occurs when the SqlTrackingService detects that a TrackingProfile has been changed.

System_CAPS_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.

System_CAPS_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
Available since 3.0

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

System.Workflow.Runtime.Tracking Namespace
Using SqlTrackingService
Data Maintenance with SqlTrackingService

Return to top
Show: