private static Task Handle(Message message, CancellationToken arg2) { var productionChangedString = Encoding.UTF8.GetString(message.Body); var productionChangedJson = JsonConvert.DeserializeObject <ProductionToGet>(productionChangedString); var optionsBuilder = new DbContextOptionsBuilder <StoreCatalogContext>(); var options = optionsBuilder.UseInMemoryDatabase("geekburger-storecatalog").Options; using (var db = new StoreCatalogContext(options)) { var sc = new StoreCatalogRepository(db, _configuration); sc.UpsertProduction(productionChangedJson); } return(Task.CompletedTask); }
private static Task Handle(Message message, CancellationToken arg2) { var productChangedString = Encoding.UTF8.GetString(message.Body); var parsedObject = JObject.Parse(productChangedString); var productJson = parsedObject["Product"].ToString(); var productChangesJson = JsonConvert.DeserializeObject <ProductToGet>(productJson); var optionsBuilder = new DbContextOptionsBuilder <StoreCatalogContext>(); var options = optionsBuilder.UseSqlServer("Server=tcp:geekburguer.database.windows.net,1433;Initial Catalog=GeekBurger;Persist Security Info=False;User ID=StoreCatalog;Password=qwer1234!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;").Options; using (var db = new StoreCatalogContext(options)) { var sc = new StoreCatalogRepository(db, _configuration); sc.UpsertProduct(productChangesJson); } return(Task.CompletedTask); }