public void Delete(object id, Transaction transaction = default)
{
using (var command = CommandDefinition.GetCommand(provider: _provider, connection: _dbConnection, commandText: DynamicQuery.Delete <TEntity>(_provider, _key), key: _key.Name, id: id, transaction: transaction))
{
CommandExecuter.ExecuteNonQuery(_dbConnection, command);
}
}
public void RawNonQuery(string query, object param = default, Transaction transaction = default)
{
using (var command = CommandDefinition.GetCommand(provider: _provider, connection: _dbConnection, commandText: query, param: param, transaction: transaction))
{
CommandExecuter.ExecuteNonQuery(_dbConnection, command);
}
}
public void Update(TEntity item, Transaction transaction = default)
{
using (var command = CommandDefinition.GetCommand(provider: _provider, connection: _dbConnection))
{
var properties = CommandExecuter.GetProperticeWithAddParameters <TEntity>(_provider, _key, _keyIsAutoId, item, command);
command.CommandText = DynamicQuery.Update(_provider, _key, properties, item);
CommandExecuter.ExecuteNonQuery(_dbConnection, command);
}
}