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(); } } }