Changeset 17928 for branches/3026_IntegrationIntoSymSpace/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDataDao.cs
- Timestamp:
- 04/06/21 13:13:32 (3 years ago)
- Location:
- branches/3026_IntegrationIntoSymSpace
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/3026_IntegrationIntoSymSpace
- Property svn:mergeinfo changed
-
branches/3026_IntegrationIntoSymSpace/HeuristicLab.Services.Hive.DataAccess
- Property svn:mergeinfo changed
/trunk/HeuristicLab.Services.Hive.DataAccess (added) merged: 17574
- Property svn:mergeinfo changed
-
branches/3026_IntegrationIntoSymSpace/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDataDao.cs
r17180 r17928 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.