Class DbObject<TEntity>
OptimaJet.Workflow.MySQL.DbObject<TEntity>
Namespace: OptimaJet.Workflow.MySQL
public class DbObject<TEntity> where TEntity : IEntity, new()Inheritance
- System.Object
Constructors
public DbObject(string dbTableName, int commandTimeout) #Parameters
Name
Type
Description
dbTableNameStringcommandTimeoutInt32Properties
Methods
public virtual Task<int> InsertAsync(MySqlConnection connection, TEntity entity, MySqlTransaction transaction = null) #Parameters
Name
Type
Description
connectionMySqlConnectionentity{TEntity}transactionMySqlTransactionReturns
Type
Description
Task<Int32>public virtual Task<int> UpsertAsync(MySqlConnection connection, TEntity entity, MySqlTransaction transaction = null) #Parameters
Name
Type
Description
connectionMySqlConnectionentity{TEntity}transactionMySqlTransactionReturns
Type
Description
Task<Int32>public virtual Task<int> UpdateAsync(MySqlConnection connection, TEntity entity, MySqlTransaction transaction = null) #Parameters
Name
Type
Description
connectionMySqlConnectionentity{TEntity}transactionMySqlTransactionReturns
Type
Description
Task<Int32>public Task<TEntity[]> SelectAllAsync(MySqlConnection connection) #Parameters
Name
Type
Description
connectionMySqlConnectionReturns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectAllWithPagingAsync(MySqlConnection connection, List<(string parameterName, SortDirection sortDirection)> orderParameters, Paging paging) #Parameters
Name
Type
Description
connectionMySqlConnectionorderParametersList<SortDirection>pagingPagingReturns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectByAsync<TSelect>(MySqlConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value) #Parameters
Name
Type
Description
connectionMySqlConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}Returns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectByWithPagingAsync<TSelect, TSort>(MySqlConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, Expression<Func<TEntity, TSort>> sortLambda, SortDirection sortDirection, Paging paging) #Parameters
Name
Type
Description
connectionMySqlConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}sortLambdaExpression<Func{{TEntity},{TSort>sortDirectionSortDirectionpagingPagingReturns
Type
Description
Task<{TEntity}[]>public Task<int> DeleteByAsync<TSelect>(MySqlConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, MySqlTransaction transaction = null) #Parameters
Name
Type
Description
connectionMySqlConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}transactionMySqlTransactionReturns
Type
Description
Task<Int32>public Task<TEntity> SelectByKeyAsync(MySqlConnection connection, object id) #Parameters
Name
Type
Description
connectionMySqlConnectionidObjectReturns
Type
Description
Task<TEntity>public Task<int> DeleteAsync(MySqlConnection connection, object id, MySqlTransaction transaction = null) #Parameters
Name
Type
Description
connectionMySqlConnectionidObjecttransactionMySqlTransactionReturns
Type
Description
Task<Int32>public Task<int> GetCountAsync(MySqlConnection connection) #Parameters
Name
Type
Description
connectionMySqlConnectionReturns
Type
Description
Task<Int32>public Task<int> GetCountByAsync<TSelect>(MySqlConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value, MySqlTransaction transaction = null) #Parameters
Name
Type
Description
connectionMySqlConnectionselectorLambdaExpression<Func{{TEntity},{TSelect>value{TSelect}transactionMySqlTransactionReturns
Type
Description
Task<Int32>public Task<int> ExecuteCommandNonQueryAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters) #Parameters
Name
Type
Description
connectionMySqlConnectioncommandTextStringparametersMySqlParameter[]Returns
Type
Description
Task<Int32>public Task<int> ExecuteCommandNonQueryAsync(MySqlConnection connection, string commandText, MySqlTransaction transaction = null, params MySqlParameter[] parameters) #Parameters
Name
Type
Description
connectionMySqlConnectioncommandTextStringtransactionMySqlTransactionparametersMySqlParameter[]Returns
Type
Description
Task<Int32>public Task<object> ExecuteCommandScalarAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters) #Parameters
Name
Type
Description
connectionMySqlConnectioncommandTextStringparametersMySqlParameter[]Returns
Type
Description
Task<Object>public Task<object> ExecuteCommandScalarAsync(MySqlConnection connection, string commandText, MySqlTransaction transaction = null, params MySqlParameter[] parameters) #Parameters
Name
Type
Description
connectionMySqlConnectioncommandTextStringtransactionMySqlTransactionparametersMySqlParameter[]Returns
Type
Description
Task<Object>public Task<TEntity[]> SelectAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters) #Parameters
Name
Type
Description
connectionMySqlConnectioncommandTextStringparametersMySqlParameter[]Returns
Type
Description
Task<{TEntity}[]>public Task<TEntity[]> SelectAsync(MySqlConnection connection, string commandText, MySqlTransaction transaction, params MySqlParameter[] parameters) #Parameters
Name
Type
Description
connectionMySqlConnectioncommandTextStringtransactionMySqlTransactionparametersMySqlParameter[]Returns
Type
Description
Task<{TEntity}[]>public Task<List<Dictionary<string, object>>> SelectAsDictionaryAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters) #Parameters
Name
Type
Description
connectionMySqlConnectioncommandTextStringparametersMySqlParameter[]Returns
Type
Description
Task<Object>public Task<int> InsertAllAsync(MySqlConnection connection, TEntity[] values, MySqlTransaction transaction = null) #Parameters
Name
Type
Description
connectionMySqlConnectionvalues{TEntity}[]transactionMySqlTransactionReturns
Type
Description
Task<Int32>public virtual MySqlParameter CreateParameter(TEntity entity, ColumnInfo c, string namePrefix = "") #Parameters
Name
Type
Description
entity{TEntity}cColumnInfonamePrefixStringReturns
Type
Description
MySqlParameterprotected static object ToDbValue<TValue>(TValue value, MySqlDbType type) #Parameters
Name
Type
Description
value{TValue}typeMySqlDbTypeReturns
Type
Description
Objectprotected static object FromDbValue<TValue>(TValue dbValue, MySqlDbType type) #Parameters
Name
Type
Description
dbValue{TValue}typeMySqlDbTypeReturns
Type
Description
Objectpublic string GetKeyOrFirstColumn() #Returns
Type
Description
String