public async Task <bool> SaveAsync(DynamicDictionary dictionary, DynamicDictionarySaveMotive motive) { var connection = new SQLiteAsyncConnection(DataBasePath); await connection.CreateTableAsync <DynamicDictionaryStorageModel>(); foreach (var pair in dictionary.ToDictionary()) { var model = DynamicDictionaryStorageModel.Generate(pair.Key, pair.Value); if (await connection.Table <DynamicDictionaryStorageModel>().Where(z => z.Key == pair.Key).CountAsync() > 0) { await connection.UpdateAsync(model); } else { await connection.InsertAsync(model); } } return(true); }
public bool Save(DynamicDictionary dictionary, DynamicDictionarySaveMotive motive) { var connection = new SQLiteConnection(DataBasePath); connection.CreateTable <DynamicDictionaryStorageModel>(); foreach (var pair in dictionary.ToDictionary()) { var model = DynamicDictionaryStorageModel.Generate(pair.Key, pair.Value); if (connection.Table <DynamicDictionaryStorageModel>().Count(z => z.Key == pair.Key) > 0) { connection.Update(model); } else { connection.Insert(model); } } return(true); }