This is with the specification pattern

CAncelOrderService.cs

public class CancelOrderService
{
    private IDao<Order> daoOrder;
    public CancelOrderService(IDao<Order> daoOrder)
    {
        this.daoOrder = daoOrder;
    }
    
    public void CancelLastWeekOrders()
    {
        //note that in this case the query is part of this code
        var orders = daoOrder.Retrieve(new LastWeekSpecification());
        orders.ForEach(o => o.Cancel());
    }
}

IDao.cs

public interface IDao<T>
{
    IEnumerable<T> Retrieve(Specification<T> predicate);
}

LastWeekSpecification.cs

public class LastWeekSpecification : Specification<Country>
{
    public override Expression<Func<Order, bool>> IsSatisfiedBy()
    { 
         return c => c.Date < firstDayOfCurrentWeek;
    }
}

Test.cs

       [Test]
       public void CancelAllOrdersFromLastWeek_ShouldWork()
       {
           var order1 = new Order();
           var handler = new CancelOrderService(Moc.Of<IDao<Order>>(dao => dao.Retrieve(It.IsAny<LastWeekSpecification>()) == new[]{order});
           handler.CancelAllOrdersFromLastWeek();
           order1.Status.Should().Be.EqualTo(OrderStatus.Canceled);
       }