ImageGear .NET v24.12 - Updated
SQL Image Data Providers
User Guide > How to Work with... > Common Operations > Viewing > Viewing Using ASP.NET > [Legacy] ASP.NET Web.Config Editor Application > Use the Web Configuration Categories Screen > Configuring and Working with Data Providers > Image Data Providers > SQL Image Data Providers

To retrieve from and store data to a SQL database, you must define a SQL image data provider.

The ImageGear built-in SQLImageDataProvider is an ADO.NET based ImageProvider, which by default uses Microsoft SQL Server Data provider. However, this provider can be configured to use any database. 

The built-in SQLImageDataProvider requires that image data be stored in the database in one of these forms:

The built-in SQLImageDataProvider requires that annotation data be stored in the database as follows:

The built-in SqlImageDataProvider uses the database schema defined in the following files, which are provided in the install folder. 

The install folder default path is:
C:\Users\Public\Documents\Accusoft\ImageGear.NET v24\Samples\ASP.NET\SQL     
  1. scriptSQLExpress2005ImageStorageTableSchema.sql 
  2. scriptSQLExpress2008ImageStorageTableSchema.sql 
  3. ImageStorageDBSchemaAndData.sql - Creates database with image data. This is suitable for the sample application.

A custom Sql Image data provider can be written to replace the built-in SqlImageDataProvider. Most databases are transactions-aware but if you choose to use non-transactional database, then you must be mindful of transactions in your custom provider when writing annotations data. See Loading from a Database for more information.

This section provides information about the following: