public void ReleaseScheduleEnqueueingLock(long scheduleId, IDbTransaction transaction) { const string Sql = @"UPDATE [BlueCollarSchedule] SET [Enqueueing] = @Enqueueing, [EnqueueingUpdatedOn] = @EnqueueingUpdatedOn WHERE [Id] = @Id;"; this.connection.Execute( Sql, new { Id = scheduleId, Enqueueing = false, EnqueueingUpdatedOn = DateTime.UtcNow }, transaction, null, null); }