public async Task FileConnectionTestAsync() { var guid = System.Guid.NewGuid().ToString(); string dbPath = $@"C:\temp\{guid}.db"; if (System.IO.File.Exists(dbPath)) { System.IO.File.Delete(dbPath); } _db = new SQLite.SQLiteAsyncConnection(dbPath); await _db.CreateTableAsync <DummyTable>().ConfigureAwait(false); bool exists = System.IO.File.Exists(dbPath); Assert.AreEqual(true, exists, "Make sure VS is in Admin mode"); await _db.CloseAsync(); if (File.Exists(dbPath)) { File.Delete(dbPath); } if (File.Exists(dbPath)) { Assert.Fail($"File '{dbPath}' was not deleted"); } }
////[TestMethod] ////public async Task TableInsertTest() ////{ //// await SaveItemAsync(item); //// var items = await _db.QueryAsync<DummyTable>("SELECT * FROM [DummyTable] WHERE [Done] = 0"); //// Assert.AreEqual(1, items.Count); ////} private void CloseConnection() { if (_db != null) { _db.CloseAsync(); } }