public string getProductionVendorForShippingAndWorkOrder(string ContactID) { var sqlStr = new StringBuilder(); sqlStr.AppendFormat(@" SELECT FirstName + '' + LastName AS NAME FROM dbo.Contact WHERE ContactID=@ContactID "); var parameters = new DynamicParameters(); parameters.Add("ContactID", ContactID); return(_dapperRepository.ExecuteQueryFirstOrDefault <string>(sqlStr.ToString(), parameters)); }