Class DbObject<TEntity>
OptimaJet.Workflow.SQLite.DbObject<TEntity>
Namespace: OptimaJet.Workflow.SQLite
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(SqliteConnection connection, TEntity entity, SqliteTransaction transaction = null) #Parameters
Name
Type
Description
connectionSqliteConnectionentity{TEntity}transactionSqliteTransactionReturns
Type
Description
Task<Int32>public virtual Task<int> UpsertAsync(SqliteConnection connection, TEntity entity, SqliteTransaction transaction = null) #Parameters
Name
Type
Description
connectionSqliteConnectionentity{TEntity}transactionSqliteTransactionReturns
Type
Description
Task<Int32>public virtual Task<int> UpdateAsync(SqliteConnection connection, TEntity entity, SqliteTransaction transaction = null) #Parameters
Name
Type
Description
connectionSqliteConnectionentity{TEntity}transactionSqliteTransactionReturns
Type
Description
Task<Int32>public Task<TEntity[]> SelectAllAsync(SqliteConnection connection) #Parameters
Name
Type
Description
connectionSqliteConnectionReturns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectAllWithPagingAsync(SqliteConnection connection, List<(string parameterName, SortDirection sortDirection)> orderParameters, Paging paging) #Parameters
Name
Type
Description
connectionSqliteConnectionorderParametersList<SortDirection>pagingPagingReturns
Type
Description
Task<{TEntity}[]>public Task<TEntity> SelectByKeyAsync(SqliteConnection connection, object id) #Parameters
Name
Type
Description
connectionSqliteConnectionidObjectReturns
Type
Description
Task<TEntity>public Task<TEntity[]> SelectByAsync<TSelect>(SqliteConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value) #Parameters
Name
Type
Description
connectionSqliteConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}Returns
Type
Description
Task<{TEntity}[]>public Task<int> DeleteByAsync<TSelect>(SqliteConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, SqliteTransaction transaction = null) #Parameters
Name
Type
Description
connectionSqliteConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}transactionSqliteTransactionReturns
Type
Description
Task<Int32>public Task<TEntity[]> SelectByWithPagingAsync<TSelect, TSort>(SqliteConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, Expression<Func<TEntity, TSort>> sortLambda, SortDirection sortDirection, Paging paging) #Parameters
Name
Type
Description
connectionSqliteConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}sortLambdaExpression<Func{{TEntity},{TSort>sortDirectionSortDirectionpagingPagingReturns
Type
Description
Task<{TEntity}[]>public Task<int> DeleteAsync(SqliteConnection connection, object id, SqliteTransaction transaction = null) #Parameters
Name
Type
Description
connectionSqliteConnectionidObjecttransactionSqliteTransactionReturns
Type
Description
Task<Int32>public Task<int> GetCountAsync(SqliteConnection connection) #Parameters
Name
Type
Description
connectionSqliteConnectionReturns
Type
Description
Task<Int32>public Task<int> GetCountByAsync<TSelect>(SqliteConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, SqliteTransaction transaction = null) #Parameters
Name
Type
Description
connectionSqliteConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}transactionSqliteTransactionReturns
Type
Description
Task<Int32>public Task<int> ExecuteCommandNonQueryAsync(SqliteConnection connection, string commandText, params SqliteParameter[] parameters) #Parameters
Name
Type
Description
connectionSqliteConnectioncommandTextStringparametersSqliteParameter[]Returns
Type
Description
Task<Int32>public Task<int> ExecuteCommandNonQueryAsync(SqliteConnection connection, string commandText, SqliteTransaction transaction = null, params SqliteParameter[] parameters) #Parameters
Name
Type
Description
connectionSqliteConnectioncommandTextStringtransactionSqliteTransactionparametersSqliteParameter[]Returns
Type
Description
Task<Int32>public Task<object> ExecuteCommandScalarAsync(SqliteConnection connection, string commandText, params SqliteParameter[] parameters) #Parameters
Name
Type
Description
connectionSqliteConnectioncommandTextStringparametersSqliteParameter[]Returns
Type
Description
Task<Object>public Task<object> ExecuteCommandScalarAsync(SqliteConnection connection, string commandText, SqliteTransaction transaction = null, params SqliteParameter[] parameters) #Parameters
Name
Type
Description
connectionSqliteConnectioncommandTextStringtransactionSqliteTransactionparametersSqliteParameter[]Returns
Type
Description
Task<Object>public Task<TEntity[]> SelectAsync(SqliteConnection connection, string commandText, params SqliteParameter[] parameters) #Parameters
Name
Type
Description
connectionSqliteConnectioncommandTextStringparametersSqliteParameter[]Returns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectAsync(SqliteConnection connection, string commandText, SqliteTransaction transaction, params SqliteParameter[] parameters) #Parameters
Name
Type
Description
connectionSqliteConnectioncommandTextStringtransactionSqliteTransactionparametersSqliteParameter[]Returns
Type
Description
Task<{TEntity}[]>public Task<List<Dictionary<string, object>>> SelectAsDictionaryAsync(SqliteConnection connection, string commandText, params SqliteParameter[] parameters) #Parameters
Name
Type
Description
connectionSqliteConnectioncommandTextStringparametersSqliteParameter[]Returns
Type
Description
Task<Object>public Task<int> InsertAllAsync(SqliteConnection connection, TEntity[] values, SqliteTransaction transaction = null) #Parameters
Name
Type
Description
connectionSqliteConnectionvalues{TEntity}[]transactionSqliteTransactionReturns
Type
Description
Task<Int32>public SqliteParameter CreateParameter(TEntity entity, ColumnInfo column, string namePrefix = "") #Parameters
Name
Type
Description
entity{TEntity}columnColumnInfonamePrefixStringReturns
Type
Description
SqliteParameterprotected static object ToDbValue<TValue>(TValue value, DbType type) #Parameters
Name
Type
Description
value{TValue}typeDbTypeReturns
Type
Description
Objectprotected static object FromDbValue<TValue>(TValue dbValue, DbType type) #Parameters
Name
Type
Description
dbValue{TValue}typeDbTypeReturns
Type
Description
Objectpublic string GetKeyOrFirstColumn() #Returns
Type
Description
String