Entity Framework多表查询：多Where条件下如何获取Tasks.Text

Hey there! Let's walk through what's causing your code to fail and how to fix it properly. Your original query has two main issues that are preventing it from running:

1. Invalid Boolean Condition in the Second Where Clause #

Your second Where uses t.Tables.Where(a => a.Id == 1) which returns an IEnumerable, not a true/false value. LINQ's WhereAny()

.Where(user => user.Tables.Any(table => table.Id == 1))

2. Nested Select Syntax Error #

In your final Select, you wrote a.Tasks.Select(a => a.Tasks.Text) — here, the inner a refers to an individual Task object, which doesn't have a Tasks property of its own. You need to directly access the Text property of each Task:

.Tasks.Select(task => task.Text)

Corrected Queries (Based on Your Data Structure) #

Scenario 1: Tasks are a Direct Navigation Property of User #

If Tasks belongs directly to the User (User → Tasks), and you want to get all Tasks.Text for the user with Id=1 who also has a Table with Id=1:

// Get a flat list of all task texts
var taskTexts = db.Users
    .Where(user => user.Id == 1)
    .Where(user => user.Tables.Any(table => table.Id == 1))
    .SelectMany(user => user.Tasks.Select(task => task.Text));

// Or, if you want to keep tasks grouped under the user (returns IEnumerable<IEnumerable<string>>)
var userTasks = db.Users
    .Where(user => user.Id == 1)
    .Where(user => user.Tables.Any(table => table.Id == 1))
    .Select(user => user.Tasks.Select(task => task.Text));

Scenario 2: Tasks Belong to Tables (User → Tables → Tasks) #

If Tasks is a navigation property of Table instead, adjust the query to traverse the relationship correctly:

var taskTexts = db.Users
    .Where(user => user.Id == 1)
    .SelectMany(user => user.Tables
        .Where(table => table.Id == 1)
        .SelectMany(table => table.Tasks.Select(task => task.Text)));

Bonus: More Readable Alternative with FirstOrDefault #

If you know the user with Id=1 is unique, you can simplify the query to first fetch the user (with related data included) and then extract the task texts:

// Include related data to avoid lazy loading
var targetUser = db.Users
    .Include(u => u.Tables)
    .Include(u => u.Tasks) // Omit this if Tasks are under Tables
    .FirstOrDefault(u => u.Id == 1 && u.Tables.Any(t => t.Id == 1));

// Safely get task texts (handles null user case)
var taskTexts = targetUser?.Tasks.Select(t => t.Text) ?? Enumerable.Empty<string>();

内容的提问来源于stack exchange，提问作者Gracjan