SqlExecutionHelper Class

Contains utility methods for SQL execution retries.

Inheritance Hierarchy

System.Object
  CMS.Base.CoreMethods
    CMS.Base.AbstractHelper
      CMS.Base.AbstractHelper<SqlExecutionHelper>
        CMS.DataEngine.SqlExecutionHelper

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 13.0.131

Syntax

public class SqlExecutionHelper : AbstractHelper<SqlExecutionHelper>

The SqlExecutionHelper type exposes the following members.

Constructors

	Name	Description
Public method	SqlExecutionHelper

Methods

	Name	Description
Public method Static member	ExecuteWithDeadlockRetry<TResult>	Executes the given executionFunc while catching exception resulting from the execution. If the exception thrown contains SqlException as its inner exception and the Number equals to 1205 (deadlock), the execution is retried. The execution is never retried if IsInTransaction indicates the execution is part of a transaction. If the retry limit is reached, the exception resulting from the last execution is re-thrown.
Protected method	ExecuteWithDeadlockRetryInternal<TResult>	Executes the given executionFunc while catching exception resulting from the execution. If the exception thrown contains SqlException as its inner exception and the Number equals to 1205 (deadlock), the execution is retried. The execution is never retried if IsInTransaction indicates the execution is part of a transaction. If the retry limit is reached, the exception resulting from the last execution is re-thrown.
Public method	SetAsDefaultHelper	Sets this object as the default helper (Inherited from AbstractHelper<HelperType>.)