In which folder can I store user uploaded images

I've a classified ads system on ASP.NET/c#/MS SQL, and I'm trying to figure out where to store the images that people upload when placing an ad. The ad itself is being stored in a SQL server database.

The images are now being stored in a subfolder of my webapp. It seems to work fine, however I only recently discovered a big problem开发者_如何学编程. Everytime a user deletes an ad, the attached images are to be deleted as well including the folder they reside in. This leads to a restart of the asp.net application. I searched internet and found that restarting the web-app is actually intended behaviour when a subfolder is being deleted.

Obviously, I need to fix this. But how to do that? Where can I store images in such a way that:

• I can remove these images including the folders they are stored in?
• I can acces them using a URL (the images need to be shown in the webpages)
• Without getting the web-app being restarted? Any feedback is appreciated! Paul

---

See this question Deleting a directory results in application restart

An other alternative would be to store the images in the DB instead.

---

Another option would be to put the images in a directory completely unrelated to the web site then serve the images through a scripted page or handler. It would make all of your image urls look like mydomaincom/serveimage.aspx?imageid=323422, but unless you're counting on the name somewhere that really shouldn't matter much. Obviously it would require a modification to the page that serves the images in the first place as well, but if sub directories of this unrelated directory are deleted IIS really shouldn't care at all.

---

maybe you can store the images in SQL (check at the filestream feature in this case) if not, I suppose you have somewhere in a business facade class, a service class or wherever you want, a methode "DeleteAd".

This method will have to do two things :

-delete the sql data -delete the file image

also, you may change the image store to another folder, outside the web app. You will probably end with writing a custom handler (myhandler.ashx?fileid=XX) to serve the files, or a custom route and control if you use MVC.