public IEnumerable <TEntity> RawQuery <TEntity>(string query, object param = default, Transaction transaction = default) where TEntity : class
{
using (var command = CommandDefinition.GetCommand(provider: _provider, connection: _dbConnection, commandText: query, param: param, transaction: transaction))
{
return(CommandExecuter.ExecuteQuery <TEntity>(_dbConnection, command));
}
}
public TEntity Find(object id, Transaction transaction = default)
{
using (var command = CommandDefinition.GetCommand(provider: _provider, connection: _dbConnection, commandText: DynamicQuery.Find <TEntity>(_provider, _key), key: _key.Name, id: id, transaction: transaction))
{
return(CommandExecuter.ExecuteQuery <TEntity>(_dbConnection, command).FirstOrDefault());
}
}
public IEnumerable <TEntity> Where(string whereCondition, object param = default, Transaction transaction = default)
{
using (var command = CommandDefinition.GetCommand(provider: _provider, connection: _dbConnection, commandText: DynamicQuery.Where <TEntity>(_provider, whereCondition), param: param, transaction: transaction))
{
return(CommandExecuter.ExecuteQuery <TEntity>(_dbConnection, command));
}
}
public IEnumerable <TEntity> All(Transaction transaction = default)
{
using (var command = CommandDefinition.GetCommand(provider: _provider, connection: _dbConnection, commandText: DynamicQuery.All <TEntity>(_provider), transaction: transaction))
{
return(CommandExecuter.ExecuteQuery <TEntity>(_dbConnection, command));
}
}