如何编写EF.Functions扩展方法? [英] How do I write EF.Functions extension method?
问题描述
I see that EF Core 2 has EF.Functions property EF Core 2.0 Announcement which can be used by EF Core or providers to define methods that map to database functions or operators so that those can be invoked in LINQ queries
. It included LIKE method that gets sent to the database.
但是我需要另一种方法,不包含SOUNDEX().如何编写将DbFunction
属性在EF6中使用的方法传递给数据库的方法?还是我需要等待MS实施?本质上,我需要生成类似
But I need a different method, SOUNDEX() that is not included. How do I write such a method that passes the function to the database the way DbFunction
attribute did in EF6? Or I need to wait for MS to implement it? Essentially, I need to generate something like
SELECT * FROM Customer WHERE SOUNDEX(lastname) = SOUNDEX(@param)
推荐答案
向EF.Functions
添加新的标量方法很容易-您只需在DbFunctions
类上定义扩展方法.但是,提供SQL转换很困难,并且需要深入研究EFC内部.
Adding new scalar method to EF.Functions
is easy - you simply define extension method on DbFunctions
class. However providing SQL translation is hard and requires digging into EFC internals.
但是,"EF Core 2.0的新功能" 文档主题中的数据库标量函数映射部分.
However EFC 2.0 also introduces a much simpler approach, explained in Database scalar function mapping section of the New features in EF Core 2.0 documentation topic.
因此,最简单的方法是在DbContext
派生类中添加静态方法,并使用DbFunction
属性对其进行标记.例如
According to that, the easiest would be to add a static method to your DbContext
derived class and mark it with DbFunction
attribute. E.g.
public class MyDbContext : DbContext
{
// ...
[DbFunction("SOUNDEX")]
public static string Soundex(string s) => throw new Exception();
}
并使用类似这样的内容:
and use something like this:
string param = ...;
MyDbContext db = ...;
var query = db.Customers
.Where(e => MyDbContext.Soundex(e.LastName) == MyDbContext.Soundex(param));
您可以在其他类中声明此类静态方法,但随后需要使用HasDbFunction
fluent API手动注册它们.
You can declare such static methods in a different class, but then you need to manually register them using HasDbFunction
fluent API.
这篇关于如何编写EF.Functions扩展方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!