public void Delete(int id)
{
T entity = SqlMapperExtensions.Get <T>(_connection, id);
if (entity != null)
{
SqlMapperExtensions.Delete(_connection, entity);
}
}
public void Delete(int id)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var res = SqlMapperExtensions.Get <TaskItem>(db, id);
if (res != null)
{
SqlMapperExtensions.Delete(db, res);
}
}
}
private void ProcessQueue()
{
while (!DataService.DataQueue.IsEmpty)
{
if (!DataService.DataQueue.TryDequeue(out DatabaseAction request))
{
Console.WriteLine("DATABASE WORKER: Was unable to process an object. Will try again...");
return;
}
try
{
if (request.Action == DatabaseActionType.Insert)
{
foreach (var record in request.Data)
{
SqlMapperExtensions.Insert(_connection, record);
}
}
else if (request.Action == DatabaseActionType.Update)
{
foreach (var record in request.Data)
{
SqlMapperExtensions.Update(_connection, record);
}
}
else if (request.Action == DatabaseActionType.Delete)
{
foreach (var record in request.Data)
{
SqlMapperExtensions.Delete(_connection, record);
}
}
}
catch (MySqlException ex)
{
Console.WriteLine("****EXCEPTION ON DATABASE BACKGROUND THREAD****");
Console.WriteLine("Data Type: " + request.DataType);
Console.WriteLine("Action: " + request.Action);
LoggingService.LogError(ex, request.Action.ToString());
}
catch (Exception ex)
{
Console.WriteLine("****EXCEPTION ON DATABASE BACKGROUND THREAD****");
Console.WriteLine("Data Type: " + request.DataType);
Console.WriteLine("Action: " + request.Action);
LoggingService.LogError(ex, request.Action.ToString());
}
}
}
public bool Delete(TEntity entity)
{
using (var sqlConnection = new SqlConnection(DbConstant.DatabaseConnection))
return(SqlMapperExtensions.Delete(sqlConnection, entity));
}
public bool Delete(IEnumerable <TEntity> entities)
{
return(SqlMapperExtensions.Delete(_connection, entities, _transaction, _commandTimeout));
}
public bool Delete(TEntity entityToDelete)
{
return(SqlMapperExtensions.Delete(_connection, entityToDelete, _transaction, _commandTimeout));
}
public bool Delete(TEntity entity)
{
var deleted = SqlMapperExtensions.Delete <TEntity>(connection.Connect, entity);
return(deleted);
}
