SqlCertificateDatabase Class

An abstract X.509 certificate database built on generic SQL storage.

Inheritance Hierarchy

SystemObject
  MimeKit.CryptographyX509CertificateDatabase
    MimeKit.CryptographySqlCertificateDatabase
      MimeKit.CryptographySqliteCertificateDatabase
      MimeKit.CryptographySQLServerCertificateDatabase

Namespace: MimeKit.Cryptography
Assembly: MimeKit (in MimeKit.dll) Version: 4.10.0

Syntax

Copy

public abstract class SqlCertificateDatabase : X509CertificateDatabase

The SqlCertificateDatabase type exposes the following members.

Constructors

	Name	Description
	SqlCertificateDatabase(DbConnection, String)	Initialize a new instance of the SqlCertificateDatabase class.
	SqlCertificateDatabase(DbConnection, String, SecureRandom)	Initialize a new instance of the SqlCertificateDatabase class.

Top

Properties

	Name	Description
	CertificatesTable	Get the X.509 certificate table definition.
	CrlsTable	Get the X.509 certificate revocation lists (CRLs) table definition.
	EncryptionAlgorithm	Gets or sets the algorithm used for encrypting the private keys. (Inherited from X509CertificateDatabase)
	MinIterations	Gets or sets the minimum iterations. (Inherited from X509CertificateDatabase)
	RandomNumberGenerator	Get the secure pseudo-random number generator used when encrypting private keys. (Inherited from X509CertificateDatabase)
	SaltSize	Gets or sets the size of the salt. (Inherited from X509CertificateDatabase)

Top

Methods

	Name	Description
	Add(X509CertificateRecord)	Add the specified certificate record. (Inherited from X509CertificateDatabase)
	Add(X509CrlRecord)	Add the specified CRL record. (Inherited from X509CertificateDatabase)
	AddTableColumn	Adds a column to a table.
	CreateIndex	Creates an index for faster table lookups.
	CreateSelectQuery(X509CertificateRecordFields)	Creates a SELECT query string builder for the specified fields of an X.509 certificate record.
	CreateSelectQuery(X509CrlRecordFields)	Creates a SELECT query string builder for the specified fields of an X.509 CRL record.
	CreateTable	Gets the command to create a table.
	Dispose	Releases all resource used by the X509CertificateDatabase object. (Inherited from X509CertificateDatabase)
	Dispose(Boolean)	Releases the unmanaged resources used by the SqlCertificateDatabase and optionally releases the managed resources. (Overrides X509CertificateDatabaseDispose(Boolean))
	Equals	(Inherited from Object)
	Finalize	Releases unmanaged resources and performs other cleanup operations before the X509CertificateDatabase is reclaimed by garbage collection. (Inherited from X509CertificateDatabase)
	Find(X509Certificate, X509CertificateRecordFields)	Find the specified certificate. (Inherited from X509CertificateDatabase)
	Find(X509Crl, X509CrlRecordFields)	Finds the specified certificate revocation list. (Inherited from X509CertificateDatabase)
	Find(X509Name, X509CrlRecordFields)	Finds the CRL records for the specified issuer. (Inherited from X509CertificateDatabase)
	Find(ISelectorX509Certificate, Boolean, X509CertificateRecordFields)	Finds the certificate records matching the specified selector. (Inherited from X509CertificateDatabase)
	Find(MailboxAddress, DateTime, Boolean, X509CertificateRecordFields)	Finds the certificate records for the specified mailbox. (Inherited from X509CertificateDatabase)
	FindCertificates	Finds the certificates matching the specified selector. (Inherited from X509CertificateDatabase)
	FindPrivateKeys	Finds the private keys matching the specified selector. (Inherited from X509CertificateDatabase)
	GetCrlStore	Gets a certificate revocation list store. (Inherited from X509CertificateDatabase)
	GetDeleteCommand(DbConnection, X509CertificateRecord)	Gets the database command to delete the specified certificate record. (Overrides X509CertificateDatabaseGetDeleteCommand(DbConnection, X509CertificateRecord))
	GetDeleteCommand(DbConnection, X509CrlRecord)	Gets the database command to delete the specified CRL record. (Overrides X509CertificateDatabaseGetDeleteCommand(DbConnection, X509CrlRecord))
	GetHashCode	(Inherited from Object)
	GetIndexName	Gets the name of an index based on the table and columns that it is built against.
	GetInsertCommand(DbConnection, X509CertificateRecord)	Gets the database command to insert the specified certificate record. (Overrides X509CertificateDatabaseGetInsertCommand(DbConnection, X509CertificateRecord))
	GetInsertCommand(DbConnection, X509CrlRecord)	Gets the database command to insert the specified CRL record. (Overrides X509CertificateDatabaseGetInsertCommand(DbConnection, X509CrlRecord))
	GetSelectAllCrlsCommand	Gets the database command to select all CRLs in the table. (Overrides X509CertificateDatabaseGetSelectAllCrlsCommand(DbConnection))
	GetSelectCommand(DbConnection, X509Name, X509CrlRecordFields)	Gets the database command to select the CRL records matching the specified issuer. (Overrides X509CertificateDatabaseGetSelectCommand(DbConnection, X509Name, X509CrlRecordFields))
	GetSelectCommand(DbConnection, X509Certificate, X509CertificateRecordFields)	Gets the database command to select the record matching the specified certificate. (Overrides X509CertificateDatabaseGetSelectCommand(DbConnection, X509Certificate, X509CertificateRecordFields))
	GetSelectCommand(DbConnection, X509Crl, X509CrlRecordFields)	Gets the database command to select the record for the specified CRL. (Overrides X509CertificateDatabaseGetSelectCommand(DbConnection, X509Crl, X509CrlRecordFields))
	GetSelectCommand(DbConnection, MailboxAddress, DateTime, Boolean, X509CertificateRecordFields)	Get the database command to select the certificate records for the specified mailbox. (Overrides X509CertificateDatabaseGetSelectCommand(DbConnection, MailboxAddress, DateTime, Boolean, X509CertificateRecordFields))
	GetSelectCommand(DbConnection, ISelectorX509Certificate, Boolean, Boolean, X509CertificateRecordFields)	Get the database command to select the requested certificate records. (Overrides X509CertificateDatabaseGetSelectCommand(DbConnection, ISelectorX509Certificate, Boolean, Boolean, X509CertificateRecordFields))
	GetTableColumns	Gets the columns for the specified table.
	GetType	(Inherited from Object)
	GetUpdateCommand(DbConnection, X509CrlRecord)	Obsolete. Gets the database command to update the specified CRL record. (Overrides X509CertificateDatabaseGetUpdateCommand(DbConnection, X509CrlRecord))
	GetUpdateCommand(DbConnection, X509CertificateRecord, X509CertificateRecordFields)	Gets the database command to update the specified record. (Overrides X509CertificateDatabaseGetUpdateCommand(DbConnection, X509CertificateRecord, X509CertificateRecordFields))
	GetValue(X509CertificateRecord, String)	Gets the value for the specified column. (Inherited from X509CertificateDatabase)
	MemberwiseClone	(Inherited from Object)
	Remove(X509CertificateRecord)	Remove the specified certificate record. (Inherited from X509CertificateDatabase)
	Remove(X509CrlRecord)	Remove the specified CRL record. (Inherited from X509CertificateDatabase)
	RemoveIndex	Removes an index that is no longer needed.
	ToString	(Inherited from Object)
	Update(X509CrlRecord)	Obsolete. Update the specified CRL record. (Inherited from X509CertificateDatabase)
	Update(X509CertificateRecord, X509CertificateRecordFields)	Update the specified certificate record. (Inherited from X509CertificateDatabase)

Top

Remarks

An X.509 certificate database is used for storing certificates, metdata related to the certificates (such as encryption algorithms supported by the associated client), certificate revocation lists (CRLs), and private keys.

This particular database uses SQLite to store the data.

Reference

MimeKit.Cryptography Namespace