C# (CSharp) SQLite.SQLiteAsyncConnection.QueryAsync Examples

Example #1

File: RawLocalDatabaseTest.cs Project: xenoinc/LiteMigrator

        public async Task MemoryEmptyTableTestAsync()
        {
            CreateConnection();

            _db.CreateTableAsync <DummyTable>().Wait();

            var items = await _db.QueryAsync <List <string> >
                            ("SELECT name FROM sqlite_master WHERE type='table' AND name='DummyTable';");

            Assert.AreNotEqual(0, items);

            // Returns column names and info
            var columnInfo = await _db.GetTableInfoAsync("DummyTable");

            Assert.AreNotEqual(0, columnInfo.Count);

            CloseConnection();
        }