如何翻译与查询语法不止一个`from`到方法的语法LINQ表达？ [重复](How do I t

这个问题已经在这里有一个答案：

• 嵌套“从” LINQ查询表达了扩展方法 3个回答

荫使用实体框架。 我怎么会写出下面的LINQ代码在LAMBDA C＃？

var users = (from u in context.Users.ToList()
                         from e in u.Events
                         where e.EventName == eventName //Name of the Event, the user is related to
                         select u.FirstName + u.LastName).ToList();

可通过LAMBDA在这种情况下没有得到。

Answer 1:

“方法链”（这就是它叫什么）等效如下：

context.Users.SelectMany(u => u.Events
                               .Where(e => e.EventName == eventName)
                               .Select(e => u.FirstName + u.LastName))
             .ToList();

请注意，我省略了调用ToList()上context.Users ，因为它似乎没有必要。

Answer 2:

context.Users.SelectMany(u => u.Events.Where(e => e.EventName == eventName).
                                       Select(e => u.FirstName + u.LastName)).
              ToList();

Answer 3:

var users = context.Users
            .Where(u => u.Events.Any(q => q.EventName == eventName))
            .Select(m => m.FirstName + m.LastName).ToList();

更新，增加测试相关的类;

public class User
{
    public List<Event> Events { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
}

public class Event
{
    public string EventName { get; set; }
}

和代码;

string eventName = "a";

List<User> t = new List<User>();

Event event1 = new Event() { EventName = "a" };
Event event2 = new Event() { EventName = "b" };
Event event3 = new Event() { EventName = "c" };

User user1 = new User() { FirstName = "x", LastName = "y" };
User user2 = new User() { FirstName = "x1", LastName = "y1" };
User user3 = new User() { FirstName = "x2", LastName = "y2" };

user1.Events = new List<Event>();
user2.Events = new List<Event>();
user3.Events = new List<Event>();

user1.Events.Add(event1);
user1.Events.Add(event2);

user2.Events.Add(event2);
user2.Events.Add(event3);

user3.Events.Add(event1);
user3.Events.Add(event3);

t.Add(user1);
t.Add(user2);
t.Add(user3);

var bb = t.Where(u => u.Events.Any(q => q.EventName == eventName)).Select(m => m.FirstName + m.LastName).ToList();

文章来源: How do I translate a LINQ expression with more than one `from` from query syntax to method syntax? [duplicate]