Class SelectGroupingProvider<TKey, TValue>

Inheritance
System.Object
BaseDiyMemberExpression
SelectGroupingProvider
SelectGroupingProvider<TKey, TValue>
Implements
ISelectGrouping<TKey, TValue>
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 class SelectGroupingProvider<TKey, TValue> : SelectGroupingProvider, ISelectGrouping<TKey, TValue>
Type Parameters
Name Description
TKey
TValue

Constructors

| Improve this Doc View Source

SelectGroupingProvider(IFreeSql, Select0Provider, ReadAnonymousTypeInfo, String, CommonExpression, List<SelectTableInfo>)

Declaration
public SelectGroupingProvider(IFreeSql orm, Select0Provider select, ReadAnonymousTypeInfo map, string field, CommonExpression comonExp, List<SelectTableInfo> tables)
Parameters
Type Name Description
IFreeSql orm
Select0Provider select
ReadAnonymousTypeInfo map
System.String field
CommonExpression comonExp
System.Collections.Generic.List<SelectTableInfo> tables

Methods

| 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 ISelectGrouping<TKey, TValue> Count(out long count)
Parameters
Type Name Description
System.Int64 count
Returns
Type Description
ISelectGrouping<TKey, TValue>
| 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

First<TReturn>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TReturn>>)

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

FirstAsync<TReturn>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TReturn>>, CancellationToken)

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

Having(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, Boolean>>)

Declaration
public ISelectGrouping<TKey, TValue> Having(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, bool>> exp)
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectGroupingAggregate<TKey, TValue>, System.Boolean>> exp
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

HavingIf(Boolean, Expression<Func<ISelectGroupingAggregate<TKey, TValue>, Boolean>>)

Declaration
public ISelectGrouping<TKey, TValue> HavingIf(bool condition, Expression<Func<ISelectGroupingAggregate<TKey, TValue>, bool>> exp)
Parameters
Type Name Description
System.Boolean condition
System.Linq.Expressions.Expression<System.Func<ISelectGroupingAggregate<TKey, TValue>, System.Boolean>> exp
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

Limit(Int32)

Declaration
public ISelectGrouping<TKey, TValue> Limit(int limit)
Parameters
Type Name Description
System.Int32 limit
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

Offset(Int32)

Declaration
public ISelectGrouping<TKey, TValue> Offset(int offset)
Parameters
Type Name Description
System.Int32 offset
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

OrderBy<TMember>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TMember>>)

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

OrderByDescending<TMember>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TMember>>)

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

Page(BasePagingInfo)

Declaration
public ISelectGrouping<TKey, TValue> Page(BasePagingInfo pagingInfo)
Parameters
Type Name Description
BasePagingInfo pagingInfo
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

Page(Int32, Int32)

Declaration
public ISelectGrouping<TKey, TValue> Page(int pageNumber, int pageSize)
Parameters
Type Name Description
System.Int32 pageNumber
System.Int32 pageSize
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

Select<TReturn>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TReturn>>)

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

Skip(Int32)

Declaration
public ISelectGrouping<TKey, TValue> Skip(int offset)
Parameters
Type Name Description
System.Int32 offset
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

Take(Int32)

Declaration
public ISelectGrouping<TKey, TValue> Take(int limit)
Parameters
Type Name Description
System.Int32 limit
Returns
Type Description
ISelectGrouping<TKey, TValue>
| Improve this Doc View Source

ToDictionary<TElement>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TElement>>)

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

ToDictionaryAsync<TElement>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TElement>>, CancellationToken)

Declaration
public async Task<Dictionary<TKey, TElement>> ToDictionaryAsync<TElement>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TElement>> elementSelector, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type Name Description
System.Linq.Expressions.Expression<System.Func<ISelectGroupingAggregate<TKey, TValue>, TElement>> elementSelector
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Collections.Generic.Dictionary<TKey, TElement>>
Type Parameters
Name Description
TElement
| Improve this Doc View Source

ToList<TReturn>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TReturn>>)

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

ToListAsync<TReturn>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TReturn>>, CancellationToken)

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

ToSql(String)

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

ToSql<TReturn>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TReturn>>, FieldAliasOptions)

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

WithTempQuery<TDto>(Expression<Func<ISelectGroupingAggregate<TKey, TValue>, TDto>>)

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

Implements