Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. public async Task<List<StaffWorkMuchModel>> ExemptStaffWorkMuchPerWeek(int quarterId, int facilityId) {
  2. using (var dbConnection = (IDbConnection) _serviceProvider.GetService(typeof(IDbConnection))) {
  3. dbConnection.ConnectionString += "ApplicationIntent=READONLY;";
  4. dbConnection.Open();
  5. return (await dbConnection.QueryAsync<StaffWorkMuchModel>("ExemptStaffWorkMuchPerWeek", new {
  6. id_qtr = quarterId,
  7. id_fac = facilityId
  8. }, commandType: CommandType.StoredProcedure, commandTimeout: 150)).ToList();
  9. }
  10. }
  11.  
  12. dbConnection.ConnectionString += "ApplicationIntent=READONLY;";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement