Chimney.Shared.UserControls.ChimneyServerUserControl.GetDirectory C# (CSharp) Method

        async Task<Directory> GetDirectory(string Name, int ParentDirectoryId)
        {
            //
            // Select Directory with FolderRelativeId
            //
            var directory = await Dbconnection.QueryAsync<Directory>("SELECT * FROM Directories WHERE Name = \"" +  Name +
                "\" AND ParentDirectoryId = " + ParentDirectoryId);

            //
            // If the select find a matching file return the File else return null
            //
            return (directory.Count > 0) ? directory.First<Directory>() : null;
        }