IMultipleResults.GetResult<TElement> Método

  • Referencia

Definición

Espacio de nombres:
System.Data.Linq
Ensamblado:
System.Data.Linq.dll

Recupera el resultado siguiente como una secuencia de un 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

Tipo de la secuencia que se va a devolver.

Devoluciones

IEnumerable<TElement>

Enumeración para recorrer en iteración los resultados.

Ejemplos

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

Comentarios

Usaría código similar al siguiente para ejecutar este procedimiento almacenado.

Nota

Debe utilizar el patrón GetResult para obtener un enumerador del tipo correcto, basado en su conocimiento del procedimiento almacenado.

Se aplica a