public async static Task UpdateProductProcessTaskAsync([QueueTrigger("product")] ProductMessage message) { var builder = new ConfigurationBuilder(); builder.Add(new JsonConfigurationSource("config.json")); var config = builder.Build(); var connectionString = config["Data:DefaultConnection:ConnectionString"]; using (var context = new PartsUnlimitedContext(connectionString)) { var dbProductList = await context.Products.ToListAsync(); foreach (var queueProduct in message.ProductList) { var dbProduct = dbProductList.SingleOrDefault(x => x.SkuNumber == queueProduct.SkuNumber); if (dbProduct != null) { dbProduct.Inventory = queueProduct.Inventory; dbProduct.LeadTime = queueProduct.LeadTime; } } await context.SaveChangesAsync(CancellationToken.None); } }
public async static Task UpdateProductProcessTaskAsync([QueueTrigger("product")] ProductMessage message) { using (var context = new PartsUnlimitedContext()) { var dbProductList = await context.Products.ToListAsync(); foreach (var queueProduct in message.ProductList) { var dbProduct = dbProductList.SingleOrDefault(x => x.SkuNumber == queueProduct.SkuNumber); if (dbProduct != null) { dbProduct.Inventory = queueProduct.Inventory; dbProduct.LeadTime = queueProduct.LeadTime; } } await context.SaveChangesAsync(CancellationToken.None); } }