private static void UpdateDbWithNewCoin() { using (MySqlConnection connection = new MySqlConnection(Properties.Settings.Default.DefaultConnection)) { try { AppDbContext myContext = new AppDbContext(connection, false); Database.SetInitializer <AppDbContext>(null); //List of coins saved in db List <KuCoin> dbKuCoinList = myContext.KuCoin.ToList(); List <binance> dbBinanceList = myContext.Binance.ToList(); //List of coins from ZuCoin and BinanceCoin API List <KuCoinCoin> kuCoinList = KucoinApi.GetZuCoinCoin(uriKucoin); List <BinanceCoin> bianceCoinList = BinanceApi.GetData(uriBinance); //Update KuCoin table foreach (var token in kuCoinList) { if (dbKuCoinList.Where(p => p.kuCoinCoin == token.Coin).Select(p => p.Id).FirstOrDefault() == 0) { myContext.KuCoin.Add(new Model.KuCoin() { kuCoinName = token.Name, kuCoinCoin = token.Coin, DateAdded = DateTime.Now }); } } //Update Binance table foreach (var token in bianceCoinList) { if (dbBinanceList.Where(p => p.binanceSymbol == token.Symbol).Select(p => p.Id).FirstOrDefault() == 0) { myContext.Binance.Add(new binance() { binanceSymbol = token.Symbol, binanceBaseAsset = token.BaseAsset, binanceQuoteAsset = token.QuoteAsset, DateAdded = DateTime.Now }); } } myContext.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }; }