ImageGear .NET v25.2 - Updated
ImageGear.Web.Services Assembly / ImageGear.Web.DataProviders Namespace / MarkupSqlImageDataProvider Class
Members




In This Topic
    MarkupSqlImageDataProvider Class
    In This Topic
    This class embodies an implementation of an SQL Data Provider using the new Markup Layer Interface MarkupImageDataProvider, permitting multiple annotation or art documents to be associated with a viewable document. It retains and respects all of the configuration parameters of SqlImageDataProvider SqlImageDataProvider, and adds a few new parameters which permit it to store and retrieve documents and annotations from separate tables. Subject to user configuration, the intended schema is such that (DocumentIdentifier) is the primary key of a 2-column table (DocumentIdentifier, ImageData) used to store documents, and (DocumentIdentifier, MarkupLayerRecordID) is a composite key used to store annotations in a 4-column table (DocumentIdentifier, MarkupLayerRecordID, ArtData, MarkupLayerName) where DocumentIdentifier is a foreign key referencing the table used to store documents. An example schema is provided. table Documents ( DocumentID varchar(255) not null primary key, ImageData varbinary(max) not null ); table Annotations ( DocumentID varchar(255) not null, MarkupID varchar(255) not null, ArtData varbinary(MAX) not null, MarkupName varchar(255) null, primary key(DocumentID, MarkupID), foreign key(DocumentID) references Documents );
    Object Model
    MarkupSqlImageDataProvider ClassMarkupImageDataConnection Class
    Syntax
    'Declaration
     
    Public Class MarkupSqlImageDataProvider 
       Inherits MarkupImageDataProvider
    'Usage
     
    Dim instance As MarkupSqlImageDataProvider
    public class MarkupSqlImageDataProvider : MarkupImageDataProvider 
    public __gc class MarkupSqlImageDataProvider : public MarkupImageDataProvider 
    public ref class MarkupSqlImageDataProvider : public MarkupImageDataProvider 
    Example
    table Documents ( DocumentID varchar(255) not null primary key, ImageData varbinary(max) not null ); table Annotations ( DocumentID varchar(255) not null, MarkupID varchar(255) not null, ArtData varbinary(MAX) not null, MarkupName varchar(255) null, primary key(DocumentID, MarkupID), foreign key(DocumentID) references Documents );
    Inheritance Hierarchy

    System.Object
       System.Configuration.Provider.ProviderBase
          ImageGear.Web.DataProviders.MarkupImageDataProvider
             ImageGear.Web.DataProviders.MarkupSqlImageDataProvider

    See Also