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()
Namespace: ETLBox.ControlFlow
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
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#