Class AdoProvider

Inheritance

System.Object

AdoProvider

Implements

IAdo

System.IDisposable

Inherited Members

System.Object.Equals(System.Object)

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

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

System.Object.ToString()

Namespace: FreeSql.Internal.CommonProvider

Assembly: FreeSql.dll

Syntax

public abstract class AdoProvider : IAdo, IDisposable

Constructors

AdoProvider(DataType, String, String[])

Declaration

public AdoProvider(DataType dataType, string connectionString, string[] slaveConnectionStrings)

Parameters

Type	Name	Description
DataType	dataType
System.String	connectionString
System.String[]	slaveConnectionStrings

Fields

ResolveTransaction

Declaration

protected Func<DbTransaction> ResolveTransaction

Field Value

Type	Description
System.Func<System.Data.Common.DbTransaction>

slaveUnavailables

Declaration

protected int slaveUnavailables

Field Value

Type	Description
System.Int32

Properties

_util

Declaration

public CommonUtils _util { get; set; }

Property Value

Type	Description
CommonUtils

ConnectionString

Declaration

public string ConnectionString { get; protected set; }

Property Value

Type	Description
System.String

DataType

Declaration

public DataType DataType { get; }

Property Value

Type	Description
DataType

Identifier

Declaration

public Guid Identifier { get; protected set; }

Property Value

Type	Description
System.Guid

IsTracePerformance

Declaration

protected bool IsTracePerformance { get; }

Property Value

Type	Description
System.Boolean

MasterPool

Declaration

public IObjectPool<DbConnection> MasterPool { get; protected set; }

Property Value

Type	Description
IObjectPool<System.Data.Common.DbConnection>

SlaveConnectionStrings

Declaration

public string[] SlaveConnectionStrings { get; protected set; }

Property Value

Type	Description
System.String[]

SlavePools

Declaration

public List<IObjectPool<DbConnection>> SlavePools { get; }

Property Value

Type	Description
System.Collections.Generic.List<IObjectPool<System.Data.Common.DbConnection>>

TransactionCurrentThread

Declaration

public DbTransaction TransactionCurrentThread { get; }

Property Value

Type	Description
System.Data.Common.DbTransaction

TransactionCurrentThreadAopBefore

Declaration

public TraceBeforeEventArgs TransactionCurrentThreadAopBefore { get; }

Property Value

Type	Description
TraceBeforeEventArgs

Methods

Addslashes(String, Object[])

Declaration

public string Addslashes(string filter, params object[] parms)

Parameters

Type	Name	Description
System.String	filter
System.Object[]	parms

Returns

Type	Description
System.String

AddslashesIEnumerable(Object, Type, ColumnInfo)

Declaration

protected string AddslashesIEnumerable(object param, Type mapType, ColumnInfo mapColumn)

Parameters

Type	Name	Description
System.Object	param
System.Type	mapType
ColumnInfo	mapColumn

Returns

Type	Description
System.String

AddslashesProcessParam(Object, Type, ColumnInfo)

Declaration

public abstract object AddslashesProcessParam(object param, Type mapType, ColumnInfo mapColumn)

Parameters

Type	Name	Description
System.Object	param
System.Type	mapType
ColumnInfo	mapColumn

Returns

Type	Description
System.Object

BeginTransaction(Nullable<IsolationLevel>)

Declaration

public void BeginTransaction(IsolationLevel? isolationLevel)

Parameters

Type	Name	Description
System.Nullable<System.Data.IsolationLevel>	isolationLevel

CommandFluent(String, Object)

Declaration

public AdoCommandFluent CommandFluent(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
AdoCommandFluent

CommitTransaction()

Declaration

public void CommitTransaction()

CreateCommand()

Declaration

public abstract DbCommand CreateCommand()

Returns

Type	Description
System.Data.Common.DbCommand

Dispose()

Declaration

public void Dispose()

ExecuteArray(CommandType, String, DbParameter[])

Declaration

public object[][] ExecuteArray(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Object[][]

ExecuteArray(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public object[][] ExecuteArray(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Object[][]

ExecuteArray(DbConnection, DbTransaction, String, Object)

Declaration

public object[][] ExecuteArray(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Object[][]

ExecuteArray(DbTransaction, CommandType, String, DbParameter[])

Declaration

public object[][] ExecuteArray(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Object[][]

ExecuteArray(DbTransaction, String, Object)

Declaration

public object[][] ExecuteArray(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Object[][]

ExecuteArray(String, Object)

Declaration

public object[][] ExecuteArray(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Object[][]

ExecuteArrayAsync(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<object[][]> ExecuteArrayAsync(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object[][]>

ExecuteArrayAsync(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<object[][]> ExecuteArrayAsync(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object[][]>

ExecuteArrayAsync(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<object[][]> ExecuteArrayAsync(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object[][]>

ExecuteArrayAsync(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<object[][]> ExecuteArrayAsync(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object[][]>

ExecuteArrayAsync(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<object[][]> ExecuteArrayAsync(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object[][]>

ExecuteArrayAsync(String, Object, CancellationToken)

Declaration

public Task<object[][]> ExecuteArrayAsync(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object[][]>

ExecuteConnectTest(Int32)

Declaration

public bool ExecuteConnectTest(int commandTimeout = 0)

Parameters

Type	Name	Description
System.Int32	commandTimeout

Returns

Type	Description
System.Boolean

ExecuteConnectTestAsync(Int32, CancellationToken)

Declaration

public async Task<bool> ExecuteConnectTestAsync(int commandTimeout = 0, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Int32	commandTimeout
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Boolean>

ExecuteDataSet(CommandType, String, DbParameter[])

Declaration

public DataSet ExecuteDataSet(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Data.DataSet

ExecuteDataSet(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public DataSet ExecuteDataSet(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Data.DataSet

ExecuteDataSet(DbConnection, DbTransaction, String, Object)

Declaration

public DataSet ExecuteDataSet(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Data.DataSet

ExecuteDataSet(DbTransaction, CommandType, String, DbParameter[])

Declaration

public DataSet ExecuteDataSet(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Data.DataSet

ExecuteDataSet(DbTransaction, String, Object)

Declaration

public DataSet ExecuteDataSet(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Data.DataSet

ExecuteDataSet(String, Object)

Declaration

public DataSet ExecuteDataSet(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Data.DataSet

ExecuteDataSetAsync(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<DataSet> ExecuteDataSetAsync(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDataSetAsync(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<DataSet> ExecuteDataSetAsync(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDataSetAsync(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<DataSet> ExecuteDataSetAsync(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDataSetAsync(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<DataSet> ExecuteDataSetAsync(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDataSetAsync(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<DataSet> ExecuteDataSetAsync(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDataSetAsync(String, Object, CancellationToken)

Declaration

public Task<DataSet> ExecuteDataSetAsync(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataSet>

ExecuteDataTable(CommandType, String, DbParameter[])

Declaration

public DataTable ExecuteDataTable(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Data.DataTable

ExecuteDataTable(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public DataTable ExecuteDataTable(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Data.DataTable

ExecuteDataTable(DbConnection, DbTransaction, String, Object)

Declaration

public DataTable ExecuteDataTable(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Data.DataTable

ExecuteDataTable(DbTransaction, CommandType, String, DbParameter[])

Declaration

public DataTable ExecuteDataTable(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Data.DataTable

ExecuteDataTable(DbTransaction, String, Object)

Declaration

public DataTable ExecuteDataTable(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Data.DataTable

ExecuteDataTable(String, Object)

Declaration

public DataTable ExecuteDataTable(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Data.DataTable

ExecuteDataTableAsync(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<DataTable> ExecuteDataTableAsync(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataTable>

ExecuteDataTableAsync(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<DataTable> ExecuteDataTableAsync(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataTable>

ExecuteDataTableAsync(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<DataTable> ExecuteDataTableAsync(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataTable>

ExecuteDataTableAsync(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<DataTable> ExecuteDataTableAsync(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataTable>

ExecuteDataTableAsync(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<DataTable> ExecuteDataTableAsync(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataTable>

ExecuteDataTableAsync(String, Object, CancellationToken)

Declaration

public Task<DataTable> ExecuteDataTableAsync(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Data.DataTable>

ExecuteNonQuery(CommandType, String, DbParameter[])

Declaration

public int ExecuteNonQuery(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Int32

ExecuteNonQuery(DbConnection, DbTransaction, CommandType, String, Int32, Action<DbCommand>, DbParameter[])

Declaration

public int ExecuteNonQuery(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, Action<DbCommand> cmdAfterHandler, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Action<System.Data.Common.DbCommand>	cmdAfterHandler
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Int32

ExecuteNonQuery(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public int ExecuteNonQuery(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Int32

ExecuteNonQuery(DbConnection, DbTransaction, String, Object)

Declaration

public int ExecuteNonQuery(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Int32

ExecuteNonQuery(DbTransaction, CommandType, String, DbParameter[])

Declaration

public int ExecuteNonQuery(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Int32

ExecuteNonQuery(DbTransaction, String, Object)

Declaration

public int ExecuteNonQuery(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Int32

ExecuteNonQuery(String, Object)

Declaration

public int ExecuteNonQuery(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Int32

ExecuteNonQueryAsync(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<int> ExecuteNonQueryAsync(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteNonQueryAsync(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public Task<int> ExecuteNonQueryAsync(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteNonQueryAsync(DbConnection, DbTransaction, CommandType, String, Int32, Func<DbCommand, Task>, DbParameter[], CancellationToken)

Declaration

public async Task<int> ExecuteNonQueryAsync(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, Func<DbCommand, Task> cmdAfterHandler, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Func<System.Data.Common.DbCommand, System.Threading.Tasks.Task>	cmdAfterHandler
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteNonQueryAsync(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<int> ExecuteNonQueryAsync(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteNonQueryAsync(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<int> ExecuteNonQueryAsync(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteNonQueryAsync(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<int> ExecuteNonQueryAsync(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteNonQueryAsync(String, Object, CancellationToken)

Declaration

public Task<int> ExecuteNonQueryAsync(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Int32>

ExecuteReader(Action<FetchCallbackArgs<DbDataReader>>, CommandType, String, DbParameter[])

Declaration

public void ExecuteReader(Action<FetchCallbackArgs<DbDataReader>> fetchHandler, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Action<FetchCallbackArgs<System.Data.Common.DbDataReader>>	fetchHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

ExecuteReader(Action<FetchCallbackArgs<DbDataReader>>, String, Object)

Declaration

public void ExecuteReader(Action<FetchCallbackArgs<DbDataReader>> fetchHandler, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Action<FetchCallbackArgs<System.Data.Common.DbDataReader>>	fetchHandler
System.String	cmdText
System.Object	parms

ExecuteReader(DbConnection, DbTransaction, Action<FetchCallbackArgs<DbDataReader>>, CommandType, String, Int32, DbParameter[])

Declaration

public void ExecuteReader(DbConnection connection, DbTransaction transaction, Action<FetchCallbackArgs<DbDataReader>> fetchHandler, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Action<FetchCallbackArgs<System.Data.Common.DbDataReader>>	fetchHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

ExecuteReader(DbConnection, DbTransaction, Action<FetchCallbackArgs<DbDataReader>>, String, Object)

Declaration

public void ExecuteReader(DbConnection connection, DbTransaction transaction, Action<FetchCallbackArgs<DbDataReader>> fetchHandler, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Action<FetchCallbackArgs<System.Data.Common.DbDataReader>>	fetchHandler
System.String	cmdText
System.Object	parms

ExecuteReader(DbTransaction, Action<FetchCallbackArgs<DbDataReader>>, CommandType, String, DbParameter[])

Declaration

public void ExecuteReader(DbTransaction transaction, Action<FetchCallbackArgs<DbDataReader>> fetchHandler, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Action<FetchCallbackArgs<System.Data.Common.DbDataReader>>	fetchHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

ExecuteReader(DbTransaction, Action<FetchCallbackArgs<DbDataReader>>, String, Object)

Declaration

public void ExecuteReader(DbTransaction transaction, Action<FetchCallbackArgs<DbDataReader>> fetchHandler, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Action<FetchCallbackArgs<System.Data.Common.DbDataReader>>	fetchHandler
System.String	cmdText
System.Object	parms

ExecuteReaderAsync(DbConnection, DbTransaction, Func<FetchCallbackArgs<DbDataReader>, Task>, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public Task ExecuteReaderAsync(DbConnection connection, DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> fetchHandler, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Threading.Tasks.Task>	fetchHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task

ExecuteReaderAsync(DbConnection, DbTransaction, Func<FetchCallbackArgs<DbDataReader>, Task>, String, Object, CancellationToken)

Declaration

public Task ExecuteReaderAsync(DbConnection connection, DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> fetchHandler, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Threading.Tasks.Task>	fetchHandler
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task

ExecuteReaderAsync(DbTransaction, Func<FetchCallbackArgs<DbDataReader>, Task>, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task ExecuteReaderAsync(DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> fetchHandler, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Threading.Tasks.Task>	fetchHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task

ExecuteReaderAsync(DbTransaction, Func<FetchCallbackArgs<DbDataReader>, Task>, String, Object, CancellationToken)

Declaration

public Task ExecuteReaderAsync(DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> fetchHandler, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Threading.Tasks.Task>	fetchHandler
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task

ExecuteReaderAsync(Func<FetchCallbackArgs<DbDataReader>, Task>, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task ExecuteReaderAsync(Func<FetchCallbackArgs<DbDataReader>, Task> fetchHandler, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Threading.Tasks.Task>	fetchHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task

ExecuteReaderAsync(Func<FetchCallbackArgs<DbDataReader>, Task>, String, Object, CancellationToken)

Declaration

public Task ExecuteReaderAsync(Func<FetchCallbackArgs<DbDataReader>, Task> fetchHandler, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Threading.Tasks.Task>	fetchHandler
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task

ExecuteReaderMultiple(Int32, DbConnection, DbTransaction, Action<FetchCallbackArgs<DbDataReader>, Int32>, Action<DbDataReader, Int32>, CommandType, String, Int32, DbParameter[])

Declaration

public void ExecuteReaderMultiple(int multipleResult, DbConnection connection, DbTransaction transaction, Action<FetchCallbackArgs<DbDataReader>, int> fetchHandler, Action<DbDataReader, int> schemaHandler, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Int32	multipleResult
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Action<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Int32>	fetchHandler
System.Action<System.Data.Common.DbDataReader, System.Int32>	schemaHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

ExecuteReaderMultipleAsync(Int32, DbConnection, DbTransaction, Func<FetchCallbackArgs<DbDataReader>, Int32, Task>, Action<DbDataReader, Int32>, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task ExecuteReaderMultipleAsync(int multipleResult, DbConnection connection, DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, int, Task> fetchHandler, Action<DbDataReader, int> schemaHandler, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Int32	multipleResult
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Int32, System.Threading.Tasks.Task>	fetchHandler
System.Action<System.Data.Common.DbDataReader, System.Int32>	schemaHandler
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task

ExecuteScalar(CommandType, String, DbParameter[])

Declaration

public object ExecuteScalar(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Object

ExecuteScalar(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public object ExecuteScalar(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Object

ExecuteScalar(DbConnection, DbTransaction, String, Object)

Declaration

public object ExecuteScalar(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Object

ExecuteScalar(DbTransaction, CommandType, String, DbParameter[])

Declaration

public object ExecuteScalar(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
System.Object

ExecuteScalar(DbTransaction, String, Object)

Declaration

public object ExecuteScalar(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Object

ExecuteScalar(String, Object)

Declaration

public object ExecuteScalar(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
System.Object

ExecuteScalarAsync(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<object> ExecuteScalarAsync(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<object> ExecuteScalarAsync(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<object> ExecuteScalarAsync(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<object> ExecuteScalarAsync(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<object> ExecuteScalarAsync(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

ExecuteScalarAsync(String, Object, CancellationToken)

Declaration

public Task<object> ExecuteScalarAsync(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Object>

Finalize()

Declaration

protected void Finalize()

GetDbParamtersByObject(Object)

Declaration

public DbParameter[] GetDbParamtersByObject(object obj)

Parameters

Type	Name	Description
System.Object	obj

Returns

Type	Description
System.Data.Common.DbParameter[]

GetDbParamtersByObject(String, Object)

Declaration

public abstract DbParameter[] GetDbParamtersByObject(string sql, object obj)

Parameters

Type	Name	Description
System.String	sql
System.Object	obj

Returns

Type	Description
System.Data.Common.DbParameter[]

IsFromSlave(String)

Declaration

public static bool IsFromSlave(string cmdText)

Parameters

Type	Name	Description
System.String	cmdText

Returns

Type	Description
System.Boolean

Query<T>(CommandType, String, DbParameter[])

Declaration

public List<T> Query<T>(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

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

Type Parameters

Name	Description
T

Query<T>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public List<T> Query<T>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

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

Type Parameters

Name	Description
T

Query<T>(DbConnection, DbTransaction, String, Object)

Declaration

public List<T> Query<T>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

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

Type Parameters

Name	Description
T

Query<T>(DbTransaction, CommandType, String, DbParameter[])

Declaration

public List<T> Query<T>(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

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

Type Parameters

Name	Description
T

Query<T>(DbTransaction, String, Object)

Declaration

public List<T> Query<T>(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

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

Type Parameters

Name	Description
T

Query<T>(String, Object)

Declaration

public List<T> Query<T>(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

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

Type Parameters

Name	Description
T

Query<T>(Type, DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public List<T> Query<T>(Type resultType, DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Type	resultType
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

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

Type Parameters

Name	Description
T

Query<T1, T2>(CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>> Query<T1, T2>(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>

Type Parameters

Name	Description
T1
T2

Query<T1, T2>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>> Query<T1, T2>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>

Type Parameters

Name	Description
T1
T2

Query<T1, T2>(DbConnection, DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>> Query<T1, T2>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>

Type Parameters

Name	Description
T1
T2

Query<T1, T2>(DbTransaction, CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>> Query<T1, T2>(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>

Type Parameters

Name	Description
T1
T2

Query<T1, T2>(DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>> Query<T1, T2>(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>

Type Parameters

Name	Description
T1
T2

Query<T1, T2>(String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>> Query<T1, T2>(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>

Type Parameters

Name	Description
T1
T2

Query<T1, T2, T3>(CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>> Query<T1, T2, T3>(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>

Type Parameters

Name	Description
T1
T2
T3

Query<T1, T2, T3>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>> Query<T1, T2, T3>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>

Type Parameters

Name	Description
T1
T2
T3

Query<T1, T2, T3>(DbConnection, DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>> Query<T1, T2, T3>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>

Type Parameters

Name	Description
T1
T2
T3

Query<T1, T2, T3>(DbTransaction, CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>> Query<T1, T2, T3>(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>

Type Parameters

Name	Description
T1
T2
T3

Query<T1, T2, T3>(DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>> Query<T1, T2, T3>(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>

Type Parameters

Name	Description
T1
T2
T3

Query<T1, T2, T3>(String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>> Query<T1, T2, T3>(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>

Type Parameters

Name	Description
T1
T2
T3

Query<T1, T2, T3, T4>(CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>> Query<T1, T2, T3, T4>(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>

Type Parameters

Name	Description
T1
T2
T3
T4

Query<T1, T2, T3, T4>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>> Query<T1, T2, T3, T4>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>

Type Parameters

Name	Description
T1
T2
T3
T4

Query<T1, T2, T3, T4>(DbConnection, DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>> Query<T1, T2, T3, T4>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>

Type Parameters

Name	Description
T1
T2
T3
T4

Query<T1, T2, T3, T4>(DbTransaction, CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>> Query<T1, T2, T3, T4>(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>

Type Parameters

Name	Description
T1
T2
T3
T4

Query<T1, T2, T3, T4>(DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>> Query<T1, T2, T3, T4>(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>

Type Parameters

Name	Description
T1
T2
T3
T4

Query<T1, T2, T3, T4>(String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>> Query<T1, T2, T3, T4>(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>

Type Parameters

Name	Description
T1
T2
T3
T4

Query<T1, T2, T3, T4, T5>(CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>> Query<T1, T2, T3, T4, T5>(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

Query<T1, T2, T3, T4, T5>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>> Query<T1, T2, T3, T4, T5>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

Query<T1, T2, T3, T4, T5>(DbConnection, DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>> Query<T1, T2, T3, T4, T5>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

Query<T1, T2, T3, T4, T5>(DbTransaction, CommandType, String, DbParameter[])

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>> Query<T1, T2, T3, T4, T5>(DbTransaction transaction, CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

Query<T1, T2, T3, T4, T5>(DbTransaction, String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>> Query<T1, T2, T3, T4, T5>(DbTransaction transaction, string cmdText, object parms = null)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

Query<T1, T2, T3, T4, T5>(String, Object)

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>> Query<T1, T2, T3, T4, T5>(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

QueryAsync<T>(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<List<T>> QueryAsync<T>(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T>>

Type Parameters

Name	Description
T

QueryAsync<T>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public Task<List<T>> QueryAsync<T>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T>>

Type Parameters

Name	Description
T

QueryAsync<T>(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<List<T>> QueryAsync<T>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T>>

Type Parameters

Name	Description
T

QueryAsync<T>(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<List<T>> QueryAsync<T>(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T>>

Type Parameters

Name	Description
T

QueryAsync<T>(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<List<T>> QueryAsync<T>(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T>>

Type Parameters

Name	Description
T

QueryAsync<T>(String, Object, CancellationToken)

Declaration

public Task<List<T>> QueryAsync<T>(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T>>

Type Parameters

Name	Description
T

QueryAsync<T>(Type, DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<List<T>> QueryAsync<T>(Type resultType, DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Type	resultType
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T>>

Type Parameters

Name	Description
T

QueryAsync<T1, T2>(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>>> QueryAsync<T1, T2>(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>>

Type Parameters

Name	Description
T1
T2

QueryAsync<T1, T2>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<NativeTuple<List<T1>, List<T2>>> QueryAsync<T1, T2>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>>

Type Parameters

Name	Description
T1
T2

QueryAsync<T1, T2>(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>>> QueryAsync<T1, T2>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>>

Type Parameters

Name	Description
T1
T2

QueryAsync<T1, T2>(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>>> QueryAsync<T1, T2>(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>>

Type Parameters

Name	Description
T1
T2

QueryAsync<T1, T2>(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>>> QueryAsync<T1, T2>(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>>

Type Parameters

Name	Description
T1
T2

QueryAsync<T1, T2>(String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>>> QueryAsync<T1, T2>(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>>>

Type Parameters

Name	Description
T1
T2

QueryAsync<T1, T2, T3>(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>>> QueryAsync<T1, T2, T3>(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>>

Type Parameters

Name	Description
T1
T2
T3

QueryAsync<T1, T2, T3>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<NativeTuple<List<T1>, List<T2>, List<T3>>> QueryAsync<T1, T2, T3>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>>

Type Parameters

Name	Description
T1
T2
T3

QueryAsync<T1, T2, T3>(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>>> QueryAsync<T1, T2, T3>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>>

Type Parameters

Name	Description
T1
T2
T3

QueryAsync<T1, T2, T3>(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>>> QueryAsync<T1, T2, T3>(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>>

Type Parameters

Name	Description
T1
T2
T3

QueryAsync<T1, T2, T3>(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>>> QueryAsync<T1, T2, T3>(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>>

Type Parameters

Name	Description
T1
T2
T3

QueryAsync<T1, T2, T3>(String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>>> QueryAsync<T1, T2, T3>(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>>>

Type Parameters

Name	Description
T1
T2
T3

QueryAsync<T1, T2, T3, T4>(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>>> QueryAsync<T1, T2, T3, T4>(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>>

Type Parameters

Name	Description
T1
T2
T3
T4

QueryAsync<T1, T2, T3, T4>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>>> QueryAsync<T1, T2, T3, T4>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>>

Type Parameters

Name	Description
T1
T2
T3
T4

QueryAsync<T1, T2, T3, T4>(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>>> QueryAsync<T1, T2, T3, T4>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>>

Type Parameters

Name	Description
T1
T2
T3
T4

QueryAsync<T1, T2, T3, T4>(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>>> QueryAsync<T1, T2, T3, T4>(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>>

Type Parameters

Name	Description
T1
T2
T3
T4

QueryAsync<T1, T2, T3, T4>(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>>> QueryAsync<T1, T2, T3, T4>(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>>

Type Parameters

Name	Description
T1
T2
T3
T4

QueryAsync<T1, T2, T3, T4>(String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>>> QueryAsync<T1, T2, T3, T4>(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>>>

Type Parameters

Name	Description
T1
T2
T3
T4

QueryAsync<T1, T2, T3, T4, T5>(CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>>> QueryAsync<T1, T2, T3, T4, T5>(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

QueryAsync<T1, T2, T3, T4, T5>(DbConnection, DbTransaction, CommandType, String, Int32, DbParameter[], CancellationToken)

Declaration

public async Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>>> QueryAsync<T1, T2, T3, T4, T5>(DbConnection connection, DbTransaction transaction, CommandType cmdType, string cmdText, int cmdTimeout, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Int32	cmdTimeout
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

QueryAsync<T1, T2, T3, T4, T5>(DbConnection, DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>>> QueryAsync<T1, T2, T3, T4, T5>(DbConnection connection, DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

QueryAsync<T1, T2, T3, T4, T5>(DbTransaction, CommandType, String, DbParameter[], CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>>> QueryAsync<T1, T2, T3, T4, T5>(DbTransaction transaction, CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

QueryAsync<T1, T2, T3, T4, T5>(DbTransaction, String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>>> QueryAsync<T1, T2, T3, T4, T5>(DbTransaction transaction, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

QueryAsync<T1, T2, T3, T4, T5>(String, Object, CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>>> QueryAsync<T1, T2, T3, T4, T5>(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<NativeTuple<System.Collections.Generic.List<T1>, System.Collections.Generic.List<T2>, System.Collections.Generic.List<T3>, System.Collections.Generic.List<T4>, System.Collections.Generic.List<T5>>>

Type Parameters

Name	Description
T1
T2
T3
T4
T5

QuerySingle<T>(CommandType, String, DbParameter[])

Declaration

public T QuerySingle<T>(CommandType cmdType, string cmdText, params DbParameter[] cmdParms)

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms

Returns

Type	Description
T

Type Parameters

Name	Description
T

QuerySingle<T>(String, Object)

Declaration

public T QuerySingle<T>(string cmdText, object parms = null)

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms

Returns

Type	Description
T

Type Parameters

Name	Description
T

QuerySingleAsync<T>(CommandType, String, DbParameter[], CancellationToken)

Declaration

public async Task<T> QuerySingleAsync<T>(CommandType cmdType, string cmdText, DbParameter[] cmdParms, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Data.CommandType	cmdType
System.String	cmdText
System.Data.Common.DbParameter[]	cmdParms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<T>

Type Parameters

Name	Description
T

QuerySingleAsync<T>(String, Object, CancellationToken)

Declaration

public async Task<T> QuerySingleAsync<T>(string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.String	cmdText
System.Object	parms
System.Threading.CancellationToken	cancellationToken

Returns

Type	Description
System.Threading.Tasks.Task<T>

Type Parameters

Name	Description
T

ReturnConnection(IObjectPool<DbConnection>, Object<DbConnection>, Exception)

Declaration

public abstract void ReturnConnection(IObjectPool<DbConnection> pool, Object<DbConnection> conn, Exception ex)

Parameters

Type	Name	Description
IObjectPool<System.Data.Common.DbConnection>	pool
Object<System.Data.Common.DbConnection>	conn
System.Exception	ex

RollbackTransaction(Exception)

Declaration

public void RollbackTransaction(Exception ex)

Parameters

Type	Name	Description
System.Exception	ex

Transaction(Action)

Declaration

public void Transaction(Action handler)

Parameters

Type	Name	Description
System.Action	handler

Transaction(IsolationLevel, Action)

Declaration

public void Transaction(IsolationLevel isolationLevel, Action handler)

Parameters

Type	Name	Description
System.Data.IsolationLevel	isolationLevel
System.Action	handler

Implements

IAdo

System.IDisposable

Extension Methods

FreeSqlGlobalExtensions.QuerySingle<T1>(FreeSql.IAdo, System.Linq.Expressions.Expression<System.Func<T1>>)

FreeSqlGlobalExtensions.QuerySingleAsync<T1>(FreeSql.IAdo, System.Linq.Expressions.Expression<System.Func<T1>>, System.Threading.CancellationToken)