GROUP BY/Asp.Net Web API ODATA不区分大小写的扩展? [英] GROUP BY / Case Insensitivity extension for Asp.Net Web API ODATA?

问题描述

在ODATA V4文档中找不到按引用分组.当我们通过URL进行分组查询时，它仅返回键，而不是实际的分组结果.

Couldn't find a group by references in ODATA V4 documentation. When we pass the group by query in URL it just returns the key, not the actual grouped results.

有关在扩展性上使用Asp.Net ODATA中的分组依据的任何参考 ODATA Web API的要点.我们需要全面掌握如何 ODATA查询已解析&转换为LILNQ以进行实体查询.

Any references for using Group by in Asp.Net ODATA, on extensibility points of ODATA Web API. We're in need to take full command over how ODATA query is parsed & transformed into LILNQ to entities query.

我正在谈论拦截ODATA 查询并执行手动自定义操作，例如LINQ到实体

I am talking on the line of intercepting ODATA queries and performing manual customization e.g. LINQ to Entities

我正在努力实现对案例敏感性的类似扩展. Web API中的OData区分大小写过滤吗?

I am trying to achieve a similar extension for Case Sensitivity. OData Case In-Sensitive filtering in Web API?

推荐答案

关于区分大小写:

1. 在将包装的列名和输入的值过滤到tolower()中时，有助于:
2. 但是由def处理大小写敏感度取决于数据库设置.

另外请注意:通过分组，我无法使用odata执行类似$ groupby(tolower(columnname))的操作，所以...

Also a note: with grouping I was not able to do something like $groupby(tolower(columnname)) with odata, so...

这篇关于GROUP BY/Asp.Net Web API ODATA不区分大小写的扩展?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！