Using Linq select list inside list

Question

Using LINQ how to select from a List within a List  public class Model       public string application   get  set         public List lt Users gt  users   get  set       public class Users       public string name   get  set         public string surname   get  set       List lt Model gt  list   new List lt Model gt       I need to select list where application    applicationame  and users where surname    surname  into one list

User · Answer

You have to use the SelectMany extension method or its equivalent syntax in pure LINQ    from model in list  where model application     applicationname   from user in model users  where user surname     surname   select new   user  model    ToList

User · Answer

list Where m   gt  m application     applicationName   amp  amp              m users Any u   gt  u surname   surname       if you want to filter users as TimSchmelter commented  you can use  list Where m   gt  m application     applicationName        Select m   gt  new Model               application   m application          users   m users Where u   gt  u surname   surname   ToList

User · Answer

If you want to filter the models by applicationname and the remaining models by surname   List lt Model gt  newList   list Where m   gt  m application     applicationname        Select m   gt  new Model            application   m application           users   m users Where u   gt  u surname     surname   ToList           ToList      As you can see  it needs to create new models and user-lists  hence it is not the most efficient way   If you instead don t want to filter the list of users but filter the models by users with at least one user with a given username  use Any   List lt Model gt  newList   list      Where m   gt  m application     applicationname               amp  amp   m users Any u   gt  u surname     surname         ToList

User · Answer

After my previous answer disaster  I m going to try something else   List lt Model gt  usrList      list Where n   gt  n application     applicationame   ToList     usrList ForEach n   gt  n users RemoveAll n   gt  n surname     surname

[c#] Using Linq select list inside list

Examples related to c#

Examples related to .net

Examples related to linq