async Task<List<Directory>> GetSubDirectories(Directory directory)
{
List<Directory> subdir = new List<Directory>();
var subDirectories = await Dbconnection.QueryAsync<Directory>("SELECT * FROM Directories WHERE ParentDirectoryId = " + directory.DirectoryId);
subdir.AddRange(subDirectories);
foreach (Directory d in subDirectories)
{
subdir.AddRange(await GetSubDirectories(d));
}
return subdir;
}