How to select list of objects inside another list of objects

Question

public class Account
{
    public List<Memo1> Memos { get; set; }
}

public class Memo1
{
    public string Memo { get; set; }
    public DateTime AddDate { get; set; }
    public string UserID { get; set; }
    public List<MemoRefferances1> MemoRefferances { get; set; }
}

public class MemoRefferances1
{
    public string RefferanceName { get; set; }
    public string RefferanceValue { get; set; }
}

I want to select values of RefferanceName and RefferanceValue in MemoRefferances1 class. Please Help me.

Answer 1

You can use SelectMany to get all the MemoRefferances1 in Account.Memos

var results = someAccount.Memos.SelectMany(x => MemoRefferances);

Answer 2

You need SelectMany:

Projects each element of a sequence to an IEnumerable and flattens the resulting sequences into one sequence.

var allMemoRefferances = account.Memos.SelectMany(x = x.MemoRefferances);

Answer 3

You can use the following code,

Account dummy = GetAccouns(); //Assume GetAccounts fills account data
var result = dummy.Memos.SelectMany(x => x.MemoRefferances).ToList();