IMultipleResults Interface

Definitie

public interface class IMultipleResults : IDisposable, System::Data::Linq::IFunctionResult

public interface IMultipleResults : IDisposable, System.Data.Linq.IFunctionResult

type IMultipleResults = interface
    interface IFunctionResult
    interface IDisposable

Public Interface IMultipleResults
Implements IDisposable, IFunctionResult

Implementeringen

IFunctionResult IDisposable

Voorbeelden

CREATE PROCEDURE VariableResultShapes(@shape int)
AS
if(@shape = 1)
    select CustomerID, ContactTitle, CompanyName from customers
else if(@shape = 2)
    select OrderID, ShipName from orders

[Function(Name="dbo.VariableResultShapes")]
[ResultType(typeof(VariableResultShapesResult1))]
[ResultType(typeof(VariableResultShapesResult2))]
public IMultipleResults VariableResultShapes([Parameter(DbType="Int")] System.Nullable<int> shape)
{
    IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), shape);
    return ((IMultipleResults)(result.ReturnValue));
}

<FunctionAttribute(Name:="dbo.VariableResultShapes"), _
ResultType(GetType(VariableResultShapesResult1)), _
ResultType(GetType(VariableResultShapesResult2))> _
Public Function VariableResultShapes(<Parameter(DbType:="Int")> ByVal shape As System.Nullable(Of Integer)) As IMultipleResults
    Dim result As IExecuteResult = Me.ExecuteMethodCall(Me, CType(MethodInfo.GetCurrentMethod, MethodInfo), shape)
    Return CType(result.ReturnValue, IMultipleResults)
End Function

Opmerkingen

In het volgende SQL-codevoorbeeld is de resultaatshape afhankelijk van de invoer (shape =1 of shape = 2). De volgorde van de projecties die worden geretourneerd, is niet gedefinieerd.