Interface ISelect<T1, T2, T3, T4>
Assembly: FreeSql.dll
Syntax
public interface ISelect<T1, T2, T3, T4> : ISelect0<ISelect<T1, T2, T3, T4>, T1>, ISelect0 where T2 : class where T3 : class where T4 : class
Type Parameters
Name |
Description |
T1 |
|
T2 |
|
T3 |
|
T4 |
|
Methods
|
Improve this Doc
View Source
Aggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, ISelectGroupingAggregate<T2>, ISelectGroupingAggregate<T3>, ISelectGroupingAggregate<T4>, TReturn>>, out TReturn)
Declaration
ISelect<T1, T2, T3, T4> Aggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, ISelectGroupingAggregate<T2>, ISelectGroupingAggregate<T3>, ISelectGroupingAggregate<T4>, TReturn>> select, out TReturn result)
Parameters
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
Type Parameters
|
Improve this Doc
View Source
Any(Expression<Func<T1, T2, T3, T4, Boolean>>)
Declaration
bool Any(Expression<Func<T1, T2, T3, T4, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> |
exp |
|
Returns
Type |
Description |
System.Boolean |
|
|
Improve this Doc
View Source
Any(Expression<Func<HzyTuple<T1, T2, T3, T4>, Boolean>>)
Declaration
bool Any(Expression<Func<HzyTuple<T1, T2, T3, T4>, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, System.Boolean>> |
exp |
|
Returns
Type |
Description |
System.Boolean |
|
|
Improve this Doc
View Source
AnyAsync(Expression<Func<T1, T2, T3, T4, Boolean>>, CancellationToken)
Declaration
Task<bool> AnyAsync(Expression<Func<T1, T2, T3, T4, bool>> exp, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> |
exp |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Boolean> |
|
|
Improve this Doc
View Source
AnyAsync(Expression<Func<HzyTuple<T1, T2, T3, T4>, Boolean>>, CancellationToken)
Declaration
Task<bool> AnyAsync(Expression<Func<HzyTuple<T1, T2, T3, T4>, bool>> exp, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, System.Boolean>> |
exp |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Boolean> |
|
|
Improve this Doc
View Source
Avg<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>)
Declaration
double Avg<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
Returns
Type |
Description |
System.Double |
|
Type Parameters
|
Improve this Doc
View Source
Avg<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>)
Declaration
double Avg<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
Returns
Type |
Description |
System.Double |
|
Type Parameters
|
Improve this Doc
View Source
AvgAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>, CancellationToken)
Declaration
Task<double> AvgAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Double> |
|
Type Parameters
|
Improve this Doc
View Source
AvgAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>, CancellationToken)
Declaration
Task<double> AvgAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Double> |
|
Type Parameters
|
Improve this Doc
View Source
First<TDto>()
Declaration
Returns
Type Parameters
|
Improve this Doc
View Source
First<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>)
Declaration
TReturn First<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
Returns
Type Parameters
|
Improve this Doc
View Source
First<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>)
Declaration
TReturn First<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
Returns
Type Parameters
|
Improve this Doc
View Source
FirstAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>, CancellationToken)
Declaration
Task<TReturn> FirstAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TReturn> |
|
Type Parameters
|
Improve this Doc
View Source
FirstAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>, CancellationToken)
Declaration
Task<TReturn> FirstAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TReturn> |
|
Type Parameters
|
Improve this Doc
View Source
FirstAsync<TDto>(CancellationToken)
Declaration
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
|
Improve this Doc
View Source
GroupBy<TKey>(Expression<Func<T1, T2, T3, T4, TKey>>)
Declaration
ISelectGrouping<TKey, NativeTuple<T1, T2, T3, T4>> GroupBy<TKey>(Expression<Func<T1, T2, T3, T4, TKey>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TKey>> |
exp |
|
Returns
Type Parameters
|
Improve this Doc
View Source
GroupBy<TKey>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TKey>>)
Declaration
ISelectGrouping<TKey, NativeTuple<T1, T2, T3, T4>> GroupBy<TKey>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TKey>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TKey>> |
exp |
|
Returns
Type Parameters
|
Improve this Doc
View Source
InnerJoin(Expression<Func<T1, T2, T3, T4, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> InnerJoin(Expression<Func<T1, T2, T3, T4, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
InnerJoin(Expression<Func<HzyTuple<T1, T2, T3, T4>, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> InnerJoin(Expression<Func<HzyTuple<T1, T2, T3, T4>, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
InsertInto<TTargetEntity>(String, Expression<Func<T1, T2, T3, T4, TTargetEntity>>)
Declaration
int InsertInto<TTargetEntity>(string tableName, Expression<Func<T1, T2, T3, T4, TTargetEntity>> select)
where TTargetEntity : class
Parameters
Type |
Name |
Description |
System.String |
tableName |
|
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TTargetEntity>> |
select |
|
Returns
Type |
Description |
System.Int32 |
|
Type Parameters
Name |
Description |
TTargetEntity |
|
|
Improve this Doc
View Source
InsertInto<TTargetEntity>(String, Expression<Func<HzyTuple<T1, T2, T3, T4>, TTargetEntity>>)
Declaration
int InsertInto<TTargetEntity>(string tableName, Expression<Func<HzyTuple<T1, T2, T3, T4>, TTargetEntity>> select)
where TTargetEntity : class
Parameters
Type |
Name |
Description |
System.String |
tableName |
|
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TTargetEntity>> |
select |
|
Returns
Type |
Description |
System.Int32 |
|
Type Parameters
Name |
Description |
TTargetEntity |
|
|
Improve this Doc
View Source
InsertIntoAsync<TTargetEntity>(String, Expression<Func<T1, T2, T3, T4, TTargetEntity>>, CancellationToken)
Declaration
Task<int> InsertIntoAsync<TTargetEntity>(string tableName, Expression<Func<T1, T2, T3, T4, TTargetEntity>> select, CancellationToken cancellationToken = default(CancellationToken))
where TTargetEntity : class
Parameters
Type |
Name |
Description |
System.String |
tableName |
|
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, 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
InsertIntoAsync<TTargetEntity>(String, Expression<Func<HzyTuple<T1, T2, T3, T4>, TTargetEntity>>, CancellationToken)
Declaration
Task<int> InsertIntoAsync<TTargetEntity>(string tableName, Expression<Func<HzyTuple<T1, T2, T3, T4>, TTargetEntity>> select, CancellationToken cancellationToken = default(CancellationToken))
where TTargetEntity : class
Parameters
Type |
Name |
Description |
System.String |
tableName |
|
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, 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
LeftJoin(Expression<Func<T1, T2, T3, T4, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> LeftJoin(Expression<Func<T1, T2, T3, T4, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
LeftJoin(Expression<Func<HzyTuple<T1, T2, T3, T4>, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> LeftJoin(Expression<Func<HzyTuple<T1, T2, T3, T4>, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
Max<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>)
Declaration
TMember Max<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
Returns
Type Parameters
|
Improve this Doc
View Source
Max<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>)
Declaration
TMember Max<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
Returns
Type Parameters
|
Improve this Doc
View Source
MaxAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>, CancellationToken)
Declaration
Task<TMember> MaxAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TMember> |
|
Type Parameters
|
Improve this Doc
View Source
MaxAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>, CancellationToken)
Declaration
Task<TMember> MaxAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TMember> |
|
Type Parameters
|
Improve this Doc
View Source
Min<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>)
Declaration
TMember Min<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
Returns
Type Parameters
|
Improve this Doc
View Source
Min<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>)
Declaration
TMember Min<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
Returns
Type Parameters
|
Improve this Doc
View Source
MinAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>, CancellationToken)
Declaration
Task<TMember> MinAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TMember> |
|
Type Parameters
|
Improve this Doc
View Source
MinAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>, CancellationToken)
Declaration
Task<TMember> MinAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TMember> |
|
Type Parameters
|
Improve this Doc
View Source
OrderBy<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>)
Declaration
ISelect<T1, T2, T3, T4> OrderBy<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
Type Parameters
|
Improve this Doc
View Source
OrderBy<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>)
Declaration
ISelect<T1, T2, T3, T4> OrderBy<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
Type Parameters
|
Improve this Doc
View Source
OrderByDescending<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>)
Declaration
ISelect<T1, T2, T3, T4> OrderByDescending<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
Type Parameters
|
Improve this Doc
View Source
OrderByDescending<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>)
Declaration
ISelect<T1, T2, T3, T4> OrderByDescending<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
Type Parameters
|
Improve this Doc
View Source
OrderByIf<TMember>(Boolean, Expression<Func<T1, T2, T3, T4, TMember>>, Boolean)
Declaration
ISelect<T1, T2, T3, T4> OrderByIf<TMember>(bool condition, Expression<Func<T1, T2, T3, T4, TMember>> column, bool descending = false)
Parameters
Type |
Name |
Description |
System.Boolean |
condition |
|
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
System.Boolean |
descending |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
Type Parameters
|
Improve this Doc
View Source
OrderByIf<TMember>(Boolean, Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>, Boolean)
Declaration
ISelect<T1, T2, T3, T4> OrderByIf<TMember>(bool condition, Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column, bool descending = false)
Parameters
Type |
Name |
Description |
System.Boolean |
condition |
|
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
System.Boolean |
descending |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
Type Parameters
|
Improve this Doc
View Source
RightJoin(Expression<Func<T1, T2, T3, T4, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> RightJoin(Expression<Func<T1, T2, T3, T4, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
RightJoin(Expression<Func<HzyTuple<T1, T2, T3, T4>, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> RightJoin(Expression<Func<HzyTuple<T1, T2, T3, T4>, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
Sum<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>)
Declaration
decimal Sum<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
Returns
Type |
Description |
System.Decimal |
|
Type Parameters
|
Improve this Doc
View Source
Sum<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>)
Declaration
decimal Sum<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
Returns
Type |
Description |
System.Decimal |
|
Type Parameters
|
Improve this Doc
View Source
SumAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>>, CancellationToken)
Declaration
Task<decimal> SumAsync<TMember>(Expression<Func<T1, T2, T3, T4, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Decimal> |
|
Type Parameters
|
Improve this Doc
View Source
SumAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>>, CancellationToken)
Declaration
Task<decimal> SumAsync<TMember>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TMember>> column, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TMember>> |
column |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Decimal> |
|
Type Parameters
|
Improve this Doc
View Source
ToAggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, ISelectGroupingAggregate<T2>, ISelectGroupingAggregate<T3>, ISelectGroupingAggregate<T4>, TReturn>>)
Declaration
TReturn ToAggregate<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, ISelectGroupingAggregate<T2>, ISelectGroupingAggregate<T3>, ISelectGroupingAggregate<T4>, TReturn>> select)
Parameters
Returns
Type Parameters
|
Improve this Doc
View Source
ToAggregateAsync<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, ISelectGroupingAggregate<T2>, ISelectGroupingAggregate<T3>, ISelectGroupingAggregate<T4>, TReturn>>, CancellationToken)
Declaration
Task<TReturn> ToAggregateAsync<TReturn>(Expression<Func<ISelectGroupingAggregate<T1>, ISelectGroupingAggregate<T2>, ISelectGroupingAggregate<T3>, ISelectGroupingAggregate<T4>, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Returns
Type |
Description |
System.Threading.Tasks.Task<TReturn> |
|
Type Parameters
|
Improve this Doc
View Source
ToChunk<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>, Int32, Action<FetchCallbackArgs<List<TReturn>>>)
Declaration
void ToChunk<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select, int size, Action<FetchCallbackArgs<List<TReturn>>> done)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
System.Int32 |
size |
|
System.Action<FetchCallbackArgs<System.Collections.Generic.List<TReturn>>> |
done |
|
Type Parameters
|
Improve this Doc
View Source
ToChunk<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>, Int32, Action<FetchCallbackArgs<List<TReturn>>>)
Declaration
void ToChunk<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select, int size, Action<FetchCallbackArgs<List<TReturn>>> done)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
System.Int32 |
size |
|
System.Action<FetchCallbackArgs<System.Collections.Generic.List<TReturn>>> |
done |
|
Type Parameters
|
Improve this Doc
View Source
ToDataTable<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>)
Declaration
DataTable ToDataTable<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
Returns
Type |
Description |
System.Data.DataTable |
|
Type Parameters
|
Improve this Doc
View Source
ToDataTable<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>)
Declaration
DataTable ToDataTable<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
Returns
Type |
Description |
System.Data.DataTable |
|
Type Parameters
|
Improve this Doc
View Source
ToDataTableAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>, CancellationToken)
Declaration
Task<DataTable> ToDataTableAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Data.DataTable> |
|
Type Parameters
|
Improve this Doc
View Source
ToDataTableAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>, CancellationToken)
Declaration
Task<DataTable> ToDataTableAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Data.DataTable> |
|
Type Parameters
|
Improve this Doc
View Source
ToList<TDto>()
Declaration
List<TDto> ToList<TDto>()
Returns
Type |
Description |
System.Collections.Generic.List<TDto> |
|
Type Parameters
|
Improve this Doc
View Source
ToList<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>)
Declaration
List<TReturn> ToList<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
Returns
Type |
Description |
System.Collections.Generic.List<TReturn> |
|
Type Parameters
|
Improve this Doc
View Source
ToList<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>)
Declaration
List<TReturn> ToList<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
Returns
Type |
Description |
System.Collections.Generic.List<TReturn> |
|
Type Parameters
|
Improve this Doc
View Source
ToListAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>, CancellationToken)
Declaration
Task<List<TReturn>> ToListAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Collections.Generic.List<TReturn>> |
|
Type Parameters
|
Improve this Doc
View Source
ToListAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>, CancellationToken)
Declaration
Task<List<TReturn>> ToListAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<System.Collections.Generic.List<TReturn>> |
|
Type Parameters
|
Improve this Doc
View Source
ToListAsync<TDto>(CancellationToken)
Declaration
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
|
Improve this Doc
View Source
ToOne<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>)
Declaration
TReturn ToOne<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
Returns
Type Parameters
|
Improve this Doc
View Source
ToOne<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>)
Declaration
TReturn ToOne<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
Returns
Type Parameters
|
Improve this Doc
View Source
ToOneAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>, CancellationToken)
Declaration
Task<TReturn> ToOneAsync<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TReturn> |
|
Type Parameters
|
Improve this Doc
View Source
ToOneAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>, CancellationToken)
Declaration
Task<TReturn> ToOneAsync<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select, CancellationToken cancellationToken = default(CancellationToken))
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
System.Threading.CancellationToken |
cancellationToken |
|
Returns
Type |
Description |
System.Threading.Tasks.Task<TReturn> |
|
Type Parameters
|
Improve this Doc
View Source
ToSql<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>>, FieldAliasOptions)
Declaration
string ToSql<TReturn>(Expression<Func<T1, T2, T3, T4, TReturn>> select, FieldAliasOptions fieldAlias = FieldAliasOptions.AsIndex)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TReturn>> |
select |
|
FieldAliasOptions |
fieldAlias |
|
Returns
Type |
Description |
System.String |
|
Type Parameters
|
Improve this Doc
View Source
ToSql<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>>, FieldAliasOptions)
Declaration
string ToSql<TReturn>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TReturn>> select, FieldAliasOptions fieldAlias = FieldAliasOptions.AsIndex)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TReturn>> |
select |
|
FieldAliasOptions |
fieldAlias |
|
Returns
Type |
Description |
System.String |
|
Type Parameters
|
Improve this Doc
View Source
Where(Expression<Func<T1, T2, T3, T4, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> Where(Expression<Func<T1, T2, T3, T4, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
Where(Expression<Func<HzyTuple<T1, T2, T3, T4>, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> Where(Expression<Func<HzyTuple<T1, T2, T3, T4>, bool>> exp)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
WhereIf(Boolean, Expression<Func<T1, T2, T3, T4, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> WhereIf(bool condition, Expression<Func<T1, T2, T3, T4, bool>> exp)
Parameters
Type |
Name |
Description |
System.Boolean |
condition |
|
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
WhereIf(Boolean, Expression<Func<HzyTuple<T1, T2, T3, T4>, Boolean>>)
Declaration
ISelect<T1, T2, T3, T4> WhereIf(bool condition, Expression<Func<HzyTuple<T1, T2, T3, T4>, bool>> exp)
Parameters
Type |
Name |
Description |
System.Boolean |
condition |
|
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, System.Boolean>> |
exp |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
WithSql(String, String, String, String, Object)
Declaration
ISelect<T1, T2, T3, T4> WithSql(string sqlT1, string sqlT2, string sqlT3, string sqlT4, object parms = null)
Parameters
Type |
Name |
Description |
System.String |
sqlT1 |
|
System.String |
sqlT2 |
|
System.String |
sqlT3 |
|
System.String |
sqlT4 |
|
System.Object |
parms |
|
Returns
Type |
Description |
ISelect<T1, T2, T3, T4> |
|
|
Improve this Doc
View Source
WithTempQuery<TDto>(Expression<Func<T1, T2, T3, T4, TDto>>)
Declaration
ISelect<TDto> WithTempQuery<TDto>(Expression<Func<T1, T2, T3, T4, TDto>> selector)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<T1, T2, T3, T4, TDto>> |
selector |
|
Returns
Type Parameters
|
Improve this Doc
View Source
WithTempQuery<TDto>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TDto>>)
Declaration
ISelect<TDto> WithTempQuery<TDto>(Expression<Func<HzyTuple<T1, T2, T3, T4>, TDto>> selector)
Parameters
Type |
Name |
Description |
System.Linq.Expressions.Expression<System.Func<HzyTuple<T1, T2, T3, T4>, TDto>> |
selector |
|
Returns
Type Parameters
Extension Methods
FreeSqlGlobalExtensions.OrderByRandom<TSelect, T1>(FreeSql.ISelect0<TSelect, T1>)