title: Run entity framework core raw SQL without entity
body: <p>I have this mysql stored-procedure:</p>
  
  <pre><code>CREATE DEFINER=`admin`@`%` PROCEDURE `Counter_increment2`(IN _Id VARCHAR(80), IN _CounterType VARCHAR(10), IN IncrBy INT)
  BEGIN
      UPDATE Counter SET Value = @counter := Value + IncrBy WHERE Id=_Id AND CounterType=_CounterType;
      SELECT @counter as Value;
  END
  </code></pre>
  
  <p>The result is:
  <a href="https://i.stack.imgur.com/XFndT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XFndT.png" alt="enter image description here"></a></p>
  
  <p>I want to read the first cell in the first row into C# variable via EF. </p>
  
  <p>I know that in the past EF provided <code>SqlQuery&lt;type&gt;</code> method for this kind of use. </p>
  
  <p>How to do it right?</p>