Class ReaderStoredProcedure<TParameters, TResult1, TResult2>

Provides the means to execute data reader stored procedures returning only 2 result sets.

Inheritance
System.Object
StoredProcedureBase<TParameters>
ReaderStoredProcedure<TParameters, TResult1, TResult2>
Implements
IReaderStoredProcedure<TParameters, TResult1, TResult2>
IDisposable
Inherited Members
Namespace: Paradigm.ORM.Data.StoredProcedures
Assembly: Paradigm.ORM.Data.dll
Syntax
public class ReaderStoredProcedure<TParameters, TResult1, TResult2> : StoredProcedureBase<TParameters>, IReaderStoredProcedure<TParameters, TResult1, TResult2>, IRoutine, IDisposable
Type Parameters
Name Description
TParameters

The type of the parameters.
TResult1

The type of the first result.
TResult2

The type of the second result.
Remarks

Instead of sending individual parameters to the procedure, the orm expects a type containing or referencing the mapping information, where individual parameters will be mapped to properties.

Constructors

| Improve this Doc View Source

ReaderStoredProcedure(IServiceProvider)

Initializes a new instance of the ReaderStoredProcedure.

Declaration
public ReaderStoredProcedure(IServiceProvider serviceProvider)
Parameters
Type Name Description
IServiceProvider serviceProvider

The service provider.
| Improve this Doc View Source

ReaderStoredProcedure(IServiceProvider, IDatabaseConnector)

Initializes a new instance of the ReaderStoredProcedure<TParameters, TResult1, TResult2> class.

Declaration
public ReaderStoredProcedure(IServiceProvider serviceProvider, IDatabaseConnector connector)
Parameters
Type Name Description
IServiceProvider serviceProvider

The service provider.
IDatabaseConnector connector

The database connector.
| Improve this Doc View Source

ReaderStoredProcedure(IServiceProvider, IDatabaseConnector, IDatabaseReaderMapper<TResult1>, IDatabaseReaderMapper<TResult2>)

Initializes a new instance of the ReaderStoredProcedure.

Declaration
public ReaderStoredProcedure(IServiceProvider serviceProvider, IDatabaseConnector connector, IDatabaseReaderMapper<TResult1> mapper1, IDatabaseReaderMapper<TResult2> mapper2)
Parameters
Type Name Description
IServiceProvider serviceProvider

The service provider.
IDatabaseConnector connector

The database connector.
IDatabaseReaderMapper<TResult1> mapper1

The first result mapper.
IDatabaseReaderMapper<TResult2> mapper2

The second result mapper.
| Improve this Doc View Source

ReaderStoredProcedure(IDatabaseConnector)

Initializes a new instance of the ReaderStoredProcedure.

Declaration
public ReaderStoredProcedure(IDatabaseConnector connector)
Parameters
Type Name Description
IDatabaseConnector connector

The database connector.
| Improve this Doc View Source

ReaderStoredProcedure(IDatabaseConnector, IDatabaseReaderMapper<TResult1>, IDatabaseReaderMapper<TResult2>)

Initializes a new instance of the ReaderStoredProcedure.

Declaration
public ReaderStoredProcedure(IDatabaseConnector connector, IDatabaseReaderMapper<TResult1> mapper1, IDatabaseReaderMapper<TResult2> mapper2)
Parameters
Type Name Description
IDatabaseConnector connector

The database connector.
IDatabaseReaderMapper<TResult1> mapper1

The first result mapper.
IDatabaseReaderMapper<TResult2> mapper2

The second result mapper.

Methods

| Improve this Doc View Source

AfterInitialize()

Executes after the initialization.

Declaration
protected override void AfterInitialize()
Overrides
Paradigm.ORM.Data.StoredProcedures.StoredProcedureBase<TParameters>.AfterInitialize()
| Improve this Doc View Source

Execute(TParameters)

Executes the stored procedure and return a list of tuples.

Declaration
public Tuple<List<TResult1>, List<TResult2>> Execute(TParameters parameters)
Parameters
Type Name Description
TParameters parameters

The parameters.
Returns
Type Description
Tuple<List<TResult1>, List<TResult2>>

List of tuples.
| Improve this Doc View Source

ExecuteAsync(TParameters)

Executes the stored procedure and return a list of tuples.

Declaration
public Task<Tuple<List<TResult1>, List<TResult2>>> ExecuteAsync(TParameters parameters)
Parameters
Type Name Description
TParameters parameters

The parameters.
Returns
Type Description
Task<Tuple<List<TResult1>, List<TResult2>>>

List of tuples.

Implements

IDisposable

Extension Methods

See Also

StoredProcedureBase<TParameters>
IReaderStoredProcedure<TParameters, TResult1, TResult2>