All the images/resources for only a given template (say X) are stored in azure. While all other images are still stored in Sitecore Media Library.
When a user navigates to an item of template X in sitecore content tree, how can I tell sitecore to show the product image from Azure instead of Sql? Also, when the user is on an item of different template (not from template X) I still need the image from SQL.
Is it possible to have multiple media providers(sql and azure) and tell sitecore to bring data from different providers based on template of current item?
Or can we extend the default image type and add a new checkbox in the image type data type which says "Read from Azure" and use that to identify where to get the image from?