C# (CSharp) Microsoft.Data.SqlClient SqlConnection.QuerySingleOrDefaultAsync примеры использования

Пример #1

 public async Task <Subject> GetSubjectById(int subjectId)
 {
     return(await _context.QuerySingleOrDefaultAsync <Subject>("SELECT * FROM dbo.Subjects WHERE isDelete=0 AND id=@subjectId", new{ subjectId = subjectId }));
 }