I've been tasked to transfer files from SQL to a ashx handler in another application which we don't manage. It looks like the ashx handler needs the file location to come from a directory. So my assumption is to first download the file to a local folder in my app. So I've created a "Files" directory in my application App_Data directory "App_Data/Files/".
So my approach would be to download the file to this folder then transfer it via the ashx handler. However, I cannot find an example of how to download a file stored in SQL Server to a local directory in an application. Does anyone know how to do this or have an example of downloading a file stored in SQL Server to a specific folder within the app?