public static void AggregateQuery()
{
IQuery <User> q = context.Query <User>();
q.Select(a => AggregateFunctions.Count()).First();
/*
* SELECT COUNT(1) AS "C" FROM "USERS" "USERS" WHERE ROWNUM < 2
*/
q.Select(a => new { Count = AggregateFunctions.Count(), LongCount = AggregateFunctions.LongCount(), Sum = AggregateFunctions.Sum(a.Age), Max = AggregateFunctions.Max(a.Age), Min = AggregateFunctions.Min(a.Age), Average = AggregateFunctions.Average(a.Age) }).First();
/*
* SELECT COUNT(1) AS "COUNT",COUNT(1) AS "LONGCOUNT",SUM("USERS"."AGE") AS "SUM",MAX("USERS"."AGE") AS "MAX",MIN("USERS"."AGE") AS "MIN",AVG("USERS"."AGE") AS "AVERAGE" FROM "USERS" "USERS" WHERE ROWNUM < 2
*/
var count = q.Count();
/*
* SELECT COUNT(1) AS "C" FROM "USERS" "USERS"
*/
var longCount = q.LongCount();
/*
* SELECT COUNT(1) AS "C" FROM "USERS" "USERS"
*/
var sum = q.Sum(a => a.Age);
/*
* SELECT SUM("USERS"."AGE") AS "C" FROM "USERS" "USERS"
*/
var max = q.Max(a => a.Age);
/*
* SELECT MAX("USERS"."AGE") AS "C" FROM "USERS" "USERS"
*/
var min = q.Min(a => a.Age);
/*
* SELECT MIN("USERS"."AGE") AS "C" FROM "USERS" "USERS"
*/
var avg = q.Average(a => a.Age);
/*
* SELECT AVG("USERS"."AGE") AS "C" FROM "USERS" "USERS"
*/
ConsoleHelper.WriteLineAndReadKey();
}
public static void AggregateQuery()
{
IQuery <User> q = context.Query <User>();
q.Select(a => AggregateFunctions.Count()).First();
/*
* SELECT COUNT(1) AS `C` FROM `Users` AS `Users` LIMIT 0,1
*/
q.Select(a => new { Count = AggregateFunctions.Count(), LongCount = AggregateFunctions.LongCount(), Sum = AggregateFunctions.Sum(a.Age), Max = AggregateFunctions.Max(a.Age), Min = AggregateFunctions.Min(a.Age), Average = AggregateFunctions.Average(a.Age) }).First();
/*
* SELECT COUNT(1) AS `Count`,COUNT(1) AS `LongCount`,CAST(SUM(`Users`.`Age`) AS SIGNED) AS `Sum`,MAX(`Users`.`Age`) AS `Max`,MIN(`Users`.`Age`) AS `Min`,AVG(`Users`.`Age`) AS `Average` FROM `Users` AS `Users` LIMIT 0,1
*/
var count = q.Count();
/*
* SELECT COUNT(1) AS `C` FROM `Users` AS `Users`
*/
var longCount = q.LongCount();
/*
* SELECT COUNT(1) AS `C` FROM `Users` AS `Users`
*/
var sum = q.Sum(a => a.Age);
/*
* SELECT CAST(SUM(`Users`.`Age`) AS SIGNED) AS `C` FROM `Users` AS `Users`
*/
var max = q.Max(a => a.Age);
/*
* SELECT MAX(`Users`.`Age`) AS `C` FROM `Users` AS `Users`
*/
var min = q.Min(a => a.Age);
/*
* SELECT MIN(`Users`.`Age`) AS `C` FROM `Users` AS `Users`
*/
var avg = q.Average(a => a.Age);
/*
* SELECT AVG(`Users`.`Age`) AS `C` FROM `Users` AS `Users`
*/
ConsoleHelper.WriteLineAndReadKey();
}
public static void AggregateQuery()
{
IQuery <User> q = context.Query <User>();
q.Select(a => AggregateFunctions.Count()).First();
/*
* SELECT TOP (1) COUNT(1) AS [C] FROM [Users] AS [Users]
*/
q.Select(a => new { Count = AggregateFunctions.Count(), LongCount = AggregateFunctions.LongCount(), Sum = AggregateFunctions.Sum(a.Age), Max = AggregateFunctions.Max(a.Age), Min = AggregateFunctions.Min(a.Age), Average = AggregateFunctions.Average(a.Age) }).First();
/*
* SELECT TOP (1) COUNT(1) AS [Count],COUNT_BIG(1) AS [LongCount],CAST(SUM([Users].[Age]) AS INT) AS [Sum],MAX([Users].[Age]) AS [Max],MIN([Users].[Age]) AS [Min],CAST(AVG([Users].[Age]) AS FLOAT) AS [Average] FROM [Users] AS [Users]
*/
var count = q.Count();
/*
* SELECT COUNT(1) AS [C] FROM [Users] AS [Users]
*/
var longCount = q.LongCount();
/*
* SELECT COUNT_BIG(1) AS [C] FROM [Users] AS [Users]
*/
var sum = q.Sum(a => a.Age);
/*
* SELECT CAST(SUM([Users].[Age]) AS INT) AS [C] FROM [Users] AS [Users]
*/
var max = q.Max(a => a.Age);
/*
* SELECT MAX([Users].[Age]) AS [C] FROM [Users] AS [Users]
*/
var min = q.Min(a => a.Age);
/*
* SELECT MIN([Users].[Age]) AS [C] FROM [Users] AS [Users]
*/
var avg = q.Average(a => a.Age);
/*
* SELECT CAST(AVG([Users].[Age]) AS FLOAT) AS [C] FROM [Users] AS [Users]
*/
ConsoleHelper.WriteLineAndReadKey();
}
public static void AggregateFunctionTest()
{
MsSqlContext context = new MsSqlContext(DbHelper.ConnectionString);
var q = context.Query <User>();
q = q.Where(a => a.Id > 0);
var xxx = q.Select(a => AggregateFunctions.Count()).First();
q.Select(a => new { Count = AggregateFunctions.Count(), LongCount = AggregateFunctions.LongCount(), Sum = AggregateFunctions.Sum(a.Age), Max = AggregateFunctions.Max(a.Age), Min = AggregateFunctions.Min(a.Age), Average = AggregateFunctions.Average(a.Age) }).First();
var count = q.Count();
var longCount = q.LongCount();
var sum = q.Sum(a => a.Age);
var max = q.Max(a => a.Age);
var min = q.Min(a => a.Age);
var avg = q.Average(a => a.Age);
Console.WriteLine(1);
}
