title: Execute non-query procedure not working asp.net core
body: <p>I want to execute a stored procedure which returns three values (Email, Name, CompanyID) and get one parameter (CompanyID) but it's not working. </p>
  
  <p>I have created a class with these properties and a stored procedure which returns the data. By it is showing <code>DatabaseFacade</code> error.</p>
  
  <p>My code is:</p>
  
  <pre><code> List&lt;MyClass&gt; AppUser = new List&lt;MyClass&gt;(); //Class with three properties
   SqlParameter param1 = new SqlParameter("@CompanyID", CompanyID);
   AppUser = _context.Database.SqlQuery&lt;CC&gt;("GetUserAndRolesForCompany", param1).ToList(); 
  </code></pre>
  
  <p>Showing this error: I have include System.Linq</p>
  
  <blockquote>
    <p>'DatabaseFacade' does not contain a definition for 'SqlQuery' and no extension method 'SqlQuery' accepting a first argument of type 'DatabaseFacade' could be found (are you missing a using directive or an assembly reference?)</p>
  </blockquote>