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 |