| | Name | Description |
|---|
 | ArtConnectionStringName | The name of the connection string to use to connect to the database used to store and retrieve annotations https. If this is not specified, ConnectionStringName will be used and it will be assumed that documents and annotations are stored in the same database. |
| CachingEnable | Whether caching of documents in RAM is enabled for this data provider |
| CachingTimeLimit | Maximum time in minutes to keep items in cache. |
| ConnectionStringName | The name of the connection string used to connect to the database used for image and document storage https |
| Description | Overridden. Gets or sets the description for this provider. |
| InitSqlCacheDependency | Whether to register the connection string for receiving dependency change notifications https. Both SqlCacheDependencyNeeded and InitSqlCacheDependency must be true in order for Sql Cache Dependencies to be utilized when caching documents. |
| MaxImageSizeToCache | Specifies the maximum size in bytes of documents to cache. |
| Name | Overridden. Gets the friendly name used to refer to this built in SQL provider during configuration. |
| ParamKeyLength | Specifies the length of SqlParameter which stores the primary key for the storage and retrieval of documents. If it is specified and a positive integer, it will be used in performing a length check when adding the parameter to the SqlCommand. https. . |
| ParamKeySqlDbType | The SqlDbType System.Data.SqlDbType of SqlParameter. This is the SQL data type of the primary key of the table used to store and retrieve images. If this is specified, then a data type check will be performed when adding the parameter to construct the SqlCommand used to execute the query. This is required in order for a length check to be performed on SqlParameter with ParamKeyLength. |
| SqlArtDataField | The name of the column which stores annotation data in the table that stores annotations |
| SqlArtInsertCommand | The SQL query or stored procedure used to insert a new art document into the annotations table |
| SqlArtInsertCommandType | The Command Type for SqlArtInsertCommand System.Data.CommandType. This can be either "Text" or "StoredProcedure" as specified in Web.config. TableDirect is unsupported. |
| SqlArtKeyArtIdField | The name of the column which stores the Markup Layer Record ID in the Annotations table, which is part of the composite key used to store Annotations. This is required so that the back-end may know which column corresponds to the Markup Layer Record ID in SqlArtListCommand. |
| SqlArtKeyArtIdParameter | The parameter that is used to specify the Markup Layer Record ID when constructing SQL Commands dealing with annotations. https. An SQL parameter is used like a variable identifier and should appear in relevant queries. MSSQL parameters should begin with the '@' symbol. |
| SqlArtKeyArtIdParamLength | Specifies the length of SqlArtKeyArtIdParameter which stores the the Markup Layer Record ID, a part of the composite key used to store and retrieve annotation data from the database. If it is specified and a positive integer, it will be used in performing a length check when adding the parameter to the SqlCommand. https. . |
| SqlArtKeyArtIdSqlDbType | The SqlDbType System.Data.SqlDbType of SqlArtKeyArtIdParameter. This is the SQL data type of field used to store the Markup Layer Record ID, part of the composite key used to store and retrieve annotations from the Annotations table. If this is specified, then a data type check will be performed when adding the parameter to construct the SqlCommand used to execute the query. This is required in order for a length check to be performed on SqlArtKeyArtIdParameter with SqlArtKeyArtIdParamLength. |
| SqlArtKeyDocumentIdField | The name of the column that stores annotation data in the table that stores annotations |
| SqlArtKeyDocumentIdParameter | The parameter that is used to specify the Document Identifier, part of the composite key used to store and retrieve annotations, when constructing Sql Commands that operate on the Annotations table. https. An SQL parameter is used like a variable identifier and should appear in relevant queries. MSSQL parameters should begin with the '@' symbol. |
| SqlArtKeyDocumentIdParamLength | Specifies the length of SqlArtKeyDocumentIdParameter, part of the composite key used to store and retrieve annotations. If it is specified and a positive integer, it will be used in performing a length check when adding the parameter to the SqlCommand. https. . |
| SqlArtKeyDocumentIdSqlDbType | The SqlDbType System.Data.SqlDbType of SqlArtKeyDocumentIdParameter. This is the SQL data type of the field in the Annotations table that corresponds to the Document Identifier, which is part of the composite key for the Annotations Table. If this is specified, then a data type check will be performed when adding the parameter to construct the SqlCommand used to execute the query. This is required in order for a length check to be performed on SqlArtKeyDocumentIdParameter with SqlArtKeyDocumentIdParamLength. |
| SqlArtListCommand | The SQL query or stored procedure used to retrieve a list of Markup Layer Record IDs (part of a |
| SqlArtListCommandType | The Command Type for SqlArtListCommand System.Data.CommandType. This can be either "Text" or "StoredProcedure" as specified in Web.config. TableDirect is unsupported. |
| SqlArtMarkupNameField | The name of the column which stores the Markup Layer Name in the table that stores annotations. The Markup Layer Name is a user-friendly and non-unqiue name to associate with a Markup Layer that may be displayed to the user as a mnemonic in the client viewer. |
| SqlArtMarkupNameParameter | The parameter that is used to insert document data into the database for insert operations https. An SQL parameter is used like a variable identifier and should appear in relevant queries. MSSQL parameters should begin with the '@' symbol. |
| SqlArtMarkupNameParamLength | Specifies the length of SqlArtMarkupNameParameter. If it is specified and a positive integer, it will be used in performing a length check when adding the parameter to the SqlCommand. https. . |
| SqlArtMarkupNameSqlDbType | The SqlDbType System.Data.SqlDbType of SqlArtMarkupNameParameter. This is the SQL data type of the field used to store the Markup Layer Name in the annotations table. If this is specified, then a data type check will be performed when adding the parameter to construct the SqlCommand used to execute the query. This is required in order for a length check to be performed on SqlArtMarkupNameParameter with SqlArtMarkupNameParamLength. |
| SqlArtParameter | The parameter that is used to specify the annotation data into the database for annotation insert and update operations https. An SQL parameter is used like a variable identifier and should appear in relevant queries. MSSQL parameters should begin with the '@' symbol. |
| SqlArtReadCommand | The SQL query or stored procedure used to retrieve art documents from the database |
| SqlArtReadCommandType | The Command Type for SqlArtReadCommand System.Data.CommandType. This can be either "Text" or "StoredProcedure" as specified in Web.config. TableDirect is unsupported. |
| SqlArtUpdateCommand | The SQL query or stored procedure used to update art documents which already exist in the table used to store annotations |
| SqlArtUpdateCommandType | The Command Type for SqlArtUpdateCommand System.Data.CommandType. This can be either "Text" or "StoredProcedure" as specified in Web.config. TableDirect is unsupported. Will default to Text. |
| SqlCacheDependencyNeeded | Whether to use Sql Cache Dependencies for validating cached documents https. If this is enabled, documents will be cached with a dependency on the SqlCommand which embodies the query by which they were obtained such that any change in the results of the query would be automatically detected and the cached item will become invalid. |
| SqlCommand | The SQL query or stored procedure used to retrieve documents from the database |
| SqlCommandType | The Command Type for SqlCommand System.Data.CommandType. This can be either "Text" or "StoredProcedure" as specified in Web.config. TableDirect is unsupported. Will default to Text. |
| SqlImageDataField | The name of the column in which image data is stored |
| SqlImageDataFieldBlob | Indicates whether the table used for the storage of documents in the database contains the actual documents, or an alternate mapping of Document IDs to file names in the file system from StorageRootPath. If this is true, then documents are stored directly in and retrieved directly from the database. If it is false, then the content of the data field in the table used for storing documents will be retrieved and interpreted as the Document ID, effectively using the documents table as a mechanism for creating an alternate mapping for Document IDs to the file system.
A new property, UseImageTable UseImageTable, has been added to this DataProvider UseImageTable which indicates that a Document table will not be used at all and Document IDs will be directly routed to StorageRootPath in the file system. |
| SqlImageDataParameter | The parameter that is used to insert document data into the database for insert operations https. An SQL parameter is used like a variable identifier and should appear in relevant queries. MSSQL parameters should begin with the '@' symbol. |
| SqlInsertCommand | The SQL query or stored procedure used to insert documents into the database |
| SqlInsertCommandType | The Command Type for SqlInsertCommand System.Data.CommandType. This can be either "Text" or "StoredProcedure" as specified in Web.config. TableDirect is unsupported. Will default to Text. |
| SqlParameter | The parameter that is used to specify the primary key to use in queries to store and retrieve documents from the database. https. An SQL parameter is used like a variable identifier and should appear in relevant queries. MSSQL parameters should begin with the '@' symbol. |
| StorageRootPath | The root path to and from which documents will be stored and retrieved in the file system. This only applies if SqlImageDataFieldBlob is specified as "false". SqlImageDataFieldBlob. Paths that begin with a tilde '~' will be mapped to the server application root directory. |
| UseImageTable | Indicates that the database is to be used for the storage of documents. If this is false, only annotations will be stored in the database and any requests for documents will be routed to the file system and attempted to be read from StorageRootPath. If this is false, any properties concerning the storage and retrieval of documents from the database will be ignored as they are no longer relevant. |
