blocks|key|87114|text|将此行添加到出现此错误的文件的顶部。FromSql是一种扩展方法，在Microsoft.EntityFrameworkCore.Relational程序集中实现。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|87115|using+Microsoft.EntityFrameworkCore.Relational;|code-block|syntax|javascript|87116|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Add this line on top of the file where you are getting this error. FromSql is an extension method and is implemented in Microsoft.EntityFrameworkCore.Relational assembly.

<pre><code>using Microsoft.EntityFrameworkCore.Relational;
</code></pre>

blocks|key|89833|text|这可能在Umer回答后发生了变化。它现在位于Microsoft.EntityFrameworkCore名称空间中。但是你需要引用这个包。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|89834|所以..。|89835|dotnet+add+package+Microsoft.EntityFrameworkCore.Relational|code-block|syntax|javascript|89836|再加上这一行...|89837|using+Microsoft.EntityFrameworkCore;|89838|entityMap^0|M|T|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|R|$]]

This might have changed since Umer answered. It is now in the <code>Microsoft.EntityFrameworkCore</code> namespace. But you will need to reference the package.

So...

<pre><code>dotnet add package Microsoft.EntityFrameworkCore.Relational
</code></pre>

And add this line...

<pre><code>using Microsoft.EntityFrameworkCore;
</code></pre>

blocks|key|87137|text|安装Microsoft.EntityFrameworkCore.Relational+nuget包，然后将using语句添加到类中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|87138|使用Microsoft.EntityFrameworkCore;|87139|entityMap^0|2|14|0|2|U|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

install <code>Microsoft.EntityFrameworkCore.Relational</code> nuget package and then add the using statement to the class 

using <code>Microsoft.EntityFrameworkCore;</code>

blocks|key|87152|text|我用下面这行代码解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|87153|using+Microsoft.EntityFrameworkCore;|code-block|syntax|javascript|87154|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

It solved for me with this using this line:

<pre><code>using Microsoft.EntityFrameworkCore;
</code></pre>

blocks|key|2821842|text|在最新版本中，Microsoft将此方法重命名为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2821843|FromSqlInterpolated()|code-block|syntax|javascript|2821844|https://docs.microsoft.com/en-us/ef/core/querying/raw-sql|offset|length|2821845|因此，您必须使用.FromSql+to+.FromSqlInterpolated查找/替换所有代码。他们讨论了上述文档中的动机，尽管我不得不说新方法名称的长度是不受欢迎的。|2821846|其他答案所说的仍然是必要的-您需要安装Nuget包Microsoft.EntityFrameworkCore.Relational，并且为Microsoft.EntityFramework添加了一条using语句。|2821847|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|1L|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|L|5|6|7|11|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|12|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|H]]]]

In the latest version, Microsoft renamed this method to:
<pre><code>FromSqlInterpolated()
</code></pre>
<a href="https://docs.microsoft.com/en-us/ef/core/querying/raw-sql" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/ef/core/querying/raw-sql</a>
So you'll have to find/replace all the code using .FromSql to .FromSqlInterpolated. They discuss the motivation in the above document, although I have to say the length of the new method name is unwelcome.
What the other answers say is still necessary - you'll need to have installed the Nuget package Microsoft.EntityFrameworkCore.Relational, and, have added a using statement for Microsoft.EntityFramework.

blocks|key|2609633|text|希望这可能是有用的，因为它与上述问题相关，并很可能其他人也会有同样的问题。我无法访问驻留在独立于Web.Api+(MVC项目)的服务项目中的.FromSql，但我能够从Web.Api项目的控制器中访问.FromSql。让我困惑的是，在web.api项目中没有直接引用Microsoft.EntityFrameworkCore.Relational，EntityFramework项目引用了Microsoft.EntityFrameworkCore.SqlServer+nuget包。通过添加对服务项目的引用，服务现在能够使用.FromSql。这是漫长的一天，但我仍然不知道web.api为什么工作，但服务项目需要一个直接的参考。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2609634|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Hope this might be useful as it's related to the above issue and is likely that others will have the same problem. I was not able to access .FromSql inside of a service that resided in a seperate service project from the Web.Api (MVC Project) I was able to access the .FromSql from within a controller in the Web.Api project. What confused me was that there is no direct reference in the web.api project for Microsoft.EntityFrameworkCore.Relational The Microsoft.EntityFrameworkCore.SqlServer nuget package is referenced by the EntityFramework project. By adding a reference to the service project the services are now able to use the .FromSql. It's been a long day but I still don't know why the web.api works but the service project needs a direct reference.

I am trying to call view or store procedure using asp.net core 2.1 on mac os webapi.

<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>

Getting the below error 

<blockquote>
 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)
</blockquote>

I am developing webapi using entity framework on mac os.

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>

<a href="https://stackoverflow.com/questions/35631903/raw-sql-query-without-dbset-entity-framework-core">Raw SQL Query without DbSet - Entity Framework Core</a>

<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>

<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>

But not able to find the error solution. Can anyone please let me know what I, am missing.

Error CS1061: 'DbSet<T>' does not contain a definition for 'FromSql' and no extension method 'FromSql' accepting a first argument of type 'DbSet<T>'

我正尝试在mac os webapi上使用asp.net core 2.1调用视图或存储过程。using System;using System.Linq;using Auth.Database;using Microsoft.EntityFrameworkCore;public virtual IQueryable<...

问错误CS1061：'DbSet<T>‘不包含'FromSql’的定义，并且没有扩展方法'FromSql‘接受类型为'DbSet<T>’的第一个参数
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误CS1061：'DbSet<T>‘不包含'FromSql’的定义，并且没有扩展方法'FromSql‘接受类型为'DbSet<T>’的第一个参数EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误CS1061：'DbSet<T>‘不包含'FromSql’的定义，并且没有扩展方法'FromSql‘接受类型为'DbSet<T>’的第一个参数
EN