.png)
TupleCollection Class
SQL Server 2012
Namespace: Microsoft.AnalysisServices.AdomdClient
Assembly: Microsoft.AnalysisServices.AdomdClient (in Microsoft.AnalysisServices.AdomdClient.dll)
The TupleCollection type exposes the following members.
| Name | Description | |
|---|---|---|
 | Count | Gets the number of Tuple objects in the collection. |
| IsSynchronized | Gets a value indicating whether access to the collection is synchronized (thread safe). |
| Item | Gets the specified Tuple from the collection by its index. In C#, this property is the indexer for the TupleCollection class. |
| SyncRoot | Gets a System.Object that can be used to synchronize access to the collection. |
| Name | Description | |
|---|---|---|
| ICollection.CopyTo | Copies the elements of the TupleCollection to the specified array, starting at a particular array index. |
| IEnumerable.GetEnumerator | Gets the enumerator that iterates through the TupleCollection. |
The following subroutine, given a CellSet and the total number of cells for which information should be displayed, iterates through the Tuples collection and displays information for each tuple:
Public Sub ListTupleCollection(ByRef AxisToCheck As Axis, _
Optional ByVal Count As Integer = 10)
' Because a Set object can represent thousands of tuples,
' the Count parameter limits the output to a
' specified number of cells.
' Check the parameter before performing actions on it.
If AxisToCheck Is Nothing Then
Throw New System.ArgumentNullException("AxisToCheck")
Else
' Iterate through the Tuples collection of the
' Set object.
Try
Dim tupleToCheck As Tuple
Dim tupleCount As Integer
Dim tupleIndex As Integer
tupleCount = AxisToCheck.Set.Tuples.Count
Debug.WriteLine("Found " & tupleCount & _
" tuple(s) in axis:")
If tupleCount > Count Then tupleCount = Count
If tupleCount > 0 Then
For tupleIndex = 0 To tupleCount
tupleToCheck = AxisToCheck.Set.Tuples(tupleIndex)
Debug.WriteLine("Tuple: " & _
tupleToCheck.TupleOrdinal)
Debug.WriteLine(" No. of members: " & _
tupleToCheck.Members.Count)
Next
End If
Catch ex As AdomdConnectionException
' The connection could not be opened or was disconnected.
' This error can occur at any time, if the provider is
' disconnected from the server.
Debug.WriteLine(ex)
Throw ex
Catch ex As AdomdErrorResponseException
' A response is received from a provider which indicates an error.
Debug.WriteLine(ex)
Throw ex
Catch ex As AdomdUnknownResponseException
' A response has been returned from the provider that
' was not understood.
Debug.WriteLine(ex)
Throw ex
Catch ex As AdomdCacheExpiredException
' A cached version of an ADOMD.NET object is no longer valid.
' This error is typically raised when reviewing metadata.
Debug.WriteLine(ex)
Throw ex
Catch ex As AdomdException
' Any other error raised by ADOMD.NET.
Debug.WriteLine(ex)
Throw ex
Catch ex As Exception
' Any other error.
Debug.WriteLine(ex)
Throw ex
End Try
End If
End Sub
