public void TestGroup()
{
var connection = new Npgsql.NpgsqlConnection("Server=127.0.0.1;Port=5432;User Id=postgres;Password=1024;Database=test;");
using (IDbContext db = new DbProxyContext(connection, DbContextType.Postgresql))
{
db.Open();
var list = db.From <Student>()
.GroupBy(a => a.Name)
.Having(a => SqlFun.COUNT(1L) > 1)
.OrderByDescending(a => SqlFun.COUNT(1))
.Select(s => new
{
s.Name,
//Names = SqlFun.GROUP_CONCAT(s.Name),
Count = SqlFun.COUNT(1L),
Balance = SqlFun.SUM(s.Balance)
}).ToList();
}
}
public void TestGroup()
{
var connection = new System.Data.SqlClient.SqlConnection(@"Data Source=DESKTOP-9IS2HA6\SQLEXPRESS;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=1024");
using (IDbContext db = new DbProxyContext(connection, DbContextType.SqlServer))
{
db.Open();
var list = db.From <Student>()
.GroupBy(a => a.Name)
.Having(a => SqlFun.COUNT(1L) > 1)
.OrderByDescending(a => SqlFun.COUNT(1))
.Select(s => new
{
s.Name,
//Names = SqlFun.GROUP_CONCAT(s.Name),
Count = SqlFun.COUNT(1L),
Balance = SqlFun.SUM(s.Balance)
}).ToList();
}
}
public void TestGroup()
{
var connection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=root;password=1024;database=test;");
using (IDbContext db = new DbProxyContext(connection, DbContextType.Mysql))
{
db.Open();
var list = db.From <Student>()
.GroupBy(a => a.Name)
.Having(a => SqlFun.COUNT(1L) > 1)
.OrderByDescending(a => SqlFun.COUNT(1))
.Select(s => new
{
s.Name,
Names = SqlFun.GROUP_CONCAT(s.Name),
Count = SqlFun.COUNT(1L),
Balance = SqlFun.SUM(s.Balance)
}).ToList();
}
}
public void TestGroup()
{
var sb = new System.Data.SQLite.SQLiteConnectionStringBuilder();
sb.DataSource = "D:\\sqlite.db3";
var connection = new System.Data.SQLite.SQLiteConnection(sb.ConnectionString);
using (IDbContext db = new DbProxyContext(connection, DbContextType.Sqlite))
{
db.Open();
var list = db.From <Student>()
.GroupBy(a => a.Name)
.Having(a => SqlFun.COUNT(1L) > 1)
.OrderByDescending(a => SqlFun.COUNT(1))
.Select(s => new
{
s.Name,
Names = SqlFun.GROUP_CONCAT(s.Name),
Count = SqlFun.COUNT(1L),
Balance = SqlFun.SUM(s.Balance)
}).ToList();
}
}
