public void DeleteAll() { using (var ctx = new TasksDbContext()) { ctx.Database.ExecuteSqlCommand("TRUNCATE TABLE [TaskEntities]"); } }
public IEnumerable <TaskEntity> GetAll() { using (var ctx = new TasksDbContext()) { return(ctx.Tasks.AsEnumerable()); } }
public void DeleteAllByType(string type) { using (var ctx = new TasksDbContext()) { ctx.Tasks.RemoveRange(ctx.Tasks); ctx.SaveChanges(); } }
public void Add(string tasktype, string details, string worker) { using (var ctx = new TasksDbContext()) { var t = new TaskEntity() { ExecutionDT = DateTime.UtcNow, TaskType = tasktype, Worker = worker, Details = details }; ctx.Tasks.Add(t); ctx.SaveChanges(); } }