# DbTask {{< rawhtml >}}

Class DbTask

Inheritance
object
LoggableTask
ControlFlowTask
DbTask
XmlaTask
SqlTask
SqlTask
Implements
ILoggableTask
Inherited Members
ControlFlowTask.ConnectionManager
ControlFlowTask.DbConnectionManager
ControlFlowTask.ConnectionType
ControlFlowTask.QB
ControlFlowTask.QE
LoggableTask.TaskType
LoggableTask.TaskName
LoggableTask.DisableLogging
LoggableTask.LogThreshold
LoggableTask.TaskHash
LoggableTask.LogInstance
LoggableTask.ParentTask
LoggableTask.LogTrace(string, params object[])
LoggableTask.LogDebug(string, params object[])
LoggableTask.LogInfo(string, params object[])
LoggableTask.LogInfoOrDebug(string, params object[])
LoggableTask.LogWarn(string, params object[])
LoggableTask.LogError(string, params object[])
LoggableTask.LogFatal(string, params object[])
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
{{< /rawhtml >}} ```C# public abstract class DbTask : ControlFlowTask, ILoggableTask ``` {{< rawhtml >}}

Constructors

DbTask()

Declaration
{{< /rawhtml >}} ```C# public DbTask() ``` {{< rawhtml >}}

DbTask(string)

Declaration
{{< /rawhtml >}} ```C# public DbTask(string sql) ``` {{< rawhtml >}}
Parameters
Type Name Description
string sql

DbTask(string, Action, Action, params Action<object>[])

Declaration
{{< /rawhtml >}} ```C# public DbTask(string sql, Action beforeRowReadAction, Action afterRowReadAction, params Action[] actions) ``` {{< rawhtml >}}
Parameters
Type Name Description
string sql
Action beforeRowReadAction
Action afterRowReadAction
Action<object>[] actions

DbTask(string, params Action<object>[])

Declaration
{{< /rawhtml >}} ```C# public DbTask(string sql, params Action[] actions) ``` {{< rawhtml >}}
Parameters
Type Name Description
string sql
Action<object>[] actions

DbTask(string, string)

Declaration
{{< /rawhtml >}} ```C# public DbTask(string name, string sql) ``` {{< rawhtml >}}
Parameters
Type Name Description
string name
string sql

Properties

Actions

Declaration
{{< /rawhtml >}} ```C# public ICollection> Actions { get; set; } ``` {{< rawhtml >}}
Property Value
Type Description
ICollection<Action<object>>

AfterRowReadAction

Declaration
{{< /rawhtml >}} ```C# public Action AfterRowReadAction { get; set; } ``` {{< rawhtml >}}
Property Value
Type Description
Action

BeforeRowReadAction

Declaration
{{< /rawhtml >}} ```C# public Action BeforeRowReadAction { get; set; } ``` {{< rawhtml >}}
Property Value
Type Description
Action

Limit

Declaration
{{< /rawhtml >}} ```C# public int Limit { get; set; } ``` {{< rawhtml >}}
Property Value
Type Description
int

Parameter

Declaration
{{< /rawhtml >}} ```C# public IEnumerable Parameter { get; set; } ``` {{< rawhtml >}}
Property Value
Type Description
IEnumerable<QueryParameter>

RowsAffected

Declaration
{{< /rawhtml >}} ```C# public int? RowsAffected { get; } ``` {{< rawhtml >}}
Property Value
Type Description
int?

Sql

Declaration
{{< /rawhtml >}} ```C# public string Sql { get; set; } ``` {{< rawhtml >}}
Property Value
Type Description
string

Methods

BulkDelete(ITableData)

Declaration
{{< /rawhtml >}} ```C# public void BulkDelete(ITableData data) ``` {{< rawhtml >}}
Parameters
Type Name Description
ITableData data

BulkInsert(ITableData)

Declaration
{{< /rawhtml >}} ```C# public void BulkInsert(ITableData data) ``` {{< rawhtml >}}
Parameters
Type Name Description
ITableData data

BulkSelect(ITableData, ICollection<string>)

Declaration
{{< /rawhtml >}} ```C# public void BulkSelect(ITableData data, ICollection selectColumnNames) ``` {{< rawhtml >}}
Parameters
Type Name Description
ITableData data
ICollection<string> selectColumnNames

BulkUpdate(ITableData, ICollection<string>, ICollection<string>)

Declaration
{{< /rawhtml >}} ```C# public void BulkUpdate(ITableData data, ICollection setColumnNames, ICollection joinColumnNames) ``` {{< rawhtml >}}
Parameters
Type Name Description
ITableData data
ICollection<string> setColumnNames
ICollection<string> joinColumnNames

ExecuteNonQuery()

Declaration
{{< /rawhtml >}} ```C# public int ExecuteNonQuery() ``` {{< rawhtml >}}
Returns
Type Description
int

ExecuteNonQueryAsync()

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteNonQueryAsync() ``` {{< rawhtml >}}
Returns
Type Description
Task<int>

ExecuteNonQueryAsync(CancellationToken?)

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteNonQueryAsync(CancellationToken? cancellationToken) ``` {{< rawhtml >}}
Parameters
Type Name Description
CancellationToken? cancellationToken
Returns
Type Description
Task<int>

ExecuteReader()

Declaration
{{< /rawhtml >}} ```C# public void ExecuteReader() ``` {{< rawhtml >}}

ExecuteReaderAsync()

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteReaderAsync() ``` {{< rawhtml >}}
Returns
Type Description
Task

ExecuteReaderAsync(CancellationToken?)

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteReaderAsync(CancellationToken? cancellationToken) ``` {{< rawhtml >}}
Parameters
Type Name Description
CancellationToken? cancellationToken
Returns
Type Description
Task

ExecuteScalar()

Declaration
{{< /rawhtml >}} ```C# public object ExecuteScalar() ``` {{< rawhtml >}}
Returns
Type Description
object

ExecuteScalarAsync()

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteScalarAsync() ``` {{< rawhtml >}}
Returns
Type Description
Task<object>

ExecuteScalarAsync(CancellationToken?)

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteScalarAsync(CancellationToken? cancellationToken) ``` {{< rawhtml >}}
Parameters
Type Name Description
CancellationToken? cancellationToken
Returns
Type Description
Task<object>

ExecuteScalarAsync<T>()

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteScalarAsync() ``` {{< rawhtml >}}
Returns
Type Description
Task<T>
Type Parameters
Name Description
T

ExecuteScalarAsync<T>(CancellationToken?)

Declaration
{{< /rawhtml >}} ```C# public Task ExecuteScalarAsync(CancellationToken? cancellationToken) ``` {{< rawhtml >}}
Parameters
Type Name Description
CancellationToken? cancellationToken
Returns
Type Description
Task<T>
Type Parameters
Name Description
T

ExecuteScalar<T>()

Declaration
{{< /rawhtml >}} ```C# public T ExecuteScalar() ``` {{< rawhtml >}}
Returns
Type Description
T
Type Parameters
Name Description
T

LogErrorsAndClose(string, Action<IConnectionManager>)

Declaration
{{< /rawhtml >}} ```C# public void LogErrorsAndClose(string sqlOperationType, Action syncAction = null) ``` {{< rawhtml >}}
Parameters
Type Name Description
string sqlOperationType
Action<IConnectionManager> syncAction

LogErrorsAndCloseAsync(string, CancellationToken?, Func<IConnectionManager, Task>)

Declaration
{{< /rawhtml >}} ```C# public Task LogErrorsAndCloseAsync(string sqlOperationType, CancellationToken? cancellationToken = null, Func asyncAction = null) ``` {{< rawhtml >}}
Parameters
Type Name Description
string sqlOperationType
CancellationToken? cancellationToken
Func<IConnectionManager, Task> asyncAction
Returns
Type Description
Task

LogErrorsAndCloseCoreAsync(string, CancellationToken?, Action<IConnectionManager>, Func<IConnectionManager, Task>, bool)

Declaration
{{< /rawhtml >}} ```C# public Task LogErrorsAndCloseCoreAsync(string sqlOperationType, CancellationToken? cancellationToken = null, Action syncAction = null, Func asyncAction = null, bool sync = false) ``` {{< rawhtml >}}
Parameters
Type Name Description
string sqlOperationType
CancellationToken? cancellationToken
Action<IConnectionManager> syncAction
Func<IConnectionManager, Task> asyncAction
bool sync
Returns
Type Description
Task

Implements

{{< /rawhtml >}}