Class AdoCommandFluent

Inheritance

System.Object

AdoCommandFluent

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.Model

Assembly: FreeSql.dll

Syntax

public class AdoCommandFluent

Constructors

| Improve this Doc View Source

AdoCommandFluent(AdoProvider, String, Object)

Declaration

public AdoCommandFluent(AdoProvider ado, string commandText, object parms)

Parameters

Type	Name	Description
AdoProvider	ado
System.String	commandText
System.Object	parms

Properties

| Improve this Doc View Source

Ado

Declaration

protected AdoProvider Ado { get; set; }

Property Value

Type	Description
AdoProvider

| Improve this Doc View Source

CmdParameters

Declaration

protected List<DbParameter> CmdParameters { get; }

Property Value

Type	Description
System.Collections.Generic.List<System.Data.Common.DbParameter>

| Improve this Doc View Source

CmdText

Declaration

protected string CmdText { get; set; }

Property Value

Type	Description
System.String

| Improve this Doc View Source

CmdTimeout

Declaration

protected int CmdTimeout { get; set; }

Property Value

Type	Description
System.Int32

| Improve this Doc View Source

CmdType

Declaration

protected CommandType CmdType { get; set; }

Property Value

Type	Description
System.Data.CommandType

| Improve this Doc View Source

Connection

Declaration

protected DbConnection Connection { get; set; }

Property Value

Type	Description
System.Data.Common.DbConnection

| Improve this Doc View Source

Transaction

Declaration

protected DbTransaction Transaction { get; set; }

Property Value

Type	Description
System.Data.Common.DbTransaction

Methods

| Improve this Doc View Source

CommandTimeout(Int32)

设置命令执行超时（秒）

Declaration

public AdoCommandFluent CommandTimeout(int commandTimeout)

Parameters

Type	Name	Description
System.Int32	commandTimeout

Returns

Type	Description
AdoCommandFluent

| Improve this Doc View Source

CommandType(CommandType)

设置执行的命令类型，SQL文本、或存储过程

Declaration

public AdoCommandFluent CommandType(CommandType commandType)

Parameters

Type	Name	Description
System.Data.CommandType	commandType

Returns

Type	Description
AdoCommandFluent

| Improve this Doc View Source

ExecuteArray()

Declaration

public object[][] ExecuteArray()

Returns

Type	Description
System.Object[][]

| Improve this Doc View Source

ExecuteArrayAsync(CancellationToken)

Declaration

public Task<object[][]> ExecuteArrayAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

ExecuteDataSet()

Declaration

public DataSet ExecuteDataSet()

Returns

Type	Description
System.Data.DataSet

| Improve this Doc View Source

ExecuteDataSetAsync(CancellationToken)

Declaration

public Task<DataSet> ExecuteDataSetAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

ExecuteDataTable()

Declaration

public DataTable ExecuteDataTable()

Returns

Type	Description
System.Data.DataTable

| Improve this Doc View Source

ExecuteDataTableAsync(CancellationToken)

Declaration

public Task<DataTable> ExecuteDataTableAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

ExecuteNonQuery()

Declaration

public int ExecuteNonQuery()

Returns

Type	Description
System.Int32

| Improve this Doc View Source

ExecuteNonQueryAsync(CancellationToken)

Declaration

public Task<int> ExecuteNonQueryAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

ExecuteScalar()

Declaration

public object ExecuteScalar()

Returns

Type	Description
System.Object

| Improve this Doc View Source

ExecuteScalarAsync(CancellationToken)

Declaration

public Task<object> ExecuteScalarAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

Query<T>()

Declaration

public List<T> Query<T>()

Returns

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

Type Parameters

Name	Description
T

| Improve this Doc View Source

Query<T1, T2>()

Declaration

public NativeTuple<List<T1>, List<T2>> Query<T1, T2>()

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

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>> Query<T1, T2, T3>()

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

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>> Query<T1, T2, T3, T4>()

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

Declaration

public NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>> Query<T1, T2, T3, T4, T5>()

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>(CancellationToken)

Declaration

public Task<List<T>> QueryAsync<T>(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
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>(CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>>> QueryAsync<T1, T2>(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
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>(CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>>> QueryAsync<T1, T2, T3>(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
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>(CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>>> QueryAsync<T1, T2, T3, T4>(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
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>(CancellationToken)

Declaration

public Task<NativeTuple<List<T1>, List<T2>, List<T3>, List<T4>, List<T5>>> QueryAsync<T1, T2, T3, T4, T5>(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
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>()

Declaration

public T QuerySingle<T>()

Returns

Type	Description
T

Type Parameters

Name	Description
T

| Improve this Doc View Source

QuerySingleAsync<T>(CancellationToken)

Declaration

public async Task<T> QuerySingleAsync<T>(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

Type Parameters

Name	Description
T

| Improve this Doc View Source

WithConnection(DbConnection)

使用指定 DbConnection 连接执行

Declaration

public AdoCommandFluent WithConnection(DbConnection conn)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	conn

Returns

Type	Description
AdoCommandFluent

| Improve this Doc View Source

WithParameter(String, Object, Action<DbParameter>)

增加参数化对象

Declaration

public AdoCommandFluent WithParameter(string parameterName, object value, Action<DbParameter> modify = null)

Parameters

Type	Name	Description
System.String	parameterName	参数名
System.Object	value	参数值
System.Action<System.Data.Common.DbParameter>	modify	修改本次创建好的参数化对象，比如将 parameterName 参数修改为 Output 类型

Returns

Type	Description
AdoCommandFluent

| Improve this Doc View Source

WithTransaction(DbTransaction)

使用指定 DbTransaction 事务执行

Declaration

public AdoCommandFluent WithTransaction(DbTransaction tran)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	tran

Returns

Type	Description
AdoCommandFluent