Exemplos de Microsoft.Data.SqlClient SqlConnection.QueryAsync em C# (CSharp)

Exemplo n.º 1

 public async Task <IEnumerable <Subject> > GetAllSubject()
 {
     return(await _context.QueryAsync <Subject>(
                @"SELECT Subjects.*,
             (SELECT COUNT(*) FROM dbo.Posts  WHERE IsDelete=0
             AND dbo.Posts.SubjectId=dbo.Subjects.id) AS CntPost
             FROM dbo.Subjects  WHERE IsDelete=0 "));
 }