"像"实体框架中的查询 [英] "like" queries in Entity Framework

问题描述

如何在ASP.NET MVC中使用edo实体框架获取通配符文本搜索（如SQL的like语句）？

How do I get wildcard text searches (like SQL's "like" statement) in ASP.net MVC using the edo entity framework?

我认为这将工作：

var elig = (from e in _documentDataModel.Protocol_Eligibility_View
            where e.criteria.Contains(query)
            select e);

但即使搜索绝对在数据库中的查询字符串，也不会返回结果。我做错了什么？

But it returns no results even when searching for a query string that's definitely in the database. What am I doing wrong?

推荐答案

String.Contains应该正常工作。 SQL的LIKE语句通常通过String.StartsWith，String.Contains或String.EndsWith来处理。

String.Contains should work appropriately. SQL's LIKE statement is typically handled via String.StartsWith, String.Contains, or String.EndsWith.

但是，您可能会遇到套件问题。您可以尝试：

However, it is possible you're having casing issues. You could try:

var elig = (from e in _documentDataModel.Protocol_Eligibility_View
        where e.criteria.ToLower().Contains(query.ToLower())
        select e);

这篇关于"像"实体框架中的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！