Class InsertProvider<T1>

Inheritance

System.Object

InsertProvider

InsertProvider<T1>

Implements

IInsert<T1>

Inherited Members

InsertProvider._orm

InsertProvider._commonUtils

InsertProvider._commonExpression

InsertProvider._ignore

InsertProvider._ignoreInsertValueSql

InsertProvider._auditValueChangedDict

InsertProvider._table

InsertProvider._tableRule

InsertProvider._noneParameterFlag

InsertProvider._noneParameter

InsertProvider._insertIdentity

InsertProvider._batchValuesLimit

InsertProvider._batchParameterLimit

InsertProvider._batchAutoTransaction

InsertProvider._params

InsertProvider._transaction

InsertProvider._connection

InsertProvider._commandTimeout

InsertProvider._isAutoSyncStructure

System.Object.Equals(System.Object)

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

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

System.Object.ToString()

Namespace: FreeSql.Internal.CommonProvider

Assembly: FreeSql.dll

Syntax

public abstract class InsertProvider<T1> : InsertProvider, IInsert<T1> where T1 : class

Type Parameters

Name	Description
T1

Constructors

| Improve this Doc View Source

InsertProvider(IFreeSql, CommonUtils, CommonExpression)

Declaration

public InsertProvider(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression)

Parameters

Type	Name	Description
IFreeSql	orm
CommonUtils	commonUtils
CommonExpression	commonExpression

Fields

| Improve this Doc View Source

_batchProgress

Declaration

public Action<BatchProgressStatus<T1>> _batchProgress

Field Value

Type	Description
System.Action<BatchProgressStatus<T1>>

| Improve this Doc View Source

_source

Declaration

public List<T1> _source

Field Value

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

Methods

| Improve this Doc View Source

AppendData(T1)

Declaration

public IInsert<T1> AppendData(T1 source)

Parameters

Type	Name	Description
T1	source

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

AppendData(T1[])

Declaration

public IInsert<T1> AppendData(T1[] source)

Parameters

Type	Name	Description
T1[]	source

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

AppendData(IEnumerable<T1>)

Declaration

public IInsert<T1> AppendData(IEnumerable<T1> source)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<T1>	source

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

AsTable(Func<String, String>)

Declaration

public IInsert<T1> AsTable(Func<string, string> tableRule)

Parameters

Type	Name	Description
System.Func<System.String, System.String>	tableRule

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

AsTable(String)

Declaration

public IInsert<T1> AsTable(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

AsType(Type)

Declaration

public IInsert<T1> AsType(Type entityType)

Parameters

Type	Name	Description
System.Type	entityType

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

AuditDataValue(Object, T1, IFreeSql, TableInfo, Dictionary<String, Boolean>)

Declaration

public static void AuditDataValue(object sender, T1 data, IFreeSql orm, TableInfo table, Dictionary<string, bool> changedDict)

Parameters

Type	Name	Description
System.Object	sender
T1	data
IFreeSql	orm
TableInfo	table
System.Collections.Generic.Dictionary<System.String, System.Boolean>	changedDict

| Improve this Doc View Source

AuditDataValue(Object, IEnumerable<T1>, IFreeSql, TableInfo, Dictionary<String, Boolean>)

Declaration

public static void AuditDataValue(object sender, IEnumerable<T1> data, IFreeSql orm, TableInfo table, Dictionary<string, bool> changedDict)

Parameters

Type	Name	Description
System.Object	sender
System.Collections.Generic.IEnumerable<T1>	data
IFreeSql	orm
TableInfo	table
System.Collections.Generic.Dictionary<System.String, System.Boolean>	changedDict

| Improve this Doc View Source

BatchOptions(Int32, Int32, Boolean)

Declaration

public virtual IInsert<T1> BatchOptions(int valuesLimit, int parameterLimit, bool autoTransaction = true)

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit
System.Boolean	autoTransaction

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

BatchProgress(Action<BatchProgressStatus<T1>>)

Declaration

public IInsert<T1> BatchProgress(Action<BatchProgressStatus<T1>> callback)

Parameters

Type	Name	Description
System.Action<BatchProgressStatus<T1>>	callback

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

ClearData()

Declaration

protected void ClearData()

| Improve this Doc View Source

CommandTimeout(Int32)

Declaration

public IInsert<T1> CommandTimeout(int timeout)

Parameters

Type	Name	Description
System.Int32	timeout

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

ExecuteAffrows()

Declaration

public abstract int ExecuteAffrows()

Returns

Type	Description
System.Int32

| Improve this Doc View Source

ExecuteAffrowsAsync(CancellationToken)

Declaration

public abstract Task<int> ExecuteAffrowsAsync(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

ExecuteIdentity()

Declaration

public abstract long ExecuteIdentity()

Returns

Type	Description
System.Int64

| Improve this Doc View Source

ExecuteIdentityAsync(CancellationToken)

Declaration

public abstract Task<long> ExecuteIdentityAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

ExecuteInserted()

Declaration

public abstract List<T1> ExecuteInserted()

Returns

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

| Improve this Doc View Source

ExecuteInsertedAsync(CancellationToken)

Declaration

public abstract Task<List<T1>> ExecuteInsertedAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

IgnoreCanInsert()

AsType, Ctor, ClearData 三处地方需要重新加载

Declaration

protected void IgnoreCanInsert()

| Improve this Doc View Source

IgnoreColumns(Expression<Func<T1, Object>>)

Declaration

public IInsert<T1> IgnoreColumns(Expression<Func<T1, object>> columns)

Parameters

Type	Name	Description
System.Linq.Expressions.Expression<System.Func<T1, System.Object>>	columns

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

IgnoreColumns(String[])

Declaration

public IInsert<T1> IgnoreColumns(string[] columns)

Parameters

Type	Name	Description
System.String[]	columns

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

IgnoreInsertValueSql(Expression<Func<T1, Object>>)

Declaration

public IInsert<T1> IgnoreInsertValueSql(Expression<Func<T1, object>> columns)

Parameters

Type	Name	Description
System.Linq.Expressions.Expression<System.Func<T1, System.Object>>	columns

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

IgnoreInsertValueSql(String[])

Declaration

public IInsert<T1> IgnoreInsertValueSql(string[] columns)

Parameters

Type	Name	Description
System.String[]	columns

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

InsertColumns(Expression<Func<T1, Object>>)

Declaration

public IInsert<T1> InsertColumns(Expression<Func<T1, object>> columns)

Parameters

Type	Name	Description
System.Linq.Expressions.Expression<System.Func<T1, System.Object>>	columns

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

InsertColumns(String[])

Declaration

public IInsert<T1> InsertColumns(string[] columns)

Parameters

Type	Name	Description
System.String[]	columns

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

InsertIdentity()

Declaration

public IInsert<T1> InsertIdentity()

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

NoneParameter(Boolean)

Declaration

public IInsert<T1> NoneParameter(bool isNotCommandParameter = true)

Parameters

Type	Name	Description
System.Boolean	isNotCommandParameter

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

RawExecuteAffrows()

Declaration

protected virtual int RawExecuteAffrows()

Returns

Type	Description
System.Int32

| Improve this Doc View Source

RawExecuteAffrowsAsync(CancellationToken)

Declaration

protected virtual async Task<int> RawExecuteAffrowsAsync(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

RawExecuteIdentity()

Declaration

protected abstract long RawExecuteIdentity()

Returns

Type	Description
System.Int64

| Improve this Doc View Source

RawExecuteIdentityAsync(CancellationToken)

Declaration

protected abstract Task<long> RawExecuteIdentityAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

RawExecuteInserted()

Declaration

protected abstract List<T1> RawExecuteInserted()

Returns

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

| Improve this Doc View Source

RawExecuteInsertedAsync(CancellationToken)

Declaration

protected abstract Task<List<T1>> RawExecuteInsertedAsync(CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

SplitExecuteAffrows(Int32, Int32)

Declaration

protected virtual int SplitExecuteAffrows(int valuesLimit, int parameterLimit)

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit

Returns

Type	Description
System.Int32

| Improve this Doc View Source

SplitExecuteAffrowsAsync(Int32, Int32, CancellationToken)

Declaration

protected virtual async Task<int> SplitExecuteAffrowsAsync(int valuesLimit, int parameterLimit, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

SplitExecuteIdentity(Int32, Int32)

Declaration

protected long SplitExecuteIdentity(int valuesLimit, int parameterLimit)

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit

Returns

Type	Description
System.Int64

| Improve this Doc View Source

SplitExecuteIdentityAsync(Int32, Int32, CancellationToken)

Declaration

protected virtual async Task<long> SplitExecuteIdentityAsync(int valuesLimit, int parameterLimit, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

SplitExecuteInserted(Int32, Int32)

Declaration

protected List<T1> SplitExecuteInserted(int valuesLimit, int parameterLimit)

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit

Returns

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

| Improve this Doc View Source

SplitExecuteInsertedAsync(Int32, Int32, CancellationToken)

Declaration

protected virtual async Task<List<T1>> SplitExecuteInsertedAsync(int valuesLimit, int parameterLimit, CancellationToken cancellationToken = default(CancellationToken))

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit
System.Threading.CancellationToken	cancellationToken

Returns

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

| Improve this Doc View Source

SplitSource(Int32, Int32, Boolean)

Declaration

protected List<T1>[] SplitSource(int valuesLimit, int parameterLimit, bool isAsTableSplited = false)

Parameters

Type	Name	Description
System.Int32	valuesLimit
System.Int32	parameterLimit
System.Boolean	isAsTableSplited

Returns

Type	Description
System.Collections.Generic.List<T1>[]

| Improve this Doc View Source

TableRuleInvoke()

Declaration

protected string TableRuleInvoke()

Returns

Type	Description
System.String

| Improve this Doc View Source

ToDataTable()

Declaration

public DataTable ToDataTable()

Returns

Type	Description
System.Data.DataTable

| Improve this Doc View Source

ToSql()

Declaration

public virtual string ToSql()

Returns

Type	Description
System.String

| Improve this Doc View Source

ToSqlValuesOrSelectUnionAll(Boolean)

Declaration

public string ToSqlValuesOrSelectUnionAll(bool isValues = true)

Parameters

Type	Name	Description
System.Boolean	isValues

Returns

Type	Description
System.String

| Improve this Doc View Source

ToSqlValuesOrSelectUnionAllExtension101(Boolean, Action<Object, Int32, StringBuilder>)

Declaration

public string ToSqlValuesOrSelectUnionAllExtension101(bool isValues, Action<object, int, StringBuilder> onrow)

Parameters

Type	Name	Description
System.Boolean	isValues
System.Action<System.Object, System.Int32, System.Text.StringBuilder>	onrow

Returns

Type	Description
System.String

| Improve this Doc View Source

ToSqlValuesOrSelectUnionAllExtension102(Boolean, Action<Object, Int32, StringBuilder>, Action<Object, Int32, StringBuilder>)

Declaration

public string ToSqlValuesOrSelectUnionAllExtension102(bool isValues, Action<object, int, StringBuilder> onrowPre, Action<object, int, StringBuilder> onrow)

Parameters

Type	Name	Description
System.Boolean	isValues
System.Action<System.Object, System.Int32, System.Text.StringBuilder>	onrowPre
System.Action<System.Object, System.Int32, System.Text.StringBuilder>	onrow

Returns

Type	Description
System.String

| Improve this Doc View Source

WithConnection(DbConnection)

Declaration

public IInsert<T1> WithConnection(DbConnection connection)

Parameters

Type	Name	Description
System.Data.Common.DbConnection	connection

Returns

Type	Description
IInsert<T1>

| Improve this Doc View Source

WithTransaction(DbTransaction)

Declaration

public IInsert<T1> WithTransaction(DbTransaction transaction)

Parameters

Type	Name	Description
System.Data.Common.DbTransaction	transaction

Returns

Type	Description
IInsert<T1>

Implements

IInsert<T1>