# Class WorkflowSync

OptimaJet.Workflow.MSSQL.Models.WorkflowSync

Namespace: [OptimaJet.Workflow.MSSQL.Models](https://api.workflowengine.io/sql-server/OptimaJet.Workflow.MSSQL.Models/)

```csharp
public class WorkflowSync : DbObject<SyncEntity>
```

## Type Hierarchy

-   [DbObject<SyncEntity>](https://api.workflowengine.io/sql-server/OptimaJet.Workflow.DbPersistence/DbObject-TEntity/)
    -   WorkflowSync Current type

## Constructors

`public WorkflowSync(string schemaName, int commandTimeout)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `schemaName` | `String` |  |
| `commandTimeout` | `Int32` |  |

## Methods

`public Task<SyncEntity> GetByNameAsync(SqlConnection connection, string name)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqlConnection` |  |
| `name` | `String` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<SyncEntity>` |  |

`public Task<int> UpdateLockAsync(SqlConnection connection, string name, Guid newLock, Guid oldLock, SqlTransaction transaction = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqlConnection` |  |
| `name` | `String` |  |
| `newLock` | `Guid` |  |
| `oldLock` | `Guid` |  |
| `transaction` | `SqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

[Previous WorkflowRuntime](https://api.workflowengine.io/sql-server/OptimaJet.Workflow.MSSQL.Models/WorkflowRuntime/)