Class Select1Provider<T1>

Inheritance
System.Object
Select0Provider
Select0Provider<ISelect<T1>, T1>
Select1Provider<T1>
Implements
ISelect0<ISelect<T1>, 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 Select1Provider<T1> : Select0Provider<ISelect<T1>, T1>, ISelect<T1>, ISelect0<ISelect<T1>, T1>, ISelect0
Type Parameters
Name Description
T1

Constructors

| Improve this Doc View Source

Select1Provider(IFreeSql, CommonUtils, CommonExpression, Object)

Declaration
public Select1Provider(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

Aggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, TReturn>>, out TReturn)

Declaration
public ISelect<T1> Aggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, TReturn>> select, out TReturn result)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectGroupingAggregate<T1>, TReturn>> select
TReturn result
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

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

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

AnyAsync(Expression<Func<T1, Boolean>>, CancellationToken)

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

As(String)

Declaration
public ISelect<T1> As(string alias)
Parameters
Type Name Description
System.String alias
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

Avg<TMember>(Expression<Func<T1, TMember>>)

Declaration
public double Avg<TMember>(Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
System.Double
Type Parameters
Name Description
TMember
| Improve this Doc View Source

AvgAsync<TMember>(Expression<Func<T1, TMember>>, CancellationToken)

Declaration
public Task<double> AvgAsync<TMember>(Expression<Func<T1, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Double>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

First<TDto>()

Declaration
public TDto First<TDto>()
Returns
Type Description
TDto
Type Parameters
Name Description
TDto
| Improve this Doc View Source

First<TReturn>(Expression<Func<T1, TReturn>>)

Declaration
public TReturn First<TReturn>(Expression<Func<T1, TReturn>> select)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TReturn>> select
Returns
Type Description
TReturn
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

FirstAsync<TReturn>(Expression<Func<T1, TReturn>>, CancellationToken)

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

FirstAsync<TDto>(CancellationToken)

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

From<T2>(Expression<Func<ISelectFromExpression<T1>, T2, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2> From<T2>(Expression<Func<ISelectFromExpression<T1>, T2, ISelectFromExpression<T1>>> exp = null)
    where T2 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2>
Type Parameters
Name Description
T2
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class where T10 : class where T11 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class where T10 : class where T11 : class where T12 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class where T10 : class where T11 : class where T12 : class where T13 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class where T10 : class where T11 : class where T12 : class where T13 : class where T14 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class where T10 : class where T11 : class where T12 : class where T13 : class where T14 : class where T15 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14
T15
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> From<T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class where T10 : class where T11 : class where T12 : class where T13 : class where T14 : class where T15 : class where T16 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14
T15
T16
| Improve this Doc View Source

From<T2, T3>(Expression<Func<ISelectFromExpression<T1>, T2, T3, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3> From<T2, T3>(Expression<Func<ISelectFromExpression<T1>, T2, T3, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3>
Type Parameters
Name Description
T2
T3
| Improve this Doc View Source

From<T2, T3, T4>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4> From<T2, T3, T4>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4>
Type Parameters
Name Description
T2
T3
T4
| Improve this Doc View Source

From<T2, T3, T4, T5>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5> From<T2, T3, T4, T5>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5>
Type Parameters
Name Description
T2
T3
T4
T5
| Improve this Doc View Source

From<T2, T3, T4, T5, T6>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6> From<T2, T3, T4, T5, T6>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6>
Type Parameters
Name Description
T2
T3
T4
T5
T6
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7> From<T2, T3, T4, T5, T6, T7>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8> From<T2, T3, T4, T5, T6, T7, T8>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9> From<T2, T3, T4, T5, T6, T7, T8, T9>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
| Improve this Doc View Source

From<T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, ISelectFromExpression<T1>>>)

Declaration
public abstract ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> From<T2, T3, T4, T5, T6, T7, T8, T9, T10>(Expression<Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, ISelectFromExpression<T1>>> exp = null)
    where T2 : class where T3 : class where T4 : class where T5 : class where T6 : class where T7 : class where T8 : class where T9 : class where T10 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectFromExpression<T1>, T2, T3, T4, T5, T6, T7, T8, T9, T10, ISelectFromExpression<T1>>> exp
Returns
Type Description
ISelect<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
Type Parameters
Name Description
T2
T3
T4
T5
T6
T7
T8
T9
T10
| Improve this Doc View Source

FromQuery<T2>(ISelect<T2>)

Declaration
public ISelect<T1, T2> FromQuery<T2>(ISelect<T2> select2)
    where T2 : class
Parameters
Type Name Description
ISelect<T2> select2
Returns
Type Description
ISelect<T1, T2>
Type Parameters
Name Description
T2
| Improve this Doc View Source

FromQuery<T2, T3>(ISelect<T2>, ISelect<T3>)

Declaration
public ISelect<T1, T2, T3> FromQuery<T2, T3>(ISelect<T2> select2, ISelect<T3> select3)
    where T2 : class where T3 : class
Parameters
Type Name Description
ISelect<T2> select2
ISelect<T3> select3
Returns
Type Description
ISelect<T1, T2, T3>
Type Parameters
Name Description
T2
T3
| Improve this Doc View Source

FromQuery<T2, T3, T4>(ISelect<T2>, ISelect<T3>, ISelect<T4>)

Declaration
public ISelect<T1, T2, T3, T4> FromQuery<T2, T3, T4>(ISelect<T2> select2, ISelect<T3> select3, ISelect<T4> select4)
    where T2 : class where T3 : class where T4 : class
Parameters
Type Name Description
ISelect<T2> select2
ISelect<T3> select3
ISelect<T4> select4
Returns
Type Description
ISelect<T1, T2, T3, T4>
Type Parameters
Name Description
T2
T3
T4
| Improve this Doc View Source

FromQuery<T2, T3, T4, T5>(ISelect<T2>, ISelect<T3>, ISelect<T4>, ISelect<T5>)

Declaration
public ISelect<T1, T2, T3, T4, T5> FromQuery<T2, T3, T4, T5>(ISelect<T2> select2, ISelect<T3> select3, ISelect<T4> select4, ISelect<T5> select5)
    where T2 : class where T3 : class where T4 : class where T5 : class
Parameters
Type Name Description
ISelect<T2> select2
ISelect<T3> select3
ISelect<T4> select4
ISelect<T5> select5
Returns
Type Description
ISelect<T1, T2, T3, T4, T5>
Type Parameters
Name Description
T2
T3
T4
T5
| Improve this Doc View Source

FromQueryMulti<TQuery>(TQuery, Type[], Select0Provider[])

Declaration
public TQuery FromQueryMulti<TQuery>(TQuery ret, Type[] entityTypes, Select0Provider[] querys)
Parameters
Type Name Description
TQuery ret
System.Type[] entityTypes
Select0Provider[] querys
Returns
Type Description
TQuery
Type Parameters
Name Description
TQuery
| Improve this Doc View Source

GroupBy<TKey>(Expression<Func<T1, TKey>>)

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

Include<TNavigate>(Expression<Func<T1, TNavigate>>)

Declaration
public ISelect<T1> Include<TNavigate>(Expression<Func<T1, TNavigate>> navigateSelector)
    where TNavigate : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TNavigate>> navigateSelector
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TNavigate
| Improve this Doc View Source

IncludeByPropertyName(String)

Declaration
public ISelect<T1> IncludeByPropertyName(string property)
Parameters
Type Name Description
System.String property
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

IncludeByPropertyName(String, Expression<Action<ISelect<Object>>>)

Declaration
public ISelect<T1> IncludeByPropertyName(string property, Expression<Action<ISelect<object>>> then)
Parameters
Type Name Description
System.String property
System.Linq.Expressions.Expression<System.Action<ISelect<System.Object>>> then
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

IncludeByPropertyNameIf(Boolean, String)

Declaration
public ISelect<T1> IncludeByPropertyNameIf(bool condition, string property)
Parameters
Type Name Description
System.Boolean condition
System.String property
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

IncludeByPropertyNameIf(Boolean, String, Expression<Action<ISelect<Object>>>)

Declaration
public ISelect<T1> IncludeByPropertyNameIf(bool condition, string property, Expression<Action<ISelect<object>>> then)
Parameters
Type Name Description
System.Boolean condition
System.String property
System.Linq.Expressions.Expression<System.Action<ISelect<System.Object>>> then
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

IncludeIf<TNavigate>(Boolean, Expression<Func<T1, TNavigate>>)

Declaration
public ISelect<T1> IncludeIf<TNavigate>(bool condition, Expression<Func<T1, TNavigate>> navigateSelector)
    where TNavigate : class
Parameters
Type Name Description
System.Boolean condition
System.Linq.Expressions.Expression<System.Func<T1, TNavigate>> navigateSelector
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TNavigate
| Improve this Doc View Source

IncludeMany<TNavigate>(Expression<Func<T1, IEnumerable<TNavigate>>>, Action<ISelect<TNavigate>>)

Declaration
public ISelect<T1> IncludeMany<TNavigate>(Expression<Func<T1, IEnumerable<TNavigate>>> navigateSelector, Action<ISelect<TNavigate>> then = null)
    where TNavigate : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, System.Collections.Generic.IEnumerable<TNavigate>>> navigateSelector
System.Action<ISelect<TNavigate>> then
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TNavigate
| Improve this Doc View Source

InsertInto<TTargetEntity>(String, Expression<Func<T1, TTargetEntity>>)

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

InsertIntoAsync<TTargetEntity>(String, Expression<Func<T1, TTargetEntity>>, CancellationToken)

Declaration
public Task<int> InsertIntoAsync<TTargetEntity>(string tableName, Expression<Func<T1, TTargetEntity>> select, CancellationToken cancellationToken = default(CancellationToken))
    where TTargetEntity : class
Parameters
Type Name Description
System.String tableName
System.Linq.Expressions.Expression<System.Func<T1, TTargetEntity>> select
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Int32>
Type Parameters
Name Description
TTargetEntity
| Improve this Doc View Source

InternalFrom(LambdaExpression)

Declaration
protected ISelect<T1> InternalFrom(LambdaExpression lambdaExp)
Parameters
Type Name Description
System.Linq.Expressions.LambdaExpression lambdaExp
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

Max<TMember>(Expression<Func<T1, TMember>>)

Declaration
public TMember Max<TMember>(Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
TMember
Type Parameters
Name Description
TMember
| Improve this Doc View Source

MaxAsync<TMember>(Expression<Func<T1, TMember>>, CancellationToken)

Declaration
public Task<TMember> MaxAsync<TMember>(Expression<Func<T1, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<TMember>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

Min<TMember>(Expression<Func<T1, TMember>>)

Declaration
public TMember Min<TMember>(Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
TMember
Type Parameters
Name Description
TMember
| Improve this Doc View Source

MinAsync<TMember>(Expression<Func<T1, TMember>>, CancellationToken)

Declaration
public Task<TMember> MinAsync<TMember>(Expression<Func<T1, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<TMember>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

OrderBy<TMember>(Boolean, Expression<Func<T1, TMember>>)

Declaration
public ISelect<T1> OrderBy<TMember>(bool condition, Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Boolean condition
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

OrderBy<TMember>(Expression<Func<T1, TMember>>)

Declaration
public ISelect<T1> OrderBy<TMember>(Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

OrderByDescending<TMember>(Boolean, Expression<Func<T1, TMember>>)

Declaration
public ISelect<T1> OrderByDescending<TMember>(bool condition, Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Boolean condition
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

OrderByDescending<TMember>(Expression<Func<T1, TMember>>)

Declaration
public ISelect<T1> OrderByDescending<TMember>(Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

OrderByIf<TMember>(Boolean, Expression<Func<T1, TMember>>, Boolean)

Declaration
public ISelect<T1> OrderByIf<TMember>(bool condition, Expression<Func<T1, TMember>> column, bool descending = false)
Parameters
Type Name Description
System.Boolean condition
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
System.Boolean descending
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

OrderByReflection(LambdaExpression, Boolean)

Declaration
public void OrderByReflection(LambdaExpression column, bool isDescending)
Parameters
Type Name Description
System.Linq.Expressions.LambdaExpression column
System.Boolean isDescending
| Improve this Doc View Source

Sum<TMember>(Expression<Func<T1, TMember>>)

Declaration
public decimal Sum<TMember>(Expression<Func<T1, TMember>> column)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
Returns
Type Description
System.Decimal
Type Parameters
Name Description
TMember
| Improve this Doc View Source

SumAsync<TMember>(Expression<Func<T1, TMember>>, CancellationToken)

Declaration
public Task<decimal> SumAsync<TMember>(Expression<Func<T1, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TMember>> column
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Decimal>
Type Parameters
Name Description
TMember
| Improve this Doc View Source

ToAggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, TReturn>>)

Declaration
public TReturn ToAggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, TReturn>> select)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectGroupingAggregate<T1>, TReturn>> select
Returns
Type Description
TReturn
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

ToAggregateAsync<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, TReturn>>, CancellationToken)

Declaration
public Task<TReturn> ToAggregateAsync<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectGroupingAggregate<T1>, TReturn>> select
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<TReturn>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

ToChunk<TReturn>(Expression<Func<T1, TReturn>>, Int32, Action<FetchCallbackArgs<List<TReturn>>>)

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

ToDataTable<TReturn>(Expression<Func<T1, TReturn>>)

Declaration
public DataTable ToDataTable<TReturn>(Expression<Func<T1, TReturn>> select)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TReturn>> select
Returns
Type Description
System.Data.DataTable
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

ToDataTableAsync<TReturn>(Expression<Func<T1, TReturn>>, CancellationToken)

Declaration
public Task<DataTable> ToDataTableAsync<TReturn>(Expression<Func<T1, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TReturn>> select
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Data.DataTable>
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

ToList(Boolean)

Declaration
public override List<T1> ToList(bool includeNestedMembers = false)
Parameters
Type Name Description
System.Boolean includeNestedMembers
Returns
Type Description
System.Collections.Generic.List<T1>
Overrides
FreeSql.Internal.CommonProvider.Select0Provider<FreeSql.ISelect<T1>, T1>.ToList(System.Boolean)
| Improve this Doc View Source

ToList<TDto>()

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

ToList<TReturn>(Expression<Func<T1, TReturn>>)

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

ToListAsync(Boolean, CancellationToken)

Declaration
public override Task<List<T1>> ToListAsync(bool includeNestedMembers, 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>>
Overrides
FreeSql.Internal.CommonProvider.Select0Provider<FreeSql.ISelect<T1>, T1>.ToListAsync(System.Boolean, System.Threading.CancellationToken)
| Improve this Doc View Source

ToListAsync<TReturn>(Expression<Func<T1, TReturn>>, CancellationToken)

Declaration
public async Task<List<TReturn>> ToListAsync<TReturn>(Expression<Func<T1, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TReturn>> 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

ToListAsync<TDto>(CancellationToken)

Declaration
public async Task<List<TDto>> ToListAsync<TDto>(CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.List<TDto>>
Type Parameters
Name Description
TDto
| Improve this Doc View Source

ToOne<TDto>()

Declaration
public TDto ToOne<TDto>()
Returns
Type Description
TDto
Type Parameters
Name Description
TDto
| Improve this Doc View Source

ToOne<TReturn>(Expression<Func<T1, TReturn>>)

Declaration
public TReturn ToOne<TReturn>(Expression<Func<T1, TReturn>> select)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TReturn>> select
Returns
Type Description
TReturn
Type Parameters
Name Description
TReturn
| Improve this Doc View Source

ToOneAsync<TReturn>(Expression<Func<T1, TReturn>>, CancellationToken)

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

ToOneAsync<TDto>(CancellationToken)

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

ToSql<TReturn>(Expression<Func<T1, TReturn>>, FieldAliasOptions)

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

UnionAll(ISelect<T1>[])

Declaration
public ISelect<T1> UnionAll(params ISelect<T1>[] querys)
Parameters
Type Name Description
ISelect<T1>[] querys
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

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

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

Where<T2>(Expression<Func<T2, Boolean>>)

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

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

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

Where<T2, T3>(Expression<Func<T1, T2, T3, Boolean>>)

Declaration
public ISelect<T1> Where<T2, T3>(Expression<Func<T1, T2, T3, bool>> exp)
    where T2 : class where T3 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, System.Boolean>> exp
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
T2
T3
| Improve this Doc View Source

Where<T2, T3, T4>(Expression<Func<T1, T2, T3, T4, Boolean>>)

Declaration
public ISelect<T1> Where<T2, T3, T4>(Expression<Func<T1, T2, T3, T4, bool>> exp)
    where T2 : class where T3 : class where T4 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> exp
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
T2
T3
T4
| Improve this Doc View Source

Where<T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, Boolean>>)

Declaration
public ISelect<T1> Where<T2, T3, T4, T5>(Expression<Func<T1, T2, T3, T4, T5, bool>> exp)
    where T2 : class where T3 : class where T4 : class where T5 : class
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, T5, System.Boolean>> exp
Returns
Type Description
ISelect<T1>
Type Parameters
Name Description
T2
T3
T4
T5
| Improve this Doc View Source

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

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

WhereDynamic(Object, Boolean)

Declaration
public ISelect<T1> WhereDynamic(object dywhere, bool not = false)
Parameters
Type Name Description
System.Object dywhere
System.Boolean not
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

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

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

WithMemory(IEnumerable<T1>)

Declaration
public ISelect<T1> WithMemory(IEnumerable<T1> source)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<T1> source
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

WithSql(String, Object)

Declaration
public ISelect<T1> WithSql(string sql, object parms = null)
Parameters
Type Name Description
System.String sql
System.Object parms
Returns
Type Description
ISelect<T1>
| Improve this Doc View Source

WithTempQuery<TDto>(Expression<Func<T1, TDto>>)

Declaration
public ISelect<TDto> WithTempQuery<TDto>(Expression<Func<T1, TDto>> selector)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<T1, TDto>> selector
Returns
Type Description
ISelect<TDto>
Type Parameters
Name Description
TDto

Implements

Extension Methods

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