Classe DatabaseCollection
The DatabaseCollection class represents a collection of Database objects that represent all the databases defined on the instance of SQL Server.
Hierarquia de herança
System.Object
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.SortedListCollectionBase
Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase
Microsoft.SqlServer.Management.Smo.DatabaseCollection
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public NotInheritable Class DatabaseCollection _
Inherits SimpleObjectCollectionBase
'Uso
Dim instance As DatabaseCollection
public sealed class DatabaseCollection : SimpleObjectCollectionBase
public ref class DatabaseCollection sealed : public SimpleObjectCollectionBase
[<SealedAttribute>]
type DatabaseCollection =
class
inherit SimpleObjectCollectionBase
end
public final class DatabaseCollection extends SimpleObjectCollectionBase
O tipo DatabaseCollection expõe os membros a seguir.
Propriedades
| Nome | Descrição | |
|---|---|---|
.gif "Propriedade pública") |
Count | Gets the number of objects in the referenced collection. (Herdado de SmoCollectionBase.) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (Herdado de SmoCollectionBase.) |
|
Item[Int32] | Gets a Database object in the collection by index number. |
|
Item[String] | Gets a Database object in the collection by name. |
|
Parent | Gets the Server object that is the parent of the Database object. |
|
SyncRoot | Gets an object that can be used to synchronize access to the collection. (Herdado de SmoCollectionBase.) |
Início
Métodos
| Nome | Descrição | |
|---|---|---|
.gif "Método público") |
Add | Adds an database object to the collection. |
.gif "Método protegido") |
AddExisting | Adds an object to the collection. (Herdado de AbstractCollectionBase.) |
|
Contains | Verifies whether the specified object exists in the collection. (Herdado de SimpleObjectCollectionBase.) |
|
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. |
|
Equals | (Herdado de Object.) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (Herdado de SmoCollectionBase.) |
|
GetHashCode | (Herdado de Object.) |
|
GetType | (Herdado de Object.) |
|
ItemById | Extracts a member from the DatabaseCollection collection using a system-defined, unique identifier. |
|
Refresh() | Refreshes the referenced collection. (Herdado de SmoCollectionBase.) |
|
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (Herdado de SmoCollectionBase.) |
|
ToString | (Herdado de Object.) |
Início
Campos
| Nome | Descrição | |
|---|---|---|
.gif "Campo protegido") |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de AbstractCollectionBase.) |
Início
Implementações de interfaces explícitas
| Nome | Descrição | |
|---|---|---|
.gif "Implementações de interfaces explícitas") .gif "Método privado") |
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (Herdado de SmoCollectionBase.) |
Início
Comentários
A DatabaseCollection object can be used to gain access to a set of databases. You can use the Item property to return a specific Database object.
Thread Safety
Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.
Exemplos
Segurança de thread
Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.