Class DbObject<TEntity>
OptimaJet.Workflow.Oracle.DbObject<TEntity>
Namespace: OptimaJet.Workflow.Oracle
public class DbObject<TEntity> where TEntity : IEntity, new()Inheritance
- System.Object
Constructors
public DbObject(string schemaName, string dbTableName, int commandTimeout) #Parameters
Name
Type
Description
schemaNameStringdbTableNameStringcommandTimeoutInt32Properties
Methods
public Task<int> InsertAsync(OracleConnection connection, TEntity entity, OracleTransaction transaction = null) #Parameters
Name
Type
Description
connectionOracleConnectionentity{TEntity}transactionOracleTransactionReturns
Type
Description
Task<Int32>public virtual Task<int> UpsertAsync(OracleConnection connection, TEntity entity, OracleTransaction transaction = null) #Parameters
Name
Type
Description
connectionOracleConnectionentity{TEntity}transactionOracleTransactionReturns
Type
Description
Task<Int32>public virtual Task<int> UpdateAsync(OracleConnection connection, TEntity entity, OracleTransaction transaction = null) #Parameters
Name
Type
Description
connectionOracleConnectionentity{TEntity}transactionOracleTransactionReturns
Type
Description
Task<Int32>public Task<TEntity[]> SelectAllAsync(OracleConnection connection) #Parameters
Name
Type
Description
connectionOracleConnectionReturns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectAllWithPagingAsync(OracleConnection connection, List<(string parameterName, SortDirection sortDirection)> orderParameters, Paging paging) #Parameters
Name
Type
Description
connectionOracleConnectionorderParametersList<SortDirection>pagingPagingReturns
Type
Description
Task<{TEntity}[]>public Task<int> GetCountAsync(OracleConnection connection) #Parameters
Name
Type
Description
connectionOracleConnectionReturns
Type
Description
Task<Int32>public Task<int> GetCountByAsync<TSelect>(OracleConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, OracleTransaction transaction = null) #Parameters
Name
Type
Description
connectionOracleConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}transactionOracleTransactionReturns
Type
Description
Task<Int32>public Task<TEntity[]> SelectByAsync<TSelect>(OracleConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value) #Parameters
Name
Type
Description
connectionOracleConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}Returns
Type
Description
Task<{TEntity}[]>public Task<int> DeleteByAsync<TSelect>(OracleConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, OracleTransaction transaction = null) #Parameters
Name
Type
Description
connectionOracleConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}transactionOracleTransactionReturns
Type
Description
Task<Int32>public Task<TEntity[]> SelectByWithPagingAsync<TSelect, TSort>(OracleConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, Expression<Func<TEntity, TSort>> sortLambda, SortDirection sortDirection, Paging paging) #Parameters
Name
Type
Description
connectionOracleConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}sortLambdaExpression<Func{{TEntity},{TSort>sortDirectionSortDirectionpagingPagingReturns
Type
Description
Task<{TEntity}[]>public Task<TEntity> SelectByKeyAsync(OracleConnection connection, object id) #Parameters
Name
Type
Description
connectionOracleConnectionidObjectReturns
Type
Description
Task<TEntity>public Task<int> DeleteAsync(OracleConnection connection, object id, OracleTransaction transaction = null) #Parameters
Name
Type
Description
connectionOracleConnectionidObjecttransactionOracleTransactionReturns
Type
Description
Task<Int32>public Task<int> ExecuteCommandNonQueryAsync(OracleConnection connection, string commandText, params OracleParameter[] parameters) #Parameters
Name
Type
Description
connectionOracleConnectioncommandTextStringparametersOracleParameter[]Returns
Type
Description
Task<Int32>public Task<int> ExecuteCommandNonQueryAsync(OracleConnection connection, string commandText, OracleTransaction transaction = null, params OracleParameter[] parameters) #Parameters
Name
Type
Description
connectionOracleConnectioncommandTextStringtransactionOracleTransactionparametersOracleParameter[]Returns
Type
Description
Task<Int32>public Task<object> ExecuteCommandScalarAsync(OracleConnection connection, string commandText, params OracleParameter[] parameters) #Parameters
Name
Type
Description
connectionOracleConnectioncommandTextStringparametersOracleParameter[]Returns
Type
Description
Task<Object>public Task<object> ExecuteCommandScalarAsync(OracleConnection connection, string commandText, OracleTransaction transaction, params OracleParameter[] parameters) #Parameters
Name
Type
Description
connectionOracleConnectioncommandTextStringtransactionOracleTransactionparametersOracleParameter[]Returns
Type
Description
Task<Object>public Task<TEntity[]> SelectAsync(OracleConnection connection, string commandText, params OracleParameter[] parameters) #Parameters
Name
Type
Description
connectionOracleConnectioncommandTextStringparametersOracleParameter[]Returns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectAsync(OracleConnection connection, string commandText, OracleTransaction transaction, params OracleParameter[] parameters) #Parameters
Name
Type
Description
connectionOracleConnectioncommandTextStringtransactionOracleTransactionparametersOracleParameter[]Returns
Type
Description
Task<{TEntity}[]>public Task<List<Dictionary<string, object>>> SelectAsDictionaryAsync(OracleConnection connection, string commandText, params OracleParameter[] parameters) #Parameters
Name
Type
Description
connectionOracleConnectioncommandTextStringparametersOracleParameter[]Returns
Type
Description
Task<Object>public Task<int> InsertAllAsync(OracleConnection connection, TEntity[] entities, OracleTransaction transaction = null) #Parameters
Name
Type
Description
connectionOracleConnectionentities{TEntity}[]transactionOracleTransactionReturns
Type
Description
Task<Int32>public OracleParameter CreateParameter(TEntity entity, ColumnInfo column, string namePrefix = "") #Parameters
Name
Type
Description
entity{TEntity}columnColumnInfonamePrefixStringReturns
Type
Description
OracleParameterprotected static object ToDbValue<TValue>(TValue value, OracleDbType type) #Parameters
Name
Type
Description
value{TValue}typeOracleDbTypeReturns
Type
Description
Objectprotected static object FromDbValue<TValue>(TValue dbValue, OracleDbType type) #Parameters
Name
Type
Description
dbValue{TValue}typeOracleDbTypeReturns
Type
Description
Objectpublic string GetKeyOrFirstColumn() #Returns
Type
Description
String