private void FillDbColumns(SQLiteConnection connection, string tableName)
        {
            var cmd     = new SQLiteCommand(string.Format(TableInfoSelectTemplate, tableName), connection);
            var columns = new HashSet <string>();

            _dbColumnInfo[tableName] = columns;
            dynamic reader = new DynamicReader(cmd.ExecuteReader());

            try
            {
                while (reader.Read())
                {
                    columns.Add(reader.name);
                }
            }
            finally
            {
                reader.Close();
            }
        }
 private void FillBookmarksRoots(SQLiteConnection connection)
 {
     if (!_roots.Any())
     {
         var     cmd    = new SQLiteCommand(BookmarksRootsSelectStatement, connection);
         dynamic reader = new DynamicReader(cmd.ExecuteReader());
         try
         {
             while (reader.Read())
             {
                 string rootName = reader.title.ToLower();
                 if (!_roots.ContainsKey(rootName))
                 {
                     _roots.Add(rootName, (int)reader.id);
                 }
             }
         }
         finally
         {
             reader.Close();
         }
     }
 }
 private void FillDbColumns(SQLiteConnection connection, string tableName)
 {
     var cmd = new SQLiteCommand(string.Format(TableInfoSelectTemplate, tableName), connection);
     var columns = new HashSet<string>();
     _dbColumnInfo[tableName] = columns;
     dynamic reader = new DynamicReader(cmd.ExecuteReader());
     try
     {
         while (reader.Read())
         {
             columns.Add(reader.name);
         }
     }
     finally
     {
         reader.Close();
     }
 }
 private void FillBookmarksRoots(SQLiteConnection connection)
 {
     if (!_roots.Any())
     {
         var cmd = new SQLiteCommand(BookmarksRootsSelectStatement, connection);
         dynamic reader = new DynamicReader(cmd.ExecuteReader());
         try
         {
             while (reader.Read())
             {
                 string rootName = reader.root_name.ToLower();
                 if (!_roots.ContainsKey(rootName))
                 {
                     _roots.Add(rootName, (int)reader.folder_id);
                 }
             }
         }
         finally
         {
             reader.Close();
         }
     }
 }