Consider the following code:
//get bytes
var query = await _storage.Get(attachment.Id, General.ContainerType.Uploads);
//just for the sake of debugging
var mem = new MemoryStream(query);
//return the uploaded file
return File(mem, MimeTypesMap.GetMimeType(attachment.FileName), attachment.FileName);
Resolved by providing a URL to the azure blob storage file and adding permissions for a few minutes : https://stackoverflow.com/a/30468172/4487530