DbSqlImageAccessor Class

From ISerializable. All properties are encrypted if encryptSerializedState was set to true in the constructor. They are encrypted using the encryptor

Creates an object that can be used with DbImageSource to access images stored in a database. The image streams are access by combining clauses of SQL Statements provided.

Creates an object that can be used with DbImageSource to access images stored in a database. The image streams are access by combining clauses of SQL Statements provided.

Creates an object that can be used with DbImageSource to access images stored in a database. The image streams are access by combining clauses of SQL Statements provided.

Creates an object that can be used with DbImageSource to access images stored in a database. The image streams are access by combining clauses of SQL Statements provided.

Creates an object that can be used with DbImageSource to access images stored in a database. The image streams are access by combining clauses of SQL Statements provided.

A delegate that can decrypt a string.

A delegate that can encrypt a string.

Whether or not the serialized state is encrypted. Please see documentation of sub-classes to see which members are encrypted.

A copy of the extra parameters dictionary. This class does not support changing the parameters after the object has been constructed.

The name of the frame count field in the data source

The table that contains the images (or any valid from clause)

A delegate that can return a connection to the database.

The name of the image field in the data source

Returns the name of the field that contains the image stream information. If the field is an expression it must contain an as clause that names the field.

Returns either the given order by clause or the primary keys if that is blank

Returns either the given where clause or a clause that is always true, if that is blank

A valid SQL order by clause or null if the dataset should be ordered by the primary keys

The commas separated list of fields that make up the primary key of the data source

A valid SQL where clause or null if all rows are to be used.

Adds any extra parameters supplied by the user that are needed to run the command.

Creates a command that can get the given field from the row indexed by imageStreamIndex from the datasource.

A command that returns the frame count for an image. If this method returns null, the frame count will be determined by decoding the image stream. If not null, this command should result in a single row dataset with the frame count in the first column. If the frame count is stored separately from the image stream, implementing this method can greatly increase performance (especially first access). This command should not be associated with any connection.

A method that can return a command that gets a single row dataset with the image stream information at the given index. The field can either be a varbinary, binary or image type (in which case the image stream is the value of the field) or it can be a string which will be interpreted as a filename that contains the image. The command should not be associated with a connection.

A command that can get the number of image streams in the source (each of which can contain multiple frames). This command should just return the number of streams (not the total frame count). The command should result in a single row dataset with the count in the first column. The command should not be associated with a connection.

Creates a SQL statement that can count the number of image streams. The count should be in the first column of the first row of the returned rows.

Creates a SQL Query using Common Table Expressions that can get a specific row by index from a data source.

Creates a stream from the object obtained from the database. If the object is a byte array, it is attached to a MemoryStream. If the object is a string, it is interpreted as a filename and an open FileStream to the file is returned. If the object is null or not able to be interpreted as a stream, this method will throw.

Decrypt a string if EncryptSerializedState is true.

Encrypt a string if EncryptSerializedState is true.

Determines whether the specified object is equal to the current object.

Extracts a stream from a row of the database.

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.

Gets the database object from the first row of the data set returned by the command from the field at

Copy
index

.

Gets the database object from the first row of the data set returned by the command at the field named

Copy
field

.

Gets the database object from the first row of the data set returned by the command from the field at

Copy
index

which can be either a field name or an integer index.

Gets the value from the serialized data and decrypts it if requested.

Gets a field from the datareader by passing in the index of a field.

Gets a field from the datareader by passing in the name of the field.

Takes SQL field clause and returns the name of the column.

The number of frames in the stream indicated by the imageStreamIndex

Serves as the default hash function.

Gets the number of image streams in this database. Each stream can contain more than one frame.

Get the data to serialize for this object

Gets the Type of the current instance.

Creates a shallow copy of the current Object.

Opens a non-open connection

Reset all caches of information. If you are storing anything that is a cached from the database, release it.

Stores the value into the serialization info and encrypts it if requested.

Returns a string that represents the current object.