Class DbTask
Inheritance
System.Object
DbTask
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()
Assembly: ETLBox.dll
Syntax
public abstract class DbTask : ControlFlowTask, ILoggableTask
Constructors
DbTask()
Declaration
DbTask(ControlFlowTask, String)
Declaration
public DbTask(ControlFlowTask callingTask, string sql)
Parameters
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 |
|
Limit
Declaration
public int Limit { get; set; }
Property Value
Type |
Description |
System.Int32 |
|
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 |
|
Methods
BulkDelete(ITableData)
Declaration
public void BulkDelete(ITableData data)
Parameters
BulkInsert(ITableData)
Declaration
public void BulkInsert(ITableData data)
Parameters
BulkUpdate(ITableData, ICollection<String>, ICollection<String>)
Declaration
public void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)
Parameters
Type |
Name |
Description |
ITableData |
data |
|
System.Collections.Generic.ICollection<System.String> |
setColumnNames |
|
System.Collections.Generic.ICollection<System.String> |
joinColumnNames |
|
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
ExecuteScalarAsBool()
Declaration
public bool ExecuteScalarAsBool()
Returns
Type |
Description |
System.Boolean |
|
Implements