Best way to save / load images from .Net & SQL Server 2005?

Question

What is a typical way to process product images on a web page selling products? Let's say I had a database with books or computer components, etc., all of which have their own image samples, for example ... Do I have to save them to the database as binary data or somehow process them in code, saving them in a directory with the corresponding link to the image file is stored in the product table in the database?

I am trying to make an example of a company’s sales, and although I can figure out how to do this, I wonder what a typical norm is used in the programming business?

Update: Storage on another system or an alternative database is not an option, while information on possible alternatives for a future link is evaluated. All I have is Visual Studio 2008 and SQL Server 2005/2008 on the same machine with one ASP.Net project. Thus, the files must be stored in a directory in the web page project or in one DB that will be used by it.

Answer 1

,
, .

SQL Server 2008 FILESTREAM

SQL Server 2008 Microsoft FILESTREAM, . ( ) . varbinary (max), . DB. , .

.

, , SQL Server 2008, - . , 2008, .

Answer 2

: ?

# SQL Server 2005, : / SQL Server

MS : BLOB BLOB: :

, 256 . , 1 , . 256K 1M, : .

Answer 3

! SQL Server . , .

Answer 4

, URL-/ . , , , .

.

Recently, I had a situation where an inherited system stored images and files as binary files, which forced time and effort to extract them to update the database software.