blocks|key|2816950|text|正如文档所述，EntityFunctions|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2816951|2816952|提供了公共语言运行库方法，这些方法公开LINQ+to+Entities查询中的概念模型规范函数。有关规范函数的信息，请参见规范函数(实体SQL)。|blockquote|2816953|2816954|2816955|where+Canonical+functions|2816956|所有数据提供程序都支持|2816957|，并且所有查询技术都可以使用它。规范函数不能由提供程序扩展。这些规范函数将被转换为提供程序的相应数据源功能。这允许跨数据源以通用形式表示函数调用。|2816958|2816959|2816960|而SQLFunctions|2816961|2816962|提供了公共语言运行库方法，这些方法在LINQ+to+Entities查询中调用数据库中的函数。|2816963|2816964|2816965|因此，尽管这两组函数都被转换成原生SQL，但SQLFunctions是特定于SQL+Server的，而EntityFunctions不是。|2816966|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.data.objects.entityfunctions.aspx|1|http://msdn.microsoft.com/en-us/library/bb738626.aspx|2|http://msdn.microsoft.com/en-us/library/system.data.objects.sqlclient.sqlfunctions.aspx^0|7|F|0|0|0|0|0|0|6|J|1|0|0|0|0|0|1|C|2|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@$A|1D|B|1E|1|1F]]|C|$]]|$1|D|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|1H|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|1I|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1K|8|@]|9|@$A|1L|B|1M|1|1N]]|C|$]]|$1|L|3|M|5|6|7|1O|8|@]|9|@]|C|$]]|$1|N|3|O|5|G|7|1P|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1Q|8|@]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|1R|8|@]|9|@]|C|$]]|$1|R|3|S|5|6|7|1S|8|@]|9|@$A|1T|B|1U|1|1V]]|C|$]]|$1|T|3|-4|5|6|7|1W|8|@]|9|@]|C|$]]|$1|U|3|V|5|G|7|1X|8|@]|9|@]|C|$]]|$1|W|3|-4|5|6|7|1Y|8|@]|9|@]|C|$]]|$1|X|3|-4|5|6|7|1Z|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|6|7|20|8|@]|9|@]|C|$]]|$1|10|3|-4|5|6|7|21|8|@]|9|@]|C|$]]]|11|$12|$5|13|14|15|C|$16|17]]|18|$5|13|14|15|C|$16|19]]|1A|$5|13|14|15|C|$16|1B]]]]

As the documentation states <a href="http://msdn.microsoft.com/en-us/library/system.data.objects.entityfunctions.aspx">EntityFunctions</a>

<blockquote>
 Provides common language runtime (CLR) methods that expose conceptual
 model canonical functions in LINQ to Entities queries. For information
 about canonical functions, see Canonical Functions (Entity SQL).
</blockquote>

where <a href="http://msdn.microsoft.com/en-us/library/bb738626.aspx">Canonical functions</a>

<blockquote>
 are supported by all data providers, and can be used by all querying
 technologies. Canonical functions cannot be extended by a provider.
 These canonical functions will be translated to the corresponding data
 source functionality for the provider. This allows for function
 invocations expressed in a common form across data sources.
</blockquote>

Whereas <a href="http://msdn.microsoft.com/en-us/library/system.data.objects.sqlclient.sqlfunctions.aspx">SQLFunctions</a>

<blockquote>
 Provides common language runtime (CLR) methods that call functions in
 the database in LINQ to Entities queries.
</blockquote>

Therefore although both sets of functions are translated into native SQL, SQLFunctions are SQL Server specific, whereas EntityFunctions aren't.

blocks|key|2816997|text|当我读到它的时候。CLR将EntityFunctions函数转换为所有数据提供程序都支持“规范函数”。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2816998|但是SqlFunctions使得SQL+Server来做这项工作，并且他们指定只为SQL+Server。|2816999|For+more+information|2817000|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.data.objects.entityfunctions.aspx^0|19|4|0|G|A|0|0|K|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|J|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

As i read about it.
The CLR convert EntityFunctions functions to "canonical functions" which are supported by all data providers.

But the SqlFunctions make the SQL Server to do the work and they specified just for SQL Server.

<a href="http://msdn.microsoft.com/en-us/library/system.data.objects.entityfunctions.aspx" rel="noreferrer">For more information</a>

blocks|key|193061|text|SqlFunctions是在EF4中引入的静态类，它位于程序集System.Data.Entity中。它包含一长串映射到SQL+Server函数的方法，如Cos,+DateAdd,+DateDiff,+DatePart,+GetDate,+Exp,+Sign。可以在LINQ+to+Entities查询中调用这些静态函数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|193062|​|193063|📷|atomic|193064|193065|EF4还引入了静态EntityFunctions类。这个类公开了概念模型的规范函数，可以在LINQ+to+Entities查询中使用。这些函数映射到System.Data.Metadata.Edm命名空间中的函数，并且它们仅在概念模型中可用。|193066|193067|193068|193069|有关详细信息，请单击here|193070|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9c0225c8060c6a4ab92adab1c9b3fd9c.jpeg|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/de528470775e982a8ab39d5e20c78bbf.jpeg|2|LINK|MUTABLE|url|http://www.scip.be/index.php?Page=ArticlesNET34^0|0|C|V|I|25|1G|0|0|0|1|0|0|0|9|F|0|0|0|1|1|0|0|A|4|2|0^^$0|@$1|2|3|4|5|6|7|18|8|@$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]|$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1F|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1G|8|@]|D|@$9|1H|A|1I|1|1J]]|E|$]]|$1|K|3|G|5|6|7|1K|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1L|8|@$9|1M|A|1N|B|C]]|D|@]|E|$]]|$1|N|3|G|5|6|7|1O|8|@]|D|@]|E|$]]|$1|O|3|I|5|J|7|1P|8|@]|D|@$9|1Q|A|1R|1|1S]]|E|$]]|$1|P|3|G|5|6|7|1T|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1U|8|@]|D|@$9|1V|A|1W|1|1X]]|E|$]]|$1|S|3|-4|5|6|7|1Y|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z|10|-4]]|11|$5|V|W|X|E|$Y|12|10|-4]]|13|$5|14|W|15|E|$16|17]]]]

<code>SqlFunctions</code> is a static class introduced in EF4 and is in assembly <code>System.Data.Entity</code>. It contains a long list of methods like <code>Cos, DateAdd, DateDiff, DatePart, GetDate, Exp, Sign</code>, which are mapped to SQL Server functions. These static functions can be called in LINQ to Entities queries.

<img src="https://i.stack.imgur.com/rJkA6.jpg" alt="enter image description here">

EF4 also introduced the static <code>EntityFunctions</code> class. This class exposes conceptual model canonical functions which can be used in LINQ to Entities queries. These functions are mapped to the functions in the System.Data.Metadata.Edm namespace and they are only available in the conceptual model.

<img src="https://i.stack.imgur.com/DIwcD.jpg" alt="enter image description here">

For more information click <a href="http://www.scip.be/index.php?Page=ArticlesNET34" rel="noreferrer">here</a>

blocks|key|2817096|text|如果有人看到这篇旧文章，System.Data.Entity.EntityFunctions现在已经过时了，取而代之的是System.Data.Entity.DbFunctions。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2817097|entityMap^0|C|Y|1O|U|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

In case anyone comes across this old post, <code>System.Data.Entity.EntityFunctions</code> is now obsolete and replaced with <code>System.Data.Entity.DbFunctions</code>.

What's the difference ?
Are both used to perform functions in sql side before get data and store them in memory ?

P.S: 
Both used in linq to entites.

What is the difference between SqlFunctions and EntityFunctions?

SQL Server

数据库

有什么不同？都是用来在获取数据并存储到内存之前在SQL端执行函数吗？P.S:两者都在linq to entites中使用。

问SqlFunctions和EntityFunctions有什么区别？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SqlFunctions和EntityFunctions有什么区别？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SqlFunctions和EntityFunctions有什么区别？
EN