Session.GetObjectsFromSproc<T>(String, OperandValue[]) Method

SECURITY-RELATED CONSIDERATIONS

This method executes a raw stored procedure. Always validate, sanitize, or parameterize externally supplied names and values to prevent unauthorized access to sensitive information.

Executes a stored procedure and returns its result set as a collection of objects of a non-persistent type specified by the generic type parameter.

Namespace : DevExpress.Xpo

Assembly : DevExpress.Xpo.v25.2.dll

NuGet Package : DevExpress.Xpo

csharp

public ICollection<T> GetObjectsFromSproc<T>(
    string sprocName,
    params OperandValue[] parameters
)

Public Function GetObjectsFromSproc(Of T)(
    sprocName As String,
    ParamArray parameters As OperandValue()
) As ICollection(Of T)

Parameters

Name	Type	Description
sprocName	String

A String value that specifies the stored procedure’s name.

| | parameters | OperandValue[] |

An array of OperandValue objects representing parameters to pass to the stored procedure.

Type Parameters

Name	Description
T

The type of objects returned by the method. A class that implements this type sould be decorated with NonPersistentAttribute.

Returns

Type	Description
ICollection<T>

A collection of non-persistent objects of the specified type that are instantiated with data obtained via the specified stored procedure.

Remarks

This method performs the following:

Executes the specified stored procedure with parameters and obtains the result as a result set.
Creates objects of the specified type and instantiates them with the result set’s data, and populates a collection with these objects. The type and the order of object members should exactly match the result set’s columns. Note that the GetObjectsFromSproc<T> method’s generic type parameter should specify a non-persistent class decorated with a NonPersistentAttribute.

Note

The GetObjectsFromSproc<T> method throws an exception if object members include any of the following:

A property that is not defined within the T type.
A struct type member.
A reference to a class with a struct type member.
A collection used in object relations.

To learn more about executing stored procedures in XPO and retrieving objects from the results, refer to Stored Procedures.