IMultipleResults.GetResult<TElement> Método

Definição

Namespace:

System.Data.Linq

Assembly:

System.Data.Linq.dll

Recupera o próximo resultado como uma sequência de um tipo especificado.

public:
generic <typename TElement>
 System::Collections::Generic::IEnumerable<TElement> ^ GetResult();

public System.Collections.Generic.IEnumerable<TElement> GetResult<TElement> ();

abstract member GetResult : unit -> seq<'Element>

Public Function GetResult(Of TElement) () As IEnumerable(Of TElement)

Parâmetros de tipo

TElement

O tipo da sequência a ser retornado.

Retornos

IEnumerable<TElement>

Uma enumeração para iterar pelos resultados.

Exemplos

Northwnd db = new Northwnd(@"c:\northwnd.mdf");

// Assign the results of the procedure with an argument
// of (1) to local variable 'result'.
IMultipleResults result = db.VariableResultShapes(1);

// Iterate through the list and write results (the company names)
// to the console.
foreach(VariableResultShapesResult1 compName in
    result.GetResult<VariableResultShapesResult1>())
{
    Console.WriteLine(compName.CompanyName);
}

// Pause to view company names; press Enter to continue.
Console.ReadLine();

// Assign the results of the procedure with an argument
// of (2) to local variable 'result'.
IMultipleResults result2 = db.VariableResultShapes(2);

// Iterate through the list and write results (the order IDs)
// to the console.
foreach (VariableResultShapesResult2 ord in
    result2.GetResult<VariableResultShapesResult2>())
{
    Console.WriteLine(ord.OrderID);
}

Dim db As New Northwnd("c:\northwnd.mdf")

' Assign the results of the procedure with an argument
' of (1) to local variable 'result'.
Dim result As IMultipleResults = db.VariableResultShapes(1)

' Iterate through the list and write results (the company name)
' to the console.
For Each compName As VariableResultShapesResult1 _
    In result.GetResult(Of VariableResultShapesResult1)()
    Console.WriteLine(compName.CompanyName)
Next

' Pause to view company names; press Enter to continue.
Console.ReadLine()

' Assign the results of the procedure with an argument
' of (2) to local variable 'result.'
Dim result2 As IMultipleResults = db.VariableResultShapes(2)

' Iterate through the list and write results (the order IDs)
' to the console.
For Each ord As VariableResultShapesResult2 _
    In result2.GetResult(Of VariableResultShapesResult2)()
    Console.WriteLine(ord.OrderID)
Next

Comentários

Você usaria código semelhante ao seguinte para executar este procedimento armazenado.

Observação

Você deve usar o padrão de GetResult para obter um enumerador do tipo correto, com base no seu conhecimento do procedimento armazenado.