ImageGear .NET
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 v22\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. The "RadiologyOfficeSample" sample application demonstrates how to write a custom Sql image data provider.

This section provides information about the following:

 

 


©2016. Accusoft Corporation. All Rights Reserved.

Send Feedback