Interface IAdo

Namespace: FreeSql
Assembly: FreeSql.dll
Syntax
public interface IAdo

Properties

| Improve this Doc View Source

ConnectionString

UseConnectionString 时候的值

Declaration
string ConnectionString { get; }
Property Value
Type Description
System.String
| Improve this Doc View Source

DataType

数据库类型

Declaration
DataType DataType { get; }
Property Value
Type Description
DataType
| Improve this Doc View Source

Identifier

唯一标识

Declaration
Guid Identifier { get; }
Property Value
Type Description
System.Guid
| Improve this Doc View Source

MasterPool

主库连接池

Declaration
IObjectPool<DbConnection> MasterPool { get; }
Property Value
Type Description
IObjectPool<System.Data.Common.DbConnection>
| Improve this Doc View Source

SlaveConnectionStrings

UseSalve 时候的值

Declaration
string[] SlaveConnectionStrings { get; }
Property Value
Type Description
System.String[]
| Improve this Doc View Source

SlavePools

从库连接池

Declaration
List<IObjectPool<DbConnection>> SlavePools { get; }
Property Value
Type Description
System.Collections.Generic.List<IObjectPool<System.Data.Common.DbConnection>>
| Improve this Doc View Source

TransactionCurrentThread

当前线程的事务

Declaration
DbTransaction TransactionCurrentThread { get; }
Property Value
Type Description
System.Data.Common.DbTransaction

Methods

| Improve this Doc View Source

CommandFluent(String, Object)

SQL 命令执行类，fsql.Ado.CommandFluent("select * from user where age > @age&quot;, new { age = 25 })

.WithConnection(connection)

.WithTransaction(transaction)

.WithParameter("age", 25)

.WithParameter("id", 11)

.CommandType(CommandType.Text)

.CommandTimeout(60)

.Query<T>(); 或者 ExecuteNonQuery/ExecuteScalar/ExecuteDataTable/ExecuteDataSet/ExecuteArray

Declaration
AdoCommandFluent CommandFluent(string cmdText, object parms = null)
Parameters
Type Name Description
System.String cmdText
System.Object parms
Returns
Type Description
AdoCommandFluent
| Improve this Doc View Source

ExecuteArray(CommandType, String, DbParameter[])

查询

Declaration
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[][]
| Improve this Doc View Source

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

Declaration
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[][]
| Improve this Doc View Source

ExecuteArray(DbConnection, DbTransaction, String, Object)

Declaration
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[][]
| Improve this Doc View Source

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

Declaration
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[][]
| Improve this Doc View Source

ExecuteArray(DbTransaction, String, Object)

Declaration
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[][]
| Improve this Doc View Source

ExecuteArray(String, Object)

查询，ExecuteArray("select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
object[][] ExecuteArray(string cmdText, object parms = null)
Parameters
Type Name Description
System.String cmdText
System.Object parms
Returns
Type Description
System.Object[][]
| Improve this Doc View Source

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

查询

Declaration
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[][]>
| Improve this Doc View Source

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

Declaration
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[][]>
| Improve this Doc View Source

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

Declaration
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[][]>
| Improve this Doc View Source

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

Declaration
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[][]>
| Improve this Doc View Source

ExecuteArrayAsync(DbTransaction, String, Object, CancellationToken)

Declaration
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[][]>
| Improve this Doc View Source

ExecuteArrayAsync(String, Object, CancellationToken)

查询，ExecuteArrayAsync("select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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[][]>
| Improve this Doc View Source

ExecuteConnectTest(Int32)

测试数据库是否连接正确，本方法执行如下命令：

MySql/SqlServer/PostgreSQL/达梦/人大金仓/神通: SELECT 1

Oracle: SELECT 1 FROM dual

Declaration
bool ExecuteConnectTest(int commandTimeout = 0)
Parameters
Type Name Description
System.Int32 commandTimeout

命令超时设置(秒)
Returns
Type Description
System.Boolean

true: 成功, false: 失败
| Improve this Doc View Source

ExecuteConnectTestAsync(Int32, CancellationToken)

测试数据库是否连接正确，本方法执行如下命令：

MySql/SqlServer/PostgreSQL/达梦/人大金仓/神通: SELECT 1

Oracle: SELECT 1 FROM dual

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

true: 成功, false: 失败
| Improve this Doc View Source

ExecuteDataSet(CommandType, String, DbParameter[])

查询

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteDataSet(DbConnection, DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteDataSet(DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

ExecuteDataSet(String, Object)

查询，ExecuteDataSet("select * from user where age > @age; select 2", new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
DataSet ExecuteDataSet(string cmdText, object parms = null)
Parameters
Type Name Description
System.String cmdText
System.Object parms
Returns
Type Description
System.Data.DataSet
| Improve this Doc View Source

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

查询

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

ExecuteDataSetAsync(DbTransaction, String, Object, CancellationToken)

Declaration
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>
| Improve this Doc View Source

ExecuteDataSetAsync(String, Object, CancellationToken)

查询，ExecuteDataSetAsync("select * from user where age > @age; select 2", new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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>
| Improve this Doc View Source

ExecuteDataTable(CommandType, String, DbParameter[])

查询

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteDataTable(DbConnection, DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteDataTable(DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

ExecuteDataTable(String, Object)

查询，ExecuteDataTable("select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
DataTable ExecuteDataTable(string cmdText, object parms = null)
Parameters
Type Name Description
System.String cmdText
System.Object parms
Returns
Type Description
System.Data.DataTable
| Improve this Doc View Source

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

查询

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

ExecuteDataTableAsync(DbTransaction, String, Object, CancellationToken)

Declaration
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>
| Improve this Doc View Source

ExecuteDataTableAsync(String, Object, CancellationToken)

查询，ExecuteDataTableAsync("select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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>
| Improve this Doc View Source

ExecuteNonQuery(CommandType, String, DbParameter[])

在【主库】执行

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteNonQuery(DbConnection, DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteNonQuery(DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

ExecuteNonQuery(String, Object)

在【主库】执行，ExecuteNonQuery("delete from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
int ExecuteNonQuery(string cmdText, object parms = null)
Parameters
Type Name Description
System.String cmdText
System.Object parms
Returns
Type Description
System.Int32
| Improve this Doc View Source

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

在【主库】执行

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

ExecuteNonQueryAsync(DbTransaction, String, Object, CancellationToken)

Declaration
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>
| Improve this Doc View Source

ExecuteNonQueryAsync(String, Object, CancellationToken)

在【主库】执行，ExecuteNonQueryAsync("delete from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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>
| Improve this Doc View Source

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

查询，若使用读写分离，查询【从库】条件cmdText.StartsWith("SELECT ")，否则查询【主库】

Declaration
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
| Improve this Doc View Source

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

查询，ExecuteReader(dr => {}, "select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
Task ExecuteReaderAsync(DbConnection connection, DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> readerHander, 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> readerHander
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
| Improve this Doc View Source

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

Declaration
Task ExecuteReaderAsync(DbConnection connection, DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> readerHander, 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> readerHander
System.String cmdText
System.Object parms
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task
| Improve this Doc View Source

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

Declaration
Task ExecuteReaderAsync(DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> readerHander, 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> readerHander
System.Data.CommandType cmdType
System.String cmdText
System.Data.Common.DbParameter[] cmdParms
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task
| Improve this Doc View Source

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

Declaration
Task ExecuteReaderAsync(DbTransaction transaction, Func<FetchCallbackArgs<DbDataReader>, Task> readerHander, 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> readerHander
System.String cmdText
System.Object parms
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task
| Improve this Doc View Source

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

查询，若使用读写分离，查询【从库】条件cmdText.StartsWith("SELECT ")，否则查询【主库】

Declaration
Task ExecuteReaderAsync(Func<FetchCallbackArgs<DbDataReader>, Task> readerHander, 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> readerHander
System.Data.CommandType cmdType
System.String cmdText
System.Data.Common.DbParameter[] cmdParms
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task
| Improve this Doc View Source

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

查询，ExecuteReaderAsync(dr => {}, "select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
Task ExecuteReaderAsync(Func<FetchCallbackArgs<DbDataReader>, Task> readerHander, string cmdText, object parms = null, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Func<FetchCallbackArgs<System.Data.Common.DbDataReader>, System.Threading.Tasks.Task> readerHander
System.String cmdText
System.Object parms
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task
| Improve this Doc View Source

ExecuteScalar(CommandType, String, DbParameter[])

在【主库】执行

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteScalar(DbConnection, DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

ExecuteScalar(DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

ExecuteScalar(String, Object)

在【主库】执行，ExecuteScalar("select 1 from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
object ExecuteScalar(string cmdText, object parms = null)
Parameters
Type Name Description
System.String cmdText
System.Object parms
Returns
Type Description
System.Object
| Improve this Doc View Source

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

在【主库】执行

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

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

Declaration
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>
| Improve this Doc View Source

ExecuteScalarAsync(DbTransaction, String, Object, CancellationToken)

Declaration
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>
| Improve this Doc View Source

ExecuteScalarAsync(String, Object, CancellationToken)

在【主库】执行，ExecuteScalarAsync("select 1 from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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>
| Improve this Doc View Source

GetDbParamtersByObject(Object)

将 new { id = 1 } 或者 Dictionary<string, object> 转换为 DbParameter[]

Declaration
DbParameter[] GetDbParamtersByObject(object obj)
Parameters
Type Name Description
System.Object obj

new { id = 1 } 或者 Dictionary<string, object>
Returns
Type Description
System.Data.Common.DbParameter[]
| Improve this Doc View Source

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

执行SQL返回对象集合，Query<User>("select * from user where age > @age&quot;, new SqlParameter { ParameterName = "age", Value = 25 })

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

Query<T>(DbTransaction, String, Object)

Declaration
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
| Improve this Doc View Source

Query<T>(String, Object)

执行SQL返回对象集合，Query<User>("select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

执行SQL返回对象集合，Query<User>("select * from user where age > @age; select * from address", new SqlParameter { ParameterName = "age", Value = 25 })

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

Query<T1, T2>(String, Object)

执行SQL返回对象集合，Query<User>("select * from user where age > @age; select * from address", new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

执行SQL返回对象集合，QueryAsync<User>("select * from user where age > @age&quot;, new SqlParameter { ParameterName = "age", Value = 25 })

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

QueryAsync<T>(String, Object, CancellationToken)

执行SQL返回对象集合，QueryAsync<User>("select * from user where age > @age&quot;, new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

执行SQL返回对象集合，Query<User>("select * from user where age > @age; select * from address", new SqlParameter { ParameterName = "age", Value = 25 })

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

执行SQL返回对象集合，Query<User, Address>("select * from user where age > @age; select * from address", new { age = 25 })

提示：parms 参数还可以传 Dictionary<string, object>

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

QuerySingle<T>(String, Object)

Declaration
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
| Improve this Doc View Source

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

Declaration
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
| Improve this Doc View Source

QuerySingleAsync<T>(String, Object, CancellationToken)

Declaration
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
| Improve this Doc View Source

Transaction(Action)

开启事务（不支持异步）

Declaration
void Transaction(Action handler)
Parameters
Type Name Description
System.Action handler

事务体 () => {}
| Improve this Doc View Source

Transaction(IsolationLevel, Action)

开启事务（不支持异步）

Declaration
void Transaction(IsolationLevel isolationLevel, Action handler)
Parameters
Type Name Description
System.Data.IsolationLevel isolationLevel
System.Action handler

事务体 () => {}

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)