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