vbilopav / noorm.net Goto Github PK

Contributors

Stargazers

Forkers

ersintarhan xgame92 alfxp ductai230894 jtone123 azraelrabbit drakkonite slynch13 caoabc123

    public IAsyncEnumerable<AreaSummary> GetAreaAsync() =>
          _connection.ReadAsync(@"
                    select Description,  count(*) as cnt
                  From A
                  inner join lookup L2
                  on A.areaID= L2.ID
	  Group by  L2.Description

				  order by L2.Description")
            .Select<AreaSummary>()

        .SelectAwait(async u =>
        {
            await Task.Delay(1);
            return u;
        });

public class AreaSummary
{
    public string Description { get; set; }

    public int sum { get; set; }

}