what is right way to save picture in sqlserver

Question

Now I will created folder in visual studio in order to save all photos and save the path of photo in sql table like below . but now i need to right way because the photos are more than 20.000 ble .

Nitin Sontakke · Answer

If satisfied please accept one the replies as answer.

Nitin Sontakke · Answer

Exactly. But please also understand why we should not duplicate the information. Imagine there is a scenario where you will have to rename a file. Now you have to rename it at 3 places. The file system on the computer and two columns in database table. Now it may happen another developer implementing this change will not know that there are two columns to update. He/She might just update one column and your application will break. Hope you get the idea!

Abdalla Elawad · Answer

Hi Nitin You're right. So do not be duplicative  i will remove FilePath Field from Table .

Nitin Sontakke · Answer

I think the way you are doing it is good enough. Any other way would complicate the matter for you believe. If you notice the FilePath it is having file name as well which is duplication. If you remove file name from file path all you get is \images every where which is meaningless. So you either keep FilePath or FileName not both.

Abdalla Elawad · Answer

Same idea but i used FilePath

Abdalla Elawad · Answer

Hi Nitin Snotakke I mean By(right way) Good Way to Save Image in Sql Server Thank You

Nitin Sontakke · Answer

It is not quite clear what do you mean by right way? Which part of the current implementation that you are not happy about? Just one suggestion do not keep the file path in the sql server just keep the file name. Keep all images in one folder and folder name either in some application parameter table in sql server or in web.config. This way after deployment all you have to do is change one value at one place. Hope you get the point.