Changeset 17586 for branches/2521_ProblemRefactoring/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDataDao.cs
- Timestamp:
- 06/04/20 15:55:13 (4 years ago)
- Location:
- branches/2521_ProblemRefactoring
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2521_ProblemRefactoring
- Property svn:mergeinfo changed
/trunk merged: 17574-17576,17579-17581,17583-17585
- Property svn:mergeinfo changed
-
branches/2521_ProblemRefactoring/HeuristicLab.Services.Hive.DataAccess
- Property svn:mergeinfo changed
/trunk/HeuristicLab.Services.Hive.DataAccess merged: 17574
- Property svn:mergeinfo changed
-
branches/2521_ProblemRefactoring/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDataDao.cs
r17226 r17586 32 32 } 33 33 34 public int DeleteObsolete(int batchSize) { 35 return DataContext.ExecuteCommand(DeleteObsoleteQueryString, batchSize); 36 } 37 34 38 #region Compiled queries 35 39 private static readonly Func<DataContext, Guid, TaskData> GetByIdQuery = … … 39 43 select taskData).SingleOrDefault()); 40 44 #endregion 45 46 #region String queries 47 private const string DeleteObsoleteQueryString = @" 48 delete top ({0}) td 49 from taskdata td 50 join task t on t.taskid = td.taskid 51 join job j on j.jobid = t.jobid 52 where j.jobstate = 'deletionpending' 53 "; 54 #endregion 41 55 } 42 56 }
Note: See TracChangeset
for help on using the changeset viewer.