public async Task UpdateLanguage() { var words = dbSqliteContext.Words; //foreach (var w in words.Where(w => w.LangId == 90 && w.IsNumber == true).ToArray()) //{ // w.LangId = 19; // dbSqliteContext.Words.Update(w); //} foreach (var w in words.Where(w => w.LangId == 19 && w.IsNumber == false).ToArray()) { w.LangId = 19; var key = new WordLanguageKey(w.word, w.LangId); if (w.hash != key.GetHashCode()) { w.hash = key.GetHashCode(); try { dbSqliteContext.Words.Update(w); await dbSqliteContext.SaveChangesAsync(); } catch (DbUpdateException ex) { Trace.TraceError(ex.Message); } } } await dbSqliteContext.SaveChangesAsync(); }
public async Task UpdateHash() { var words = dbSqlContext.Words; foreach (var word in words.Where(w => w.IsNumber == false)) { var hash = new WordLanguageKey(word.word, word.LangId).GetHashCode(); if (word.hash != hash) { word.hash = hash; dbSqlContext.Words.Update(word); } } await dbSqlContext.SaveChangesAsync(); return; words = dbSqliteContext.Words; var t = 0; foreach (var word in words.Where(w => !w.IsNumber)) { if (word.hash == null) { word.hash = new WordLanguageKey(word.word, word.LangId).GetHashCode(); dbSqliteContext.Words.Update(word); try { await dbSqliteContext.SaveChangesAsync(); } catch (DbUpdateException) { var x = 0; } } // if (t % 10 == 0) t++; } dbSqliteContext.SaveChanges(); }