title: Dapper return print message from stored procedure
body: <p>I have a stored procedure which I can't modify and I'm trying to get the <code>PRINT</code> message that get's returned if an error occurs. The code in my stored procedure is.</p>
  
  <pre><code>IF((ISNULL(@ID,''))='')
  BEGIN
      PRINT N'Error: This ID is invalid.'; 
      RETURN;
  END
  </code></pre>
  
  <p>In my dapper call, I have the following:</p>
  
  <pre><code>var storedProcResult = connection.Query("AdventureWorks.dbo.myStoredProcedure", new
  {
      @ID = null
  },
   commandType: CommandType.StoredProcedure
  );
  </code></pre>
  
  <p>The value of <code>storedProcResult</code> is <code>0</code> but I'm interested getting the <code>PRINT</code> message. Please advise.</p>