what is right way to save picture in sqlserver

If satisfied, please accept one the replies as 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!

 Hi Nitin

 

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

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.

 Hi Nitin Snotakke

I mean By(right way) Good Way to Save Image in Sql Server

Thank You

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.