问题描述
想象一下这个 sql 查询
Imagine this sql query
select * from products order by name collate Persian_100_CI_AI asc
现在使用 Linq:
product = DB.Products.OrderBy(p => p.name); // what should I do here?
如何应用排序规则?
推荐答案
现在可以使用 整理 功能.
This is now possible with EF Core 5.0 using the collate function.
在您的示例中,代码为:
In your example the code would be:
product = DB.Products.OrderBy(p => EF.Functions.Collate(p.name, "Persian_100_CI_AI"));