Пример #1
0
 public void TestExpression()
 {
     using (var con = new NpgsqlConnection(Infrastructure.PgSql.PgConfig.ConnectionStr))
     {
         var a    = new DapperExtension <TUser>();
         var list =
             a.Select("max(id),name")
             .Where(p => (p.Id >= 0 || p.Name == "name") && p.Name != null)
             .GroupBy(p => new { p.Name })
             .Having("having count(1)>0")
             .ToList(con);
     }
 }