public List<string> GetLocalFolders()
{
var folders = new List<string>();
SQLiteCommand command = new SQLiteCommand("SELECT localPath FROM folders;", GetSQLiteConnection());
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string folder = (string)reader["localPath"];
folders.Add(folder);
}
return folders;
}