public static IActionResult ListProducts(
            [HttpTrigger(AuthorizationLevel.Function, "GET", Route = "products")]
            HttpRequest req,
            [Inject]
            CWDBContext dbContext,
            ILogger log)
        {
            log.LogInformation("###ListProducts trigger function processed a request.");

            var products = dbContext.Products.Select(p => new 
            {
                productId = p.ProductId,
                name = p.Name
            }).ToList();

            return new OkObjectResult(products);
        }
        public static IActionResult GetProduct(
            [HttpTrigger(AuthorizationLevel.Function, "GET", Route = "products/{id}")]
            HttpRequest req,
            [Inject]
            CWDBContext dbContext,
            long id,
            ILogger log)
        {
            log.LogInformation("###GetProduct function processed a request.");

            var product = dbContext.Products.Where(p => p.ProductId == id).FirstOrDefault();

            if(product == null)
            {
                return new NotFoundResult();
            }

            return new OkObjectResult(product);
        }