使用 LINQ 和 EF 进行全文搜索

发布于 2024-12-10 17:10:03 字数 662 浏览 0 评论 0原文

我正在尝试使用 EntityFramework 实现全文搜索。

我的数据库有一个名为 Users 的表和一个名为 UserInfoEntries 的表。表 users 连接到其他一些表，表 UserInfoEntries 包含用户信息。

当我想获取用户信息时，我会浏览 User.UserInfoEntries 中的条目并获取具有最旧条目时间戳的条目。

我想要用作全文搜索键的属性是 UserInfoEntry 中的 FullName 属性。

用于获取具有确切 FullName 的用户的 LINQ 如下所示：

from user in objectContext.Users

let currentInfoEntry = 
(from entry in user.UserInfoEntries
 orderby entry.EntryTimestamp descending
 select entry
).FirstOrDefault()

where currentInfoEntry.FullName == "Some Name"

select new UserWithInfo
{
    User = user,
    Info = currentInfoEntry
}

我想使用 FullName 进行全文搜索。有没有比将查询转换为 SQL 更简单的方法？

原文

I'm trying to implement a full-text search with EntityFramework.

My DB has a table called Users and a table called UserInfoEntries. The table users is connected to some other tables, and the table UserInfoEntries contains user information.

When i want to get the user info, i go through the entries in User.UserInfoEntries and get the one with the oldest entry timestamp.

The property i want to use as the key for the full-text search is the FullName property within the UserInfoEntry.

The LINQ for getting the users with the exact FullName looks like this:

from user in objectContext.Users

let currentInfoEntry = 
(from entry in user.UserInfoEntries
 orderby entry.EntryTimestamp descending
 select entry
).FirstOrDefault()

where currentInfoEntry.FullName == "Some Name"

select new UserWithInfo
{
    User = user,
    Info = currentInfoEntry
}

I would like to use the full-text search by FullName. Is there an easier way than transalting the query to SQL?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

余生共白头 2024-12-17 17:10:03

这不是全文搜索。这只是一个完全匹配的普通搜索。您可以通过还原来简化查询：

var query = from x in objectContext.UserInfoEntries.Include("User")
            where x.FullName == "Some Name"
            orderby x.EntryTimestamp descending
            select x;

UserInfoEntry entry = query.FirstOrDefault();
User user = entry.User;

此查询要求您的 UserInfoEntry 实体具有名为 User 的导航属性，该属性指向 User 实体。

This is not full-text search. It is just a normal search with the full match. You can simplify the query by reverting it:

var query = from x in objectContext.UserInfoEntries.Include("User")
            where x.FullName == "Some Name"
            orderby x.EntryTimestamp descending
            select x;

UserInfoEntry entry = query.FirstOrDefault();
User user = entry.User;

This query expects that your UserInfoEntry entity has navigation property called User pointing to User entity.

回复收藏 0 原文

~没有更多了~