Certificates Propiedad
Representa una colección de objetos Certificate. Cada objeto Certificate representa un certificado definido en la base de datos.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, _
GetType(Certificate))> _
Public ReadOnly Property Certificates As CertificateCollection
Get
'Uso
Dim instance As Database
Dim value As CertificateCollection
value = instance.Certificates
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(Certificate))]
public CertificateCollection Certificates { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(Certificate))]
public:
property CertificateCollection^ Certificates {
CertificateCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(Certificate))>]
member Certificates : CertificateCollection
function get Certificates () : CertificateCollection
Valor de la propiedad
Tipo: Microsoft.SqlServer.Management.Smo. . :: . .CertificateCollection
Objeto CertificateCollection que representa todos los certificados definidos en la base de datos.
Comentarios
Specific certificates can be referenced by using this collection by specifying the name of the certificate. To add a new certificate to the collection, call the certificate constructor Certificate.
Ejemplos
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Display all the asymmetric keys on the database.
Dim ak As AsymmetricKey
For Each ak In db.AsymmetricKeys
Console.WriteLine(ak.Name)
Next
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
Foreach ($ak in $db.AsymmetricKeys)
{
Write-Host $ak.Name
}