IMultipleResults Interface

Definition

Namespace:

System.Data.Linq

Assembly:

System.Data.Linq.dll

Represents the results of mapped functions or queries with variable return sequences.

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

Implements

IFunctionResult IDisposable

Examples

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

Remarks

In the following SQL code example, the result shape depends on the input (shape =1 or shape = 2). The order that the projections are returned is undefined.

Properties

ReturnValue

Gets the return value of a function. (Inherited from IFunctionResult)

Methods

Dispose()	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable)
GetResult<TElement>()	Retrieves the next result as a sequence of a specified type.