Interface IDbProvider

Namespace: Pandv.DataAccess

Assembly: cs.temp.dll.dll

Syntax

public interface IDbProvider

Methods

Exec<T>(String, Object, IDbTransaction, CommandFlags, CancellationToken, Func<IDbConnection, CommandDefinition, T>)

Declaration

T Exec<T>(string commandName, object parameters, IDbTransaction transaction, CommandFlags flags, CancellationToken cancellationToken, Func<IDbConnection, CommandDefinition, T> func)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken
Func<IDbConnection, CommandDefinition, T>	func

Returns

Type	Description
T

Type Parameters

Name	Description
T

Execute(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

int Execute(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
System.Int32

ExecuteAsync(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

Task<int> ExecuteAsync(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
Task<System.Int32>

ExecuteBulkCopy<T>(String, List<T>)

Declaration

void ExecuteBulkCopy<T>(string commandName, List<T> parameters)

Parameters

Type	Name	Description
System.String	commandName
System.Collections.Generic.List<T>	parameters

Type Parameters

Name	Description
T

ExecuteBulkCopyAsync<T>(String, List<T>)

Declaration

Task ExecuteBulkCopyAsync<T>(string commandName, List<T> parameters)

Parameters

Type	Name	Description
System.String	commandName
System.Collections.Generic.List<T>	parameters

Returns

Type	Description
Task

Type Parameters

Name	Description
T

ExecuteReader(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

IDataReader ExecuteReader(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
IDataReader

ExecuteReaderAsync(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

Task<IDataReader> ExecuteReaderAsync(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
Task<IDataReader>

ExecuteScalar<T>(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

T ExecuteScalar<T>(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
T

Type Parameters

Name	Description
T

ExecuteScalarAsync<T>(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

Task<T> ExecuteScalarAsync<T>(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
Task<T>

Type Parameters

Name	Description
T

Query<T>(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

IEnumerable<T> Query<T>(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
System.Collections.Generic.IEnumerable<T>

Type Parameters

Name	Description
T

QueryAsync<T>(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

Task<IEnumerable<T>> QueryAsync<T>(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
Task<System.Collections.Generic.IEnumerable<T>>

Type Parameters

Name	Description
T

QueryFirstOrDefault<T>(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

T QueryFirstOrDefault<T>(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
T

Type Parameters

Name	Description
T

QueryFirstOrDefaultAsync(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

Task<dynamic> QueryFirstOrDefaultAsync(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
Task<System.Object>

QueryMultiple(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

GridReader QueryMultiple(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
GridReader

QueryMultipleAsync(String, Object, IDbTransaction, CommandFlags, CancellationToken)

Declaration

Task<GridReader> QueryMultipleAsync(string commandName, object parameters = null, IDbTransaction transaction = null, CommandFlags flags = null, CancellationToken cancellationToken = null)

Parameters

Type	Name	Description
System.String	commandName
System.Object	parameters
IDbTransaction	transaction
CommandFlags	flags
CancellationToken	cancellationToken

Returns

Type	Description
Task<GridReader>