Show/Hide TOC

SqlCertificateDatabase Class

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

Definition

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

public abstract class SqlCertificateDatabase : X509CertificateDatabase

Inheritance: Object X509CertificateDatabase SqlCertificateDatabase

Derived: MimeKit.CryptographySqliteCertificateDatabase
MimeKit.CryptographySQLServerCertificateDatabase

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.

Constructors

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

Properties

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)

Methods

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.
CreateCommand	Create a new database command. (Inherited from X509CertificateDatabase)
CreateIndex	Creates an index for faster table lookups.
CreateParameterName	Create a parameter name for use in SQL database queries.
CreateSelectQuery(X509CertificateRecordFields)	Create a SELECT query string builder for the specified fields of an X.509 certificate record.
CreateSelectQuery(X509CrlRecordFields)	Create 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	Determines whether the specified object is equal to the current object. (Inherited from Object)
ExecuteNonQuery	Execute a non-query database command. (Inherited from X509CertificateDatabase)
ExecuteReader	Execute a database command. (Inherited from X509CertificateDatabase)
ExecuteWithinTransaction	Execute an action within a database transaction. (Inherited from X509CertificateDatabase)
Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object)
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(X509CertificateRecord)	Gets the database command to delete the specified certificate record. (Overrides X509CertificateDatabaseGetDeleteCommand(X509CertificateRecord))
GetDeleteCommand(X509CrlRecord)	Gets the database command to delete the specified CRL record. (Overrides X509CertificateDatabaseGetDeleteCommand(X509CrlRecord))
GetHashCode	Serves as the default hash function. (Inherited from Object)
GetIndexName	Gets the name of an index based on the table and columns that it is built against.
GetInsertCommand(X509CertificateRecord)	Gets the database command to insert the specified certificate record. (Overrides X509CertificateDatabaseGetInsertCommand(X509CertificateRecord))
GetInsertCommand(X509CrlRecord)	Gets the database command to insert the specified CRL record. (Overrides X509CertificateDatabaseGetInsertCommand(X509CrlRecord))
GetSelectAllCrlsCommand	Gets the database command to select all CRLs in the table. (Overrides X509CertificateDatabaseGetSelectAllCrlsCommand)
GetSelectCommand(X509Certificate, X509CertificateRecordFields)	Gets the database command to select the record matching the specified certificate. (Overrides X509CertificateDatabaseGetSelectCommand(X509Certificate, X509CertificateRecordFields))
GetSelectCommand(X509Crl, X509CrlRecordFields)	Gets the database command to select the record for the specified CRL. (Overrides X509CertificateDatabaseGetSelectCommand(X509Crl, X509CrlRecordFields))
GetSelectCommand(X509Name, X509CrlRecordFields)	Gets the database command to select the CRL records matching the specified issuer. (Overrides X509CertificateDatabaseGetSelectCommand(X509Name, X509CrlRecordFields))
GetSelectCommand(ISelectorX509Certificate, Boolean, Boolean, X509CertificateRecordFields)	Get the database command to select the requested certificate records. (Overrides X509CertificateDatabaseGetSelectCommand(ISelectorX509Certificate, Boolean, Boolean, X509CertificateRecordFields))
GetSelectCommand(MailboxAddress, DateTime, Boolean, X509CertificateRecordFields)	Get the database command to select the certificate records for the specified mailbox. (Overrides X509CertificateDatabaseGetSelectCommand(MailboxAddress, DateTime, Boolean, X509CertificateRecordFields))
GetTableColumns	Gets the columns for the specified table.
GetType	Gets the Type of the current instance. (Inherited from Object)
GetUpdateCommand	Gets the database command to update the specified record. (Overrides X509CertificateDatabaseGetUpdateCommand(X509CertificateRecord, X509CertificateRecordFields))
GetValue(X509CertificateRecord, String)	Gets the value for the specified column. (Inherited from X509CertificateDatabase)
LimitToOne	Limit the query results to a single record.
MemberwiseClone	Creates a shallow copy of the current Object. (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	Returns a string that represents the current object. (Inherited from Object)
Update	Update the specified certificate record. (Inherited from X509CertificateDatabase)