Class NonQueryStoredProcedure<TParameters>

Provides the means to execute non query stored procedures.

Inheritance

System.Object

StoredProcedureBase<TParameters>

NonQueryStoredProcedure<TParameters>

Implements

INonQueryStoredProcedure<TParameters>

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>.AfterInitialize()

StoredProcedureBase<TParameters>.GetRoutineName()

Namespace: Paradigm.ORM.Data.StoredProcedures

Assembly: Paradigm.ORM.Data.dll

Syntax

public class NonQueryStoredProcedure<TParameters> : StoredProcedureBase<TParameters>, INonQueryStoredProcedure<TParameters>, IRoutine, IDisposable

Type Parameters

Name	Description
TParameters	The type of the parameters.

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

NonQueryStoredProcedure(IServiceProvider)

Initializes a new instance of the NonQueryStoredProcedure<TParameters> class.

Declaration

public NonQueryStoredProcedure(IServiceProvider serviceProvider)

Parameters

Type	Name	Description
IServiceProvider	serviceProvider	The service provider.

NonQueryStoredProcedure(IServiceProvider, IDatabaseConnector)

Initializes a new instance of the NonQueryStoredProcedure<TParameters> class.

Declaration

public NonQueryStoredProcedure(IServiceProvider serviceProvider, IDatabaseConnector connector)

Parameters

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

NonQueryStoredProcedure(IDatabaseConnector)

Initializes a new instance of the NonQueryStoredProcedure<TParameters> class.

Declaration

public NonQueryStoredProcedure(IDatabaseConnector connector)

Parameters

Type	Name	Description
IDatabaseConnector	connector	The database connector.

Methods

ExecuteNonQuery(TParameters)

Executes the stored procedure as a non query.

Declaration

public int ExecuteNonQuery(TParameters parameters)

Parameters

Type	Name	Description
TParameters	parameters	The parameters.

Returns

Type	Description
System.Int32	Number of affected rows.

ExecuteNonQueryAsync(TParameters)

Executes the stored procedure as a non query.

Declaration

public Task<int> ExecuteNonQueryAsync(TParameters parameters)

Parameters

Type	Name	Description
TParameters	parameters	The parameters.

Returns

Type	Description
Task<System.Int32>	Number of affected rows.

Implements

INonQueryStoredProcedure<TParameters>

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>

INonQueryStoredProcedure<TParameters>