Vendr extension to get all orders for a customer

OrderServiceExtensions.cs

using System;
using System.Collections.Generic;
using System.Linq;
using Vendr.Core;
using Vendr.Core.Api;
using Vendr.Core.Models;
using Vendr.Core.Services;

namespace VendrExt
{
    public static class OrderServiceExtensions
    {
        public static IEnumerable<OrderReadOnly> GetAllOrdersForCustomer(this IOrderService orderService, Guid storeId, string customerReference)
        {
            var orders = new List<OrderReadOnly>();

            try
            {
                using (var uow = VendrApi.Instance.Uow.Create() as IDatabaseUnitOfWork)
                {
                    var orderIds = uow.Database.Fetch<Guid>($"SELECT id FROM {Constants.DatabaseSchema.Tables.Order} WHERE storeId = @0 AND customerReference = @1", storeId, customerReference);

                    orders = orderService.GetOrders(orderIds.ToArray()).ToList();

                    uow.Complete();
                }
            }
            catch (Exception ex)
            {
                VendrApi.Instance.Log.Error<IOrderService>(ex, "Error fetching all orders for customer {CustomerReference}", customerReference);
            }

            return orders;
        }
    }
}