Class DbProvider

Inheritance

System.Object

DbProvider

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Pandv.DataAccess

Assembly: cs.temp.dll.dll

Syntax

public class DbProvider : IDbProvider

Constructors

DbProvider(IConfig, IServiceProvider)

Declaration

public DbProvider(IConfig config, IServiceProvider serviceProvider)

Parameters

Type	Name	Description
IConfig	config
IServiceProvider	serviceProvider

Fields

DbConfigKey

Declaration

public const string DbConfigKey = "DB"

Field Value

Type	Description
System.String

Properties

SqlConfigs

Declaration

public Dictionary<string, DbSql> SqlConfigs { get; protected set; }

Property Value

Type	Description
System.Collections.Generic.Dictionary<System.String, DbSql>

Methods

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

Declaration

public 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

Implements

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

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

Declaration

public 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

Implements

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

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

Declaration

public 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>

Implements

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

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

Declaration

public 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

Implements

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

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

Declaration

public 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

Implements

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

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

Declaration

public 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

Implements

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

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

Declaration

public 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>

Implements

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

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

Declaration

public 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

Implements

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

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

Declaration

public 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

Implements

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

GetConnection()

Declaration

public IDbConnection GetConnection()

Returns

Type	Description
IDbConnection

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

Declaration

public 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

Implements

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

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

Declaration

public 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

Implements

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

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

Declaration

public 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

Implements

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

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

Declaration

public 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>

Implements

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

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

Declaration

public SqlMapper.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
SqlMapper.GridReader

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

Declaration

public Task<SqlMapper.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<SqlMapper.GridReader>