Partager via


AdomdConnection.GetSchemaDataSet Method (Guid, Object[])

Returns schema information from a data source by using a Guid object to specify which schema information to return and by applying any specified restrictions to the information.

Espace de noms: Microsoft.AnalysisServices.AdomdClient
Assembly: Microsoft.AnalysisServices.AdomdClient (in microsoft.analysisservices.adomdclient.dll)

Syntaxe

'Déclaration
Public Function GetSchemaDataSet ( _
    schema As Guid, _
    restrictions As Object() _
) As DataSet
public DataSet GetSchemaDataSet (
    Guid schema,
    Object[] restrictions
)
public:
DataSet^ GetSchemaDataSet (
    Guid schema, 
    array<Object^>^ restrictions
)
public DataSet GetSchemaDataSet (
    Guid schema, 
    Object[] restrictions
)
public function GetSchemaDataSet (
    schema : Guid, 
    restrictions : Object[]
) : DataSet

Paramètres

  • schema
    A Guid object that specifies the schema table to be returned.
  • restrictions
    An array of Object objects that specifies the values for the restriction columns that the schema table uses. These values are applied in the order of the restriction columns. That is, the first restriction value applies to the first restriction column, the second restriction value applies to the second restriction column, and so on.

Valeur de retour

A DataSet that represents the contents of the specified OLE DB schema rowset.

Notes

The schema rowset is returned as a DataSet that has the same format as the OLE DB schema rowset specified by the schema parameter. Use the restrictions parameter to filter the rows to be returned in the DataSet. (For example, you can specify restrictions for table name, type, owner, or schema). When you pass values in the array, include empty strings or nulls for array elements that do not contain values. If you pass an empty array to restrictions, all rows are returned in default order. Values in the array correspond to the order of the columns in the OLE DB or OLE DB for OLAP specifications.

If a Guid is provided that is not associated with a schema rowset, or if the schema rowset associated with the provided Guid is not supported by the server, the InvalidOperationException exception is thrown. Similarly, an exception is thrown if an error occurs while retrieving the schema rowset from the provider.

The AdomdSchemaGuid contains a collection of Guid objects that represents the most commonly supported OLE DB and XML for Analysis schema rowsets.

ms125416.note(fr-fr,SQL.90).gifRemarque :
If the schema contains nested rowsets, more tables may be returned in the DataSet.

Sécurité des threads

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

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

AdomdConnection Class
AdomdConnection Members
Microsoft.AnalysisServices.AdomdClient Namespace