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 ")); }