# Class DbObject<TEntity>

OptimaJet.Workflow.MySQL.DbObject<TEntity>

Namespace: [OptimaJet.Workflow.MySQL](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/)

```csharp
public class DbObject<TEntity> where TEntity : IEntity, new()
```

## Type Hierarchy

-   DbObject<TEntity> Current type
    -   [ProcessInstanceTree](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/ProcessInstanceTree/)
    -   [WorkflowApprovalHistory](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowApprovalHistory/)
    -   [WorkflowForm](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL.Models/WorkflowForm/)
    -   [WorkflowGlobalParameter](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowGlobalParameter/)
    -   [WorkflowInbox](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowInbox/)
    -   [WorkflowProcessInstance](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowProcessInstance/)
    -   [WorkflowProcessInstancePersistence](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowProcessInstancePersistence/)
    -   [WorkflowProcessInstanceStatus](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowProcessInstanceStatus/)
    -   [WorkflowProcessScheme](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowProcessScheme/)
    -   [WorkflowProcessTimer](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowProcessTimer/)
    -   [WorkflowProcessTransitionHistory](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowProcessTransitionHistory/)
    -   [WorkflowRuntime](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL.Models/WorkflowRuntime/)
    -   [WorkflowScheme](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/WorkflowScheme/)
    -   [WorkflowSync](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL.Models/WorkflowSync/)

## Constructors

`public DbObject(string dbTableName, int commandTimeout)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `dbTableName` | `String` |  |
| `commandTimeout` | `Int32` |  |

## Properties

`public int CommandTimeout { get; }` 

`public string DbTableName { get; }` 

## Methods

`public virtual Task<int> InsertAsync(MySqlConnection connection, TEntity entity, MySqlTransaction transaction = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `entity` | `{TEntity}` |  |
| `transaction` | `MySqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public virtual Task<int> UpsertAsync(MySqlConnection connection, TEntity entity, MySqlTransaction transaction = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `entity` | `{TEntity}` |  |
| `transaction` | `MySqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public virtual Task<int> UpdateAsync(MySqlConnection connection, TEntity entity, MySqlTransaction transaction = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `entity` | `{TEntity}` |  |
| `transaction` | `MySqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public Task<TEntity[]> SelectAllAsync(MySqlConnection connection)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<TEntity[]>` |  |

`public Task<TEntity[]> SelectAllWithPagingAsync(MySqlConnection connection, List<(string parameterName, SortDirection sortDirection)> orderParameters, Paging paging)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `orderParameters` | `List<String, SortDirection>` |  |
| `paging` | `Paging` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<TEntity[]>` |  |

`public Task<TEntity[]> SelectByAsync<TSelect>(MySqlConnection connection, Expression<Func<TEntity, TSelect>> selectorLambda, TSelect value)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `selectorLambda` | `Expression<FuncTEntity, 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 |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `selectorLambda` | `Expression<FuncTEntity, TSelect>` |  |
| `value` | `{TSelect}` |  |
| `sortLambda` | `Expression<FuncTEntity, TSort>` |  |
| `sortDirection` | `SortDirection` |  |
| `paging` | `Paging` |  |

### Returns

| 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 |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `selectorLambda` | `Expression<FuncTEntity, TSelect>` |  |
| `value` | `{TSelect}` |  |
| `transaction` | `MySqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public Task<TEntity> SelectByKeyAsync(MySqlConnection connection, object id)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `id` | `Object` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<TEntity>` |  |

`public Task<int> DeleteAsync(MySqlConnection connection, object id, MySqlTransaction transaction = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `id` | `Object` |  |
| `transaction` | `MySqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public Task<int> GetCountAsync(MySqlConnection connection)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |

### Returns

| 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 |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `selectorLambda` | `Expression<FuncTEntity, TSelect>` |  |
| `value` | `{TSelect}` |  |
| `transaction` | `MySqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public Task<int> ExecuteCommandNonQueryAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `commandText` | `String` |  |
| `parameters` | `MySqlParameter[]` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public Task<int> ExecuteCommandNonQueryAsync(MySqlConnection connection, string commandText, MySqlTransaction transaction = null, params MySqlParameter[] parameters)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `commandText` | `String` |  |
| `transaction` | `MySqlTransaction` |  |
| `parameters` | `MySqlParameter[]` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public Task<object> ExecuteCommandScalarAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `commandText` | `String` |  |
| `parameters` | `MySqlParameter[]` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Object>` |  |

`public Task<object> ExecuteCommandScalarAsync(MySqlConnection connection, string commandText, MySqlTransaction transaction = null, params MySqlParameter[] parameters)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `commandText` | `String` |  |
| `transaction` | `MySqlTransaction` |  |
| `parameters` | `MySqlParameter[]` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Object>` |  |

`public Task<TEntity[]> SelectAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `commandText` | `String` |  |
| `parameters` | `MySqlParameter[]` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<TEntity[]>` |  |

`public Task<TEntity[]> SelectAsync(MySqlConnection connection, string commandText, MySqlTransaction transaction, params MySqlParameter[] parameters)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `commandText` | `String` |  |
| `transaction` | `MySqlTransaction` |  |
| `parameters` | `MySqlParameter[]` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<TEntity[]>` |  |

`public Task<List<Dictionary<string, object>>> SelectAsDictionaryAsync(MySqlConnection connection, string commandText, params MySqlParameter[] parameters)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `commandText` | `String` |  |
| `parameters` | `MySqlParameter[]` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<String, Object>` |  |

`public Task<int> InsertAllAsync(MySqlConnection connection, TEntity[] values, MySqlTransaction transaction = null)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `MySqlConnection` |  |
| `values` | `{TEntity}[]` |  |
| `transaction` | `MySqlTransaction` |  |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` |  |

`public virtual MySqlParameter CreateParameter(TEntity entity, ColumnInfo c, string namePrefix = "")` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `entity` | `{TEntity}` |  |
| `c` | `ColumnInfo` |  |
| `namePrefix` | `String` |  |

### Returns

| Type | Description |
| --- | --- |
| `MySqlParameter` |  |

`protected static object ToDbValue<TValue>(TValue value, MySqlDbType type)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `value` | `{TValue}` |  |
| `type` | `MySqlDbType` |  |

### Returns

| Type | Description |
| --- | --- |
| `Object` |  |

`protected static object FromDbValue<TValue>(TValue dbValue, MySqlDbType type)` 

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `dbValue` | `{TValue}` |  |
| `type` | `MySqlDbType` |  |

### Returns

| Type | Description |
| --- | --- |
| `Object` |  |

`public string GetKeyOrFirstColumn()` 

### Returns

| Type | Description |
| --- | --- |
| `String` |  |

## Fields

`public static List<ColumnInfo> DBColumnsStatic` 

`public List<ColumnInfo> DBColumns` 

[Previous ColumnInfo](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/ColumnInfo/) [Next MySQLProvider](https://api.workflowengine.io/mysql/OptimaJet.Workflow.MySQL/MySQLProvider/)