CODEWITHSUNDEEP
c#linqobservablecollection
B.Balamanigandan
B.Balamanigandan

Reputation: 4875

How to Filter Inner Collection using LINQ C#

I need to filter the Inner Collection of a Collection using LINQ to fetch the records.

public class MobileModel : Notify
{
    private string _brand = string.Empty;
    private ObservableCollection<MobileModelInfo> _model = new ObservableCollection<MobileModelInfo>();
    private string _os = string.Empty;

    public string Brand
    {
        get { return _brand; }
        set { _brand = value; OnPropertyChanged(); }
    }
    public ObservableCollection<MobileModelInfo> Model
    {
        get { return _model; }
        set { _model = value; OnPropertyChanged(); }
    }

    public string OS
    {
        get { return _os; }
        set { _os = value; OnPropertyChanged(); }
    }
}

public class MobileModelInfo
{
    public string Name { get; set; }
    public string Catagory { get; set; }
    public string Year { get; set; }
}


public void GetMobile()
    {
        List<MobileModel> mList = new List<MobileModel>();
        List<MobileModelInfo> modList = new List<MobileModelInfo>();
        MobileModel mob = new MobileModel();

        modList.Clear();
        mob.Brand = "Apple";
        modList.Add(new MobileModelInfo { Name = "iPhone 4", Catagory = "Smart Phone", Year = "2011" });
        modList.Add(new MobileModelInfo { Name = "iPhone 5", Catagory = "Smart Phone", Year = "2013" });
        modList.Add(new MobileModelInfo { Name = "iPhone 6", Catagory = "Premium Smart Phone", Year = "2015" });
        mob.Model = new ObservableCollection<MobileModelInfo>(modList);
        mob.OS = "IOS";
        mList.Add(mob);

        mob = new MobileModel();
        modList.Clear();
        mob.Brand = "Samsung";
        modList.Add(new MobileModelInfo { Name = "S4", Catagory = "Smart Phone", Year = "2011" });
        modList.Add(new MobileModelInfo { Name = "S5", Catagory = "Smart Phone", Year = "2013" });
        modList.Add(new MobileModelInfo { Name = "S6", Catagory = "Ultra Smart Phone", Year = "2015" });
        mob.Model = new ObservableCollection<MobileModelInfo>(modList);
        mob.OS = "Android";
        mList.Add(mob);

        mob = new MobileModel();
        modList.Clear();
        mob.Brand = "MicroSoft";
        modList.Add(new MobileModelInfo { Name = "Lumina 9900", Catagory = "Phone", Year = "2011" });
        modList.Add(new MobileModelInfo { Name = "Opera X220", Catagory = "Smart Phone", Year = "2013" });
        mob.Model = new ObservableCollection<MobileModelInfo>(modList);
        mob.OS = "Windows";
        mList.Add(mob);

        mob = new MobileModel();
        modList.Clear();
        mob.Brand = "Sony Ericssion";
        modList.Add(new MobileModelInfo { Name = "S4", Catagory = "Smart Phone", Year = "2011" });
        modList.Add(new MobileModelInfo { Name = "S5", Catagory = "Smart Phone", Year = "2013" });
        modList.Add(new MobileModelInfo { Name = "S6", Catagory = "Ultra Smart Phone", Year = "2015" });
        mob.Model = new ObservableCollection<MobileModelInfo>(modList);
        mob.OS = "Android";
        mList.Add(mob);

        MobileList = new ObservableCollection<MobileModel>(mList);
    }

The ObservableCollection MobileList has three properties Brand, Model and OS. The Model Property is again a ObservableCollection in that MobileModelInfo class has three properties Name, Catagory and Year.

I need the Collection it should contain the Year 2011 in the inner collection MobileModelInfo. Rest of the records should not needed.

In Samsung it should contain only

mob.Brand = "Samsung";
modList.Add(new MobileModelInfo { Name = "S4", Catagory = "Smart Phone", Year = "2011" });
mob.OS = "Android";

Actual Initial Output Screen Shot is Original List without Filter

Output Expected is After Filter

Upvotes: 3

Views: 1755

Answers (3)

Oleg Golovkov
Oleg Golovkov

Reputation: 706

var filtered = MobileList.Select(m => new MobileModel {
                Model = new ObservableCollection(m.Model.Where(model => model.Year == "2011").ToList()),
                Brand = m.Brand,
                OS = m.OS
            })

;

Upvotes: 4

Alper Tunga Arslan
Alper Tunga Arslan

Reputation: 579

I think you can use inner where conditions for this.Pls check this:

   var result = MobileList.Where(m => m.Model.Where(mdl => mdl.Year =="2011")).ToList();

Upvotes: 2

Gurgen Sargsyan
Gurgen Sargsyan

Reputation: 1087

use SelectMany() :

MobileList.SelectMany(x => x.Model).Where(m=>m.Year==2011)

Upvotes: 6

Related Questions