Class DbTask

Inheritance
System.Object
LoggableTask
ControlFlowTask
DbTask
SqlTask
XmlaTask
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
Type Name Description
ControlFlowTask callingTask
System.String sql

DbTask(String)

Declaration
public DbTask(string sql)
Parameters
Type Name Description
System.String sql

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

Declaration
public DbTask(string sql, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
Type Name Description
System.String sql
System.Action beforeRowReadAction
System.Action afterRowReadAction
System.Action<System.Object>[] actions

DbTask(String, Action<Object>[])

Declaration
public DbTask(string sql, params Action<object>[] actions)
Parameters
Type Name Description
System.String sql
System.Action<System.Object>[] actions

DbTask(String, String)

Declaration
public DbTask(string name, string sql)
Parameters
Type Name Description
System.String name
System.String sql

Properties

Actions

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

AfterRowReadAction

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

BeforeRowReadAction

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

Command

Declaration
public string Command { get; }
Property Value
Type Description
System.String

DoXMLCommentStyle

Declaration
public virtual bool DoXMLCommentStyle { get; set; }
Property Value
Type Description
System.Boolean

IsOdbcConnection

Declaration
public bool IsOdbcConnection { get; }
Property Value
Type Description
System.Boolean

Limit

Declaration
public long Limit { get; set; }
Property Value
Type Description
System.Int64

Parameter

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

RowsAffected

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

Sql

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

Transaction

Declaration
public IDbTransaction Transaction { get; set; }
Property Value
Type Description
System.Data.IDbTransaction

Methods

BulkInsert(ITableData, String)

Declaration
public void BulkInsert(ITableData data, string tableName)
Parameters
Type Name Description
ITableData data
System.String tableName

ExecuteNonQuery()

Declaration
public int ExecuteNonQuery()
Returns
Type Description
System.Int32

ExecuteReader()

Declaration
public void ExecuteReader()

ExecuteScalar()

Declaration
public object ExecuteScalar()
Returns
Type Description
System.Object

ExecuteScalar<T>()

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

ExecuteScalarAsBool()

Declaration
public bool ExecuteScalarAsBool()
Returns
Type Description
System.Boolean

Implements