public async Task <string> ReadName(int serial) { var inputpara = new DynamicParameters(); inputpara.Add("c1", serial, DbType.Int16, ParameterDirection.Input, null); var outputpara = new DynamicParameters(); outputpara.Add("c2", "", DbType.String, ParameterDirection.Output, 10); await _eventLogRepository.ExecuteSPAsync("usp_test", inputpara, outputpara); string result = outputpara.Get <string>("c2"); return(string.IsNullOrEmpty(result) ? "no content" : result); }