C# (CSharp) IOrgManagerDbQueryFacade.QuerySingleAsync示例

示例#1

 public Task <GetEmployeeDetailViewModel> Handle(GetEmployeeDetailQuery request, CancellationToken cancellationToken) =>
 queryFacade.QuerySingleAsync <GetEmployeeDetailViewModel>(@"SELECT TOP 1 Address1, Address2, City, CurrencyCode, DateExited, DateHired, DateOfBirth, EmployeeLevel, FirstName, Gender, Id, LastName, MiddleName, PaidTimeOffPolicyId, PtoHoursRemaining, Salary, State, Zip FROM Employees WHERE Id = @Id", request);

示例#2

文件： GetPaidTimeOffPolicyDetailQuery.cs 项目： VilemProchazka/OrgManager

 public Task <GetPaidTimeOffPolicyDetailViewModel> Handle(GetPaidTimeOffPolicyDetailQuery request, CancellationToken cancellationToken) =>
 queryFacade.QuerySingleAsync <GetPaidTimeOffPolicyDetailViewModel>("SELECT TOP 1 AllowsUnlimitedPto, EmployeeLevel, Id, IsDefaultForEmployeeLevel, MaxPtoHours, Name, PtoAccrualRate FROM PaidTimeOffPolicies WITH(NOLOCK) WHERE Id = @Id", request);