This topic has not yet been rated - Rate this topic

PropertyCollection Class

SQL Server 2012

The PropertyCollection class represents a collection of Property objects that represent all the properties defined on the parent object.

System::Object
Microsoft.SqlServer.Management.Smo::PropertyCollection
Microsoft.SqlServer.Management.Smo::SqlPropertyCollection

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public ref class PropertyCollection : ICollection, 
	IEnumerable, ISfcPropertySet

The PropertyCollection type exposes the following members.

	Name	Description
	Count	Gets the number of properties in the PropertyCollection object.
	IsSynchronized	Gets a Boolean value indicating whether access to the collection is synchronized and therefore thread-safe.
	Item[Int32]	Gets an object in the collection by index number.
	Item[String]	Gets an object in the collection by name.
	SyncRoot	Gets an object that can be used to synchronize access to the collection.

	Name	Description
	Contains	Determines whether the element specified by key exists in the collection.
	CopyTo	Copies the collection objects to a one-dimensional array beginning at the index value specified.
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetEnumerator	Gets an enumerator that can iterate through the list of objects.
	GetHashCode	(Inherited from Object.)
	GetPropertyObject(Int32)	Gets the Property object.
	GetPropertyObject(String)	Gets the Property object.
	GetPropertyObject(Int32, Boolean)	Gets the Property object.
	GetPropertyObject(String, Boolean)	.Gets the Property object.
	GetType	(Inherited from Object.)
	LookupID	Returns the ID of the Property object in the PropertyCollection object that has the specified name.
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

	Name	Description
	ICollection::CopyTo	Copies the collection.
	ISfcPropertySet::Contains(String)	Determines whether the property collection contains the property specified by the propertyName parameter.
	ISfcPropertySet::Contains(ISfcProperty)	Determines whether the property collection contains the property specified by the parameter.
	ISfcPropertySet::Contains<T>(String)	Determines whether the property collection contains the property specified by the name parameter.
	ISfcPropertySet::EnumProperties	Gets the enumerator for the property collection.
	ISfcPropertySet::TryGetProperty	Tries to get the property specified by the name parameter and type specified by the property parameter.
	ISfcPropertySet::TryGetPropertyValue(String, Object%)	Tries to get the property value specified by the name parameter and type specified by the property parameter.
	ISfcPropertySet::TryGetPropertyValue<T>(String, T%)	Tries to get the property value specified by the name parameter and type specified by the value parameter.

A PropertyCollection object can be used to gain access to a set of properties. You can use the Item property to return a specific Property object.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions