IMultipleResults Interface
.NET Framework (current version)
Represents the results of mapped functions or queries with variable return sequences.
Assembly: System.Data.Linq (in System.Data.Linq.dll)
| Name | Description | |
|---|---|---|
![]() | ReturnValue | Gets the return value of a function.(Inherited from IFunctionResult.) |
| Name | Description | |
|---|---|---|
![]() | 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. |
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.
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)); }
.NET Framework
Available since 3.5
Available since 3.5
Show:
.jpeg?cs-save-lang=1&cs-lang=csharp)
.jpeg?cs-save-lang=1&cs-lang=csharp)