public async Task <IEnumerable <SqlUser> > GetExistingUsersByNamesAsync(IEnumerable <string> userNames) { var prm = new DynamicParameters(); prm.Add("@userNames", SqlConnectionWrapper.ToStringDataTable(userNames)); return(await _connectionWrapper.QueryAsync <SqlUser>("GetExistingUsersByNames", prm, commandType : CommandType.StoredProcedure)); }
public async Task <IEnumerable <SqlGroup> > GetExistingGroupsByNamesAsync(IEnumerable <string> groupNames, bool instanceOnly) { var prm = new DynamicParameters(); prm.Add("@groupNames", SqlConnectionWrapper.ToStringDataTable(groupNames)); prm.Add("@instanceOnly", instanceOnly); return(await _connectionWrapper.QueryAsync <SqlGroup>("GetExistingGroupsByNames", prm, commandType : CommandType.StoredProcedure)); }