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();
}
