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); }