Title here
Summary here
public abstract class DbTask : ControlFlowTask, ILoggableTask public DbTask() public DbTask(string sql)| Type | Name | Description |
|---|---|---|
| string | sql |
public DbTask(string sql, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)| Type | Name | Description |
|---|---|---|
| string | sql | |
| Action | beforeRowReadAction | |
| Action | afterRowReadAction | |
| Action<object>[] | actions |
public DbTask(string sql, params Action<object>[] actions)| Type | Name | Description |
|---|---|---|
| string | sql | |
| Action<object>[] | actions |
public DbTask(string name, string sql)| Type | Name | Description |
|---|---|---|
| string | name | |
| string | sql |
public ICollection<Action<object>> Actions { get; set; }| Type | Description |
|---|---|
| ICollection<Action<object>> |
public Action AfterRowReadAction { get; set; }| Type | Description |
|---|---|
| Action |
public Action BeforeRowReadAction { get; set; }| Type | Description |
|---|---|
| Action |
public int Limit { get; set; }| Type | Description |
|---|---|
| int |
public IEnumerable<QueryParameter> Parameter { get; set; }| Type | Description |
|---|---|
| IEnumerable<QueryParameter> |
public int? RowsAffected { get; }| Type | Description |
|---|---|
| int? |
public string Sql { get; set; }| Type | Description |
|---|---|
| string |
public void BulkDelete(ITableData data)| Type | Name | Description |
|---|---|---|
| ITableData | data |
public void BulkInsert(ITableData data)| Type | Name | Description |
|---|---|---|
| ITableData | data |
public void BulkSelect(ITableData data, ICollection<string> selectColumnNames)| Type | Name | Description |
|---|---|---|
| ITableData | data | |
| ICollection<string> | selectColumnNames |
public void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)| Type | Name | Description |
|---|---|---|
| ITableData | data | |
| ICollection<string> | setColumnNames | |
| ICollection<string> | joinColumnNames |
public int ExecuteNonQuery()| Type | Description |
|---|---|
| int |
public Task<int> ExecuteNonQueryAsync()| Type | Description |
|---|---|
| Task<int> |
public Task<int> ExecuteNonQueryAsync(CancellationToken? cancellationToken)| Type | Name | Description |
|---|---|---|
| CancellationToken? | cancellationToken |
| Type | Description |
|---|---|
| Task<int> |
public void ExecuteReader() public Task ExecuteReaderAsync()| Type | Description |
|---|---|
| Task |
public Task ExecuteReaderAsync(CancellationToken? cancellationToken)| Type | Name | Description |
|---|---|---|
| CancellationToken? | cancellationToken |
| Type | Description |
|---|---|
| Task |
public object ExecuteScalar()| Type | Description |
|---|---|
| object |
public Task<object> ExecuteScalarAsync()| Type | Description |
|---|---|
| Task<object> |
public Task<object> ExecuteScalarAsync(CancellationToken? cancellationToken)| Type | Name | Description |
|---|---|---|
| CancellationToken? | cancellationToken |
| Type | Description |
|---|---|
| Task<object> |
public Task<T> ExecuteScalarAsync<T>()| Type | Description |
|---|---|
| Task<T> |
| Name | Description |
|---|---|
| T |
public Task<T> ExecuteScalarAsync<T>(CancellationToken? cancellationToken)| Type | Name | Description |
|---|---|---|
| CancellationToken? | cancellationToken |
| Type | Description |
|---|---|
| Task<T> |
| Name | Description |
|---|---|
| T |
public T ExecuteScalar<T>()| Type | Description |
|---|---|
| T |
| Name | Description |
|---|---|
| T |
public void LogErrorsAndClose(string sqlOperationType, Action<IConnectionManager> syncAction = null)| Type | Name | Description |
|---|---|---|
| string | sqlOperationType | |
| Action<IConnectionManager> | syncAction |
public Task LogErrorsAndCloseAsync(string sqlOperationType, CancellationToken? cancellationToken = null, Func<IConnectionManager, Task> asyncAction = null)| Type | Name | Description |
|---|---|---|
| string | sqlOperationType | |
| CancellationToken? | cancellationToken | |
| Func<IConnectionManager, Task> | asyncAction |
| Type | Description |
|---|---|
| Task |
public Task LogErrorsAndCloseCoreAsync(string sqlOperationType, CancellationToken? cancellationToken = null, Action<IConnectionManager> syncAction = null, Func<IConnectionManager, Task> asyncAction = null, bool sync = false)| Type | Name | Description |
|---|---|---|
| string | sqlOperationType | |
| CancellationToken? | cancellationToken | |
| Action<IConnectionManager> | syncAction | |
| Func<IConnectionManager, Task> | asyncAction | |
| bool | sync |
| Type | Description |
|---|---|
| Task |