public IReadOnlyList <IDBTable> ListTables()
{
var sql = $"SELECT * FROM [{_databaseName}].sqlite_master WHERE type='table' AND NOT name = 'sqlite_sequence'";
return(_connProvider.PerformFunc <IReadOnlyList <IDBTable> >(conn =>
{
return new ReadOnlyCollection <SQLiteTable>(conn.Query <TableInfo>(sql).Select(i => new SQLiteTable(i.Name, i.Type, i.RootPage, i.Tbl_Name, i.Sql)).ToArray());
}));
}
public IReadOnlyList <IDBDatabase> ListDatabases()
{
return(_connProvider.PerformFunc(ListDatabases));
}