Class Select0Provider<TSelect, T1>

Inheritance
System.Object
Select0Provider
Select0Provider<TSelect, T1>
Select10Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
Select11Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
Select12Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
Select13Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
Select14Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
Select15Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
Select16Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
Select1Provider<T1>
Select2Provider<T1, T2>
Select3Provider<T1, T2, T3>
Select4Provider<T1, T2, T3, T4>
Select5Provider<T1, T2, T3, T4, T5>
Select6Provider<T1, T2, T3, T4, T5, T6>
Select7Provider<T1, T2, T3, T4, T5, T6, T7>
Select8Provider<T1, T2, T3, T4, T5, T6, T7, T8>
Select9Provider<T1, T2, T3, T4, T5, T6, T7, T8, T9>
Implements
ISelect0<TSelect, T1>
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: FreeSql.Internal.CommonProvider
Assembly: FreeSql.dll
Syntax
public abstract class Select0Provider<TSelect, T1> : Select0Provider, ISelect0<TSelect, T1>, ISelect0 where TSelect : class
Type Parameters
Name Description
TSelect
T1

Constructors

| Improve this Doc View Source

Select0Provider(IFreeSql, CommonUtils, CommonExpression, Object)

Declaration
public Select0Provider(IFreeSql orm, CommonUtils commonUtils, CommonExpression commonExpression, object dywhere)
Parameters
Type Name Description
IFreeSql orm
CommonUtils commonUtils
CommonExpression commonExpression
System.Object dywhere

Methods

| Improve this Doc View Source

Any()

Declaration
public bool Any()
Returns
Type Description
System.Boolean
| Improve this Doc View Source

AnyAsync(CancellationToken)

Declaration
public async Task<bool> AnyAsync(CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Boolean>
| Improve this Doc View Source

AsAlias(Func<Type, String, String>)

Declaration
public TSelect AsAlias(Func<Type, string, string> aliasRule)
Parameters
Type Name Description
System.Func<System.Type, System.String, System.String> aliasRule
Returns
Type Description
TSelect
| Improve this Doc View Source

AsTable(Func<Type, String, String>)

Declaration
public TSelect AsTable(Func<Type, string, string> tableRule)
Parameters
Type Name Description
System.Func<System.Type, System.String, System.String> tableRule
Returns
Type Description
TSelect
| Improve this Doc View Source

AsTableBase(Func<Type, String, String>)

Declaration
public override void AsTableBase(Func<Type, string, string> tableRule)
Parameters
Type Name Description
System.Func<System.Type, System.String, System.String> tableRule
Overrides
| Improve this Doc View Source

AsType(Type)

Declaration
public TSelect AsType(Type entityType)
Parameters
Type Name Description
System.Type entityType
Returns
Type Description
TSelect
| Improve this Doc View Source

Cancel(Func<Boolean>)

Declaration
public TSelect Cancel(Func<bool> cancel)
Parameters
Type Name Description
System.Func<System.Boolean> cancel
Returns
Type Description
TSelect
| Improve this Doc View Source

CommandTimeout(Int32)

Declaration
public TSelect CommandTimeout(int timeout)
Parameters
Type Name Description
System.Int32 timeout
Returns
Type Description
TSelect
| Improve this Doc View Source

Count()

Declaration
public long Count()
Returns
Type Description
System.Int64
| Improve this Doc View Source

Count(out Int64)

Declaration
public TSelect Count(out long count)
Parameters
Type Name Description
System.Int64 count
Returns
Type Description
TSelect
| Improve this Doc View Source

CountAsync(CancellationToken)

Declaration
public async Task<long> CountAsync(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

DisableGlobalFilter(String[])

Declaration
public TSelect DisableGlobalFilter(params string[] name)
Parameters
Type Name Description
System.String[] name
Returns
Type Description
TSelect
| Improve this Doc View Source

Distinct()

Declaration
public TSelect Distinct()
Returns
Type Description
TSelect
| Improve this Doc View Source

First()

Declaration
public T1 First()
Returns
Type Description
T1
| Improve this Doc View Source

FirstAsync(CancellationToken)

Declaration
public Task<T1> FirstAsync(CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<T1>
| Improve this Doc View Source

ForUpdate(Boolean)

Declaration
public TSelect ForUpdate(bool noawait = false)
Parameters
Type Name Description
System.Boolean noawait
Returns
Type Description
TSelect
| Improve this Doc View Source

GetAllFieldExpressionTreeLevel2(Boolean)

Declaration
public Select0Provider<TSelect, T1>.GetAllFieldExpressionTreeInfo GetAllFieldExpressionTreeLevel2(bool isRereadSql = true)
Parameters
Type Name Description
System.Boolean isRereadSql
Returns
Type Description
Select0Provider.GetAllFieldExpressionTreeInfo<>
| Improve this Doc View Source

GetAllFieldExpressionTreeLevelAll()

Declaration
public Select0Provider<TSelect, T1>.GetAllFieldExpressionTreeInfo GetAllFieldExpressionTreeLevelAll()
Returns
Type Description
Select0Provider.GetAllFieldExpressionTreeInfo<>
| Improve this Doc View Source

GetTableRuleUnions()

Declaration
protected List<Dictionary<Type, string>> GetTableRuleUnions()
Returns
Type Description
System.Collections.Generic.List<System.Collections.Generic.Dictionary<System.Type, System.String>>
| Improve this Doc View Source

GroupBy(String, Object)

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

Having(String, Object)

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

InnerJoin(Expression<Func<T1, Boolean>>)

Declaration
public TSelect InnerJoin(Expression<Func<T1, bool>> exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, System.Boolean>> exp
Returns
Type Description
TSelect
| Improve this Doc View Source

InnerJoin(String, Object)

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

InnerJoin<T2>(Expression<Func<T1, T2, Boolean>>)

Declaration
public TSelect InnerJoin<T2>(Expression<Func<T1, T2, bool>> exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, T2, System.Boolean>> exp
Returns
Type Description
TSelect
Type Parameters
Name Description
T2
| Improve this Doc View Source

InternalAvg(Expression)

Declaration
protected double InternalAvg(Expression exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
Returns
Type Description
System.Double
| Improve this Doc View Source

InternalAvgAsync(Expression, CancellationToken)

Declaration
protected async Task<double> InternalAvgAsync(Expression exp, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Double>
| Improve this Doc View Source

InternalGetInsertIntoToSql<TTargetEntity>(String, Expression)

Declaration
protected string InternalGetInsertIntoToSql<TTargetEntity>(string tableName, Expression select)
Parameters
Type Name Description
System.String tableName
System.Linq.Expressions.Expression select
Returns
Type Description
System.String
Type Parameters
Name Description
TTargetEntity
| Improve this Doc View Source

InternalGroupBy<TKey, TValue>(Expression)

Declaration
public ISelectGrouping<TKey, TValue> InternalGroupBy<TKey, TValue>(Expression columns)
Parameters
Type Name Description
System.Linq.Expressions.Expression columns
Returns
Type Description
ISelectGrouping<TKey, TValue>
Type Parameters
Name Description
TKey
TValue
| Improve this Doc View Source

InternalInsertInto<TTargetEntity>(String, Expression)

Declaration
public int InternalInsertInto<TTargetEntity>(string tableName, Expression select)
Parameters
Type Name Description
System.String tableName
System.Linq.Expressions.Expression select
Returns
Type Description
System.Int32
Type Parameters
Name Description
TTargetEntity
| Improve this Doc View Source

InternalInsertIntoAsync<TTargetEntity>(String, Expression, CancellationToken)

Declaration
public async Task<int> InternalInsertIntoAsync<TTargetEntity>(string tableName, Expression select, CancellationToken cancellationToken)
Parameters
Type Name Description
System.String tableName
System.Linq.Expressions.Expression select
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Int32>
Type Parameters
Name Description
TTargetEntity
| Improve this Doc View Source

InternalJoin(Expression, SelectTableInfoType)

Declaration
public TSelect InternalJoin(Expression exp, SelectTableInfoType joinType)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
SelectTableInfoType joinType
Returns
Type Description
TSelect
| Improve this Doc View Source

InternalJoin<T2>(Expression, SelectTableInfoType)

Declaration
protected TSelect InternalJoin<T2>(Expression exp, SelectTableInfoType joinType)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
SelectTableInfoType joinType
Returns
Type Description
TSelect
Type Parameters
Name Description
T2
| Improve this Doc View Source

InternalMax<TMember>(Expression)

Declaration
protected TMember InternalMax<TMember>(Expression exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
Returns
Type Description
TMember
Type Parameters
Name Description
TMember
| Improve this Doc View Source

InternalMaxAsync<TMember>(Expression, CancellationToken)

Declaration
protected async Task<TMember> InternalMaxAsync<TMember>(Expression exp, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<TMember>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

InternalMin<TMember>(Expression)

Declaration
protected TMember InternalMin<TMember>(Expression exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
Returns
Type Description
TMember
Type Parameters
Name Description
TMember
| Improve this Doc View Source

InternalMinAsync<TMember>(Expression, CancellationToken)

Declaration
protected async Task<TMember> InternalMinAsync<TMember>(Expression exp, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<TMember>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

InternalOrderBy(Expression)

Declaration
public TSelect InternalOrderBy(Expression column)
Parameters
Type Name Description
System.Linq.Expressions.Expression column
Returns
Type Description
TSelect
| Improve this Doc View Source

InternalOrderByDescending(Expression)

Declaration
public TSelect InternalOrderByDescending(Expression column)
Parameters
Type Name Description
System.Linq.Expressions.Expression column
Returns
Type Description
TSelect
| Improve this Doc View Source

InternalSum(Expression)

Declaration
protected decimal InternalSum(Expression exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
Returns
Type Description
System.Decimal
| Improve this Doc View Source

InternalSumAsync(Expression, CancellationToken)

Declaration
protected async Task<decimal> InternalSumAsync(Expression exp, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Decimal>
| Improve this Doc View Source

InternalToAggregate<TReturn>(Expression)

Declaration
protected TReturn InternalToAggregate<TReturn>(Expression select)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
Returns
Type Description
TReturn
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

InternalToAggregateAsync<TReturn>(Expression, CancellationToken)

Declaration
protected async Task<TReturn> InternalToAggregateAsync<TReturn>(Expression select, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<TReturn>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

InternalToChunk<TReturn>(Expression, Int32, Action<FetchCallbackArgs<List<TReturn>>>)

Declaration
public void InternalToChunk<TReturn>(Expression select, int size, Action<FetchCallbackArgs<List<TReturn>>> done)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
System.Int32 size
System.Action<FetchCallbackArgs<System.Collections.Generic.List<TReturn>>> done
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

InternalToDataTable(Expression)

Declaration
protected DataTable InternalToDataTable(Expression select)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
Returns
Type Description
System.Data.DataTable
| Improve this Doc View Source

InternalToDataTableAsync(Expression, CancellationToken)

Declaration
protected async Task<DataTable> InternalToDataTableAsync(Expression select, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Data.DataTable>
| Improve this Doc View Source

InternalToList<TReturn>(Expression)

Declaration
public List<TReturn> InternalToList<TReturn>(Expression select)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
Returns
Type Description
System.Collections.Generic.List<TReturn>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

InternalToListAsync<TReturn>(Expression, CancellationToken)

Declaration
protected async Task<List<TReturn>> InternalToListAsync<TReturn>(Expression select, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.List<TReturn>>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

InternalToSql<TReturn>(Expression, FieldAliasOptions)

Declaration
protected string InternalToSql<TReturn>(Expression select, FieldAliasOptions fieldAlias = FieldAliasOptions.AsIndex)
Parameters
Type Name Description
System.Linq.Expressions.Expression select
FieldAliasOptions fieldAlias
Returns
Type Description
System.String
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

InternalWhere(Expression)

Declaration
public TSelect InternalWhere(Expression exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression exp
Returns
Type Description
TSelect
| Improve this Doc View Source

InternalWithTempQuery<TDto>(Expression)

Declaration
public ISelect<TDto> InternalWithTempQuery<TDto>(Expression selector)
Parameters
Type Name Description
System.Linq.Expressions.Expression selector
Returns
Type Description
ISelect<TDto>
Type Parameters
Name Description
TDto
| Improve this Doc View Source

LeftJoin(Expression<Func<T1, Boolean>>)

Declaration
public TSelect LeftJoin(Expression<Func<T1, bool>> exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, System.Boolean>> exp
Returns
Type Description
TSelect
| Improve this Doc View Source

LeftJoin(String, Object)

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

LeftJoin<T2>(Expression<Func<T1, T2, Boolean>>)

Declaration
public TSelect LeftJoin<T2>(Expression<Func<T1, T2, bool>> exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, T2, System.Boolean>> exp
Returns
Type Description
TSelect
Type Parameters
Name Description
T2
| Improve this Doc View Source

Limit(Int32)

Declaration
public TSelect Limit(int limit)
Parameters
Type Name Description
System.Int32 limit
Returns
Type Description
TSelect
| Improve this Doc View Source

Master()

Declaration
public TSelect Master()
Returns
Type Description
TSelect
| Improve this Doc View Source

Offset(Int32)

Declaration
public TSelect Offset(int offset)
Parameters
Type Name Description
System.Int32 offset
Returns
Type Description
TSelect
| Improve this Doc View Source

OrderBy(Boolean, String, Object)

Declaration
public TSelect OrderBy(bool condition, string sql, object parms = null)
Parameters
Type Name Description
System.Boolean condition
System.String sql
System.Object parms
Returns
Type Description
TSelect
| Improve this Doc View Source

OrderBy(String, Object)

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

OrderByPropertyName(String, Boolean)

Declaration
public TSelect OrderByPropertyName(string property, bool isAscending = true)
Parameters
Type Name Description
System.String property
System.Boolean isAscending
Returns
Type Description
TSelect
| Improve this Doc View Source

OrderByPropertyNameIf(Boolean, String, Boolean)

Declaration
public TSelect OrderByPropertyNameIf(bool condition, string property, bool isAscending = true)
Parameters
Type Name Description
System.Boolean condition
System.String property
System.Boolean isAscending
Returns
Type Description
TSelect
| Improve this Doc View Source

Page(BasePagingInfo)

Declaration
public TSelect Page(BasePagingInfo pagingInfo)
Parameters
Type Name Description
BasePagingInfo pagingInfo
Returns
Type Description
TSelect
| Improve this Doc View Source

Page(Int32, Int32)

Declaration
public TSelect Page(int pageNumber, int pageSize)
Parameters
Type Name Description
System.Int32 pageNumber
System.Int32 pageSize
Returns
Type Description
TSelect
| Improve this Doc View Source

RawJoin(String)

Declaration
public TSelect RawJoin(string sql)
Parameters
Type Name Description
System.String sql
Returns
Type Description
TSelect
| Improve this Doc View Source

RightJoin(Expression<Func<T1, Boolean>>)

Declaration
public TSelect RightJoin(Expression<Func<T1, bool>> exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, System.Boolean>> exp
Returns
Type Description
TSelect
| Improve this Doc View Source

RightJoin(String, Object)

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

RightJoin<T2>(Expression<Func<T1, T2, Boolean>>)

Declaration
public TSelect RightJoin<T2>(Expression<Func<T1, T2, bool>> exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, T2, System.Boolean>> exp
Returns
Type Description
TSelect
Type Parameters
Name Description
T2
| Improve this Doc View Source

Skip(Int32)

Declaration
public TSelect Skip(int offset)
Parameters
Type Name Description
System.Int32 offset
Returns
Type Description
TSelect
| Improve this Doc View Source

Take(Int32)

Declaration
public TSelect Take(int limit)
Parameters
Type Name Description
System.Int32 limit
Returns
Type Description
TSelect
| Improve this Doc View Source

ToChunk(Int32, Action<FetchCallbackArgs<List<T1>>>, Boolean)

Declaration
public void ToChunk(int size, Action<FetchCallbackArgs<List<T1>>> done, bool includeNestedMembers = false)
Parameters
Type Name Description
System.Int32 size
System.Action<FetchCallbackArgs<System.Collections.Generic.List<T1>>> done
System.Boolean includeNestedMembers
| Improve this Doc View Source

ToDataTable(String)

Declaration
public DataTable ToDataTable(string field = null)
Parameters
Type Name Description
System.String field
Returns
Type Description
System.Data.DataTable
| Improve this Doc View Source

ToDataTableAsync(String, CancellationToken)

Declaration
public async Task<DataTable> ToDataTableAsync(string field, CancellationToken cancellationToken)
Parameters
Type Name Description
System.String field
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Data.DataTable>
| Improve this Doc View Source

ToDataTableByPropertyName(String[])

Declaration
public DataTable ToDataTableByPropertyName(string[] properties)
Parameters
Type Name Description
System.String[] properties
Returns
Type Description
System.Data.DataTable
| Improve this Doc View Source

ToDataTableByPropertyNameAsync(String[], CancellationToken)

Declaration
public Task<DataTable> ToDataTableByPropertyNameAsync(string[] properties, CancellationToken cancellationToken)
Parameters
Type Name Description
System.String[] properties
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Data.DataTable>
| Improve this Doc View Source

ToDelete()

Declaration
public IDelete<T1> ToDelete()
Returns
Type Description
IDelete<T1>
| Improve this Doc View Source

ToDictionary<TKey>(Func<T1, TKey>)

Declaration
public Dictionary<TKey, T1> ToDictionary<TKey>(Func<T1, TKey> keySelector)
Parameters
Type Name Description
System.Func<T1, TKey> keySelector
Returns
Type Description
System.Collections.Generic.Dictionary<TKey, T1>
Type Parameters
Name Description
TKey
| Improve this Doc View Source

ToDictionary<TKey, TElement>(Func<T1, TKey>, Func<T1, TElement>)

Declaration
public Dictionary<TKey, TElement> ToDictionary<TKey, TElement>(Func<T1, TKey> keySelector, Func<T1, TElement> elementSelector)
Parameters
Type Name Description
System.Func<T1, TKey> keySelector
System.Func<T1, TElement> elementSelector
Returns
Type Description
System.Collections.Generic.Dictionary<TKey, TElement>
Type Parameters
Name Description
TKey
TElement
| Improve this Doc View Source

ToDictionaryAsync<TKey>(Func<T1, TKey>, CancellationToken)

Declaration
public Task<Dictionary<TKey, T1>> ToDictionaryAsync<TKey>(Func<T1, TKey> keySelector, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Func<T1, TKey> keySelector
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.Dictionary<TKey, T1>>
Type Parameters
Name Description
TKey
| Improve this Doc View Source

ToDictionaryAsync<TKey, TElement>(Func<T1, TKey>, Func<T1, TElement>, CancellationToken)

Declaration
public async Task<Dictionary<TKey, TElement>> ToDictionaryAsync<TKey, TElement>(Func<T1, TKey> keySelector, Func<T1, TElement> elementSelector, CancellationToken cancellationToken)
Parameters
Type Name Description
System.Func<T1, TKey> keySelector
System.Func<T1, TElement> elementSelector
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.Dictionary<TKey, TElement>>
Type Parameters
Name Description
TKey
TElement
| Improve this Doc View Source

ToList()

Declaration
public List<T1> ToList()
Returns
Type Description
System.Collections.Generic.List<T1>
| Improve this Doc View Source

ToList(Boolean)

Declaration
public virtual List<T1> ToList(bool includeNestedMembers)
Parameters
Type Name Description
System.Boolean includeNestedMembers
Returns
Type Description
System.Collections.Generic.List<T1>
| Improve this Doc View Source

ToList<TTuple>(String)

Declaration
public List<TTuple> ToList<TTuple>(string field)
Parameters
Type Name Description
System.String field
Returns
Type Description
System.Collections.Generic.List<TTuple>
Type Parameters
Name Description
TTuple
| Improve this Doc View Source

ToListAsync(Boolean, CancellationToken)

Declaration
public virtual Task<List<T1>> ToListAsync(bool includeNestedMembers = false, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Boolean includeNestedMembers
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.List<T1>>
| Improve this Doc View Source

ToListAsync(CancellationToken)

Declaration
public Task<List<T1>> ToListAsync(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

ToListAsync<TTuple>(String, CancellationToken)

Declaration
public Task<List<TTuple>> ToListAsync<TTuple>(string field, CancellationToken cancellationToken)
Parameters
Type Name Description
System.String field
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.List<TTuple>>
Type Parameters
Name Description
TTuple
| Improve this Doc View Source

ToListMapReader<TReturn>(ReadAnonymousTypeAfInfo)

Declaration
protected List<TReturn> ToListMapReader<TReturn>(ReadAnonymousTypeAfInfo af)
Parameters
Type Name Description
ReadAnonymousTypeAfInfo af
Returns
Type Description
System.Collections.Generic.List<TReturn>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

ToListMapReaderAsync<TReturn>(ReadAnonymousTypeAfInfo, CancellationToken)

Declaration
protected Task<List<TReturn>> ToListMapReaderAsync<TReturn>(ReadAnonymousTypeAfInfo af, CancellationToken cancellationToken)
Parameters
Type Name Description
ReadAnonymousTypeAfInfo af
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.List<TReturn>>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

ToListQfPrivate<TTuple>(String, String)

Declaration
public List<TTuple> ToListQfPrivate<TTuple>(string sql, string field)
Parameters
Type Name Description
System.String sql
System.String field
Returns
Type Description
System.Collections.Generic.List<TTuple>
Type Parameters
Name Description
TTuple
| Improve this Doc View Source

ToListQfPrivateAsync<TTuple>(String, String, CancellationToken)

Declaration
public async Task<List<TTuple>> ToListQfPrivateAsync<TTuple>(string sql, string field, CancellationToken cancellationToken)
Parameters
Type Name Description
System.String sql
System.String field
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.List<TTuple>>
Type Parameters
Name Description
TTuple
| Improve this Doc View Source

ToOne()

Declaration
public T1 ToOne()
Returns
Type Description
T1
| Improve this Doc View Source

ToOneAsync(CancellationToken)

Declaration
public async Task<T1> ToOneAsync(CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<T1>
| Improve this Doc View Source

ToSql(String)

Declaration
public abstract string ToSql(string field = null)
Parameters
Type Name Description
System.String field
Returns
Type Description
System.String
| Improve this Doc View Source

ToSqlBase(String)

Declaration
public override string ToSqlBase(string field = null)
Parameters
Type Name Description
System.String field
Returns
Type Description
System.String
Overrides
| Improve this Doc View Source

ToUpdate()

Declaration
public IUpdate<T1> ToUpdate()
Returns
Type Description
IUpdate<T1>
| Improve this Doc View Source

TrackToList(Action<Object>)

Declaration
public TSelect TrackToList(Action<object> track)
Parameters
Type Name Description
System.Action<System.Object> track
Returns
Type Description
TSelect
| Improve this Doc View Source

Where(String, Object)

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

WhereDynamicFilter(DynamicFilterInfo)

Declaration
public TSelect WhereDynamicFilter(DynamicFilterInfo filter)
Parameters
Type Name Description
DynamicFilterInfo filter
Returns
Type Description
TSelect
| Improve this Doc View Source

WhereIf(Boolean, String, Object)

Declaration
public TSelect WhereIf(bool condition, string sql, object parms = null)
Parameters
Type Name Description
System.Boolean condition
System.String sql
System.Object parms
Returns
Type Description
TSelect
| Improve this Doc View Source

WithConnection(DbConnection)

Declaration
public TSelect WithConnection(DbConnection connection)
Parameters
Type Name Description
System.Data.Common.DbConnection connection
Returns
Type Description
TSelect
| Improve this Doc View Source

WithParameters(List<DbParameter>)

Declaration
public TSelect WithParameters(List<DbParameter> parameters)
Parameters
Type Name Description
System.Collections.Generic.List<System.Data.Common.DbParameter> parameters
Returns
Type Description
TSelect
| Improve this Doc View Source

WithTransaction(DbTransaction)

Declaration
public TSelect WithTransaction(DbTransaction transaction)
Parameters
Type Name Description
System.Data.Common.DbTransaction transaction
Returns
Type Description
TSelect

Implements

Extension Methods

FreeSqlGlobalExtensions.OrderByRandom<TSelect, T1>(FreeSql.ISelect0<TSelect, T1>)