Class DbTask

Inheritance
System.Object
DbTask
Implements
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public abstract class DbTask : ControlFlowTask, ILoggableTask

Constructors

DbTask()

Declaration
    public DbTask()

DbTask(ControlFlowTask, String)

Declaration
    public DbTask(ControlFlowTask callingTask, string sql)
Parameters
TypeNameDescription
ControlFlowTaskcallingTask
System.Stringsql

DbTask(String)

Declaration
    public DbTask(string sql)
Parameters
TypeNameDescription
System.Stringsql

DbTask(String, Action, Action, Action<Object>[])

Declaration
    public DbTask(string sql, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
TypeNameDescription
System.Stringsql
System.ActionbeforeRowReadAction
System.ActionafterRowReadAction
System.Action<System.Object>[]actions

DbTask(String, Action<Object>[])

Declaration
    public DbTask(string sql, params Action<object>[] actions)
Parameters
TypeNameDescription
System.Stringsql
System.Action<System.Object>[]actions

DbTask(String, String)

Declaration
    public DbTask(string name, string sql)
Parameters
TypeNameDescription
System.Stringname
System.Stringsql

Properties

Actions

Declaration
    public List<Action<object>> Actions { get; set; }
Property Value
TypeDescription
System.Collections.Generic.List<System.Action<System.Object>>

AfterRowReadAction

Declaration
    public Action AfterRowReadAction { get; set; }
Property Value
TypeDescription
System.Action

BeforeRowReadAction

Declaration
    public Action BeforeRowReadAction { get; set; }
Property Value
TypeDescription
System.Action

Limit

Declaration
    public int Limit { get; set; }
Property Value
TypeDescription
System.Int32

Parameter

Declaration
    public IEnumerable<QueryParameter> Parameter { get; set; }
Property Value
TypeDescription
System.Collections.Generic.IEnumerable<QueryParameter>

RowsAffected

Declaration
    public int? RowsAffected { get; }
Property Value
TypeDescription
System.Nullable<System.Int32>

Sql

Declaration
    public string Sql { get; set; }
Property Value
TypeDescription
System.String

Methods

BulkDelete(ITableData)

Declaration
    public void BulkDelete(ITableData data)
Parameters
TypeNameDescription
ITableDatadata

BulkInsert(ITableData)

Declaration
    public void BulkInsert(ITableData data)
Parameters
TypeNameDescription
ITableDatadata

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

Declaration
    public void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)
Parameters
TypeNameDescription
ITableDatadata
System.Collections.Generic.ICollection<System.String>setColumnNames
System.Collections.Generic.ICollection<System.String>joinColumnNames

ExecuteNonQuery()

Declaration
    public int ExecuteNonQuery()
Returns
TypeDescription
System.Int32

ExecuteReader()

Declaration
    public void ExecuteReader()

ExecuteScalar()

Declaration
    public object ExecuteScalar()
Returns
TypeDescription
System.Object

ExecuteScalar<T>()

Declaration
    public T? ExecuteScalar<T>()
    where T : struct
Returns
TypeDescription
System.Nullable<T>
Type Parameters
NameDescription
T

ExecuteScalarAsBool()

Declaration
    public bool ExecuteScalarAsBool()
Returns
TypeDescription
System.Boolean

Implements