Class ReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6>

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

Inheritance

System.Object

StoredProcedureBase<TParameters>

ReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6>

Implements

IReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6>

IRoutine

IDisposable

Inherited Members

StoredProcedureBase<TParameters>.ServiceProvider

StoredProcedureBase<TParameters>.Connector

StoredProcedureBase<TParameters>.Command

StoredProcedureBase<TParameters>.Dispose()

StoredProcedureBase<TParameters>.SetParametersValue(TParameters)

StoredProcedureBase<TParameters>.BeforeInitialize()

StoredProcedureBase<TParameters>.GetRoutineName()

Namespace: Paradigm.ORM.Data.StoredProcedures

Assembly: Paradigm.ORM.Data.dll

Syntax

public class ReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6> : StoredProcedureBase<TParameters>, IReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6>, 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.
TResult3	The type of the third result.
TResult4	The type of the fourth result.
TResult5	The type of the fifth result.
TResult6	The type of the sixth 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

ReaderStoredProcedure(IServiceProvider)

Initializes a new instance of the ReaderStoredProcedure.

Declaration

public ReaderStoredProcedure(IServiceProvider serviceProvider)

Parameters

Type	Name	Description
IServiceProvider	serviceProvider	The service provider.

ReaderStoredProcedure(IServiceProvider, IDatabaseConnector)

Initializes a new instance of the ReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6> class.

Declaration

public ReaderStoredProcedure(IServiceProvider serviceProvider, IDatabaseConnector connector)

Parameters

Type	Name	Description
IServiceProvider	serviceProvider	The service provider.
IDatabaseConnector	connector	The database connector.

ReaderStoredProcedure(IServiceProvider, IDatabaseConnector, IDatabaseReaderMapper<TResult1>, IDatabaseReaderMapper<TResult2>, IDatabaseReaderMapper<TResult3>, IDatabaseReaderMapper<TResult4>, IDatabaseReaderMapper<TResult5>, IDatabaseReaderMapper<TResult6>)

Initializes a new instance of the ReaderStoredProcedure.

Declaration

public ReaderStoredProcedure(IServiceProvider serviceProvider, IDatabaseConnector connector, IDatabaseReaderMapper<TResult1> mapper1, IDatabaseReaderMapper<TResult2> mapper2, IDatabaseReaderMapper<TResult3> mapper3, IDatabaseReaderMapper<TResult4> mapper4, IDatabaseReaderMapper<TResult5> mapper5, IDatabaseReaderMapper<TResult6> mapper6)

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.
IDatabaseReaderMapper<TResult3>	mapper3	The third result mapper.
IDatabaseReaderMapper<TResult4>	mapper4	The fourth result mapper.
IDatabaseReaderMapper<TResult5>	mapper5	The fifth result mapper.
IDatabaseReaderMapper<TResult6>	mapper6	The sixth result mapper.

ReaderStoredProcedure(IDatabaseConnector)

Initializes a new instance of the ReaderStoredProcedure.

Declaration

public ReaderStoredProcedure(IDatabaseConnector connector)

Parameters

Type	Name	Description
IDatabaseConnector	connector	The database connector.

ReaderStoredProcedure(IDatabaseConnector, IDatabaseReaderMapper<TResult1>, IDatabaseReaderMapper<TResult2>, IDatabaseReaderMapper<TResult3>, IDatabaseReaderMapper<TResult4>, IDatabaseReaderMapper<TResult5>, IDatabaseReaderMapper<TResult6>)

Initializes a new instance of the ReaderStoredProcedure.

Declaration

public ReaderStoredProcedure(IDatabaseConnector connector, IDatabaseReaderMapper<TResult1> mapper1, IDatabaseReaderMapper<TResult2> mapper2, IDatabaseReaderMapper<TResult3> mapper3, IDatabaseReaderMapper<TResult4> mapper4, IDatabaseReaderMapper<TResult5> mapper5, IDatabaseReaderMapper<TResult6> mapper6)

Parameters

Type	Name	Description
IDatabaseConnector	connector	The database connector.
IDatabaseReaderMapper<TResult1>	mapper1	The first result mapper.
IDatabaseReaderMapper<TResult2>	mapper2	The second result mapper.
IDatabaseReaderMapper<TResult3>	mapper3	The third result mapper.
IDatabaseReaderMapper<TResult4>	mapper4	The fourth result mapper.
IDatabaseReaderMapper<TResult5>	mapper5	The fifth result mapper.
IDatabaseReaderMapper<TResult6>	mapper6	The sixth result mapper.

Methods

AfterInitialize()

Executes after the initialization.

Declaration

protected override void AfterInitialize()

Overrides

Paradigm.ORM.Data.StoredProcedures.StoredProcedureBase<TParameters>.AfterInitialize()

Execute(TParameters)

Executes the stored procedure and return a list of tuples.

Declaration

public Tuple<List<TResult1>, List<TResult2>, List<TResult3>, List<TResult4>, List<TResult5>, List<TResult6>> Execute(TParameters parameters)

Parameters

Type	Name	Description
TParameters	parameters	The parameters.

Returns

Type	Description
Tuple<List<TResult1>, List<TResult2>, List<TResult3>, List<TResult4>, List<TResult5>, List<TResult6>>	List of tuples.

ExecuteAsync(TParameters)

Executes the stored procedure and return a list of tuples.

Declaration

public Task<Tuple<List<TResult1>, List<TResult2>, List<TResult3>, List<TResult4>, List<TResult5>, List<TResult6>>> ExecuteAsync(TParameters parameters)

Parameters

Type	Name	Description
TParameters	parameters	The parameters.

Returns

Type	Description
Task<Tuple<List<TResult1>, List<TResult2>, List<TResult3>, List<TResult4>, List<TResult5>, List<TResult6>>>	List of tuples.

Implements

IReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6>

IRoutine

IDisposable

Extension Methods

ObjectExtensions.ThrowIfFails<TException>(Object, Action, String)

ObjectExtensions.ThrowIfFails<TException, TResult>(Object, Func<TResult>, String)

ObjectExtensions.ThrowIfFailsAsync<TException>(Object, Func<Task>, String)

ObjectExtensions.ThrowIfFailsAsync<TException, TResult>(Object, Func<Task<TResult>>, String)

See Also

StoredProcedureBase<TParameters>

IReaderStoredProcedure<TParameters, TResult1, TResult2, TResult3, TResult4, TResult5, TResult6>