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.
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: