title: Error CS1061: 'DbSet<T>' does not contain a definition for 'FromSql' and no extension method 'FromSql' accepting a first argument of type 'DbSet<T>'
body: <p>I am trying to call view or store procedure using <strong>asp.net core 2.1</strong> on mac os webapi.</p>
  
  <pre><code>using System;
  using System.Linq;
  using Auth.Database;
  using Microsoft.EntityFrameworkCore;
  
  public virtual IQueryable&lt;T&gt; ExecuteStoreProcView(string viewProcName)
  {
      IQueryable&lt;T&gt; queryResult = _entities.Set&lt;T&gt;().FromSql(viewProcName).AsQueryable();
      return queryResult;
  }
  </code></pre>
  
  <p>Getting the below error </p>
  
  <blockquote>
    <p>Error CS1061: 'DbSet' does not contain a definition for 'FromSql'
    and no extension method 'FromSql' accepting a first argument of type
    'DbSet' could be found (are you missing a using directive or an
    assembly reference?) (CS1061)</p>
  </blockquote>
  
  <p>I am developing webapi using entity framework on mac os.</p>
  
  <p>Research some of the queries in below link :- 
  <a href="https://stackoverflow.com/questions/35631903/raw-sql-query-without-dbset-entity-framework-core/35633596">Raw SQL Query without DbSet - Entity Framework Core</a></p>
  
  <p><a href="https://stackoverflow.com/questions/35631903/raw-sql-query-without-dbset-entity-framework-core">Raw SQL Query without DbSet - Entity Framework Core</a></p>
  
  <p><a href="https://forums.asp.net/t/1886501.aspx?System+Data+Entity+DbSet+Entities+User+does+not+contain+a+definition+for+FirstOrDefault+" rel="noreferrer">https://forums.asp.net/t/1886501.aspx?System+Data+Entity+DbSet+Entities+User+does+not+contain+a+definition+for+FirstOrDefault+</a></p>
  
  <p><a href="https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationalqueryableextensions.fromsql?view=efcore-2.1" rel="noreferrer">https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationalqueryableextensions.fromsql?view=efcore-2.1</a></p>
  
  <p>But not able to find the error solution. Can anyone please let me know what I, am missing.</p>