BindingList Filter on Linq to SQL bindingsource

After searching I found that it is not possible to filter on a basic BindingList, for doing so some alternative exists, like implementing an IEnumerable or using BindingListView or similar...

After implementing the BindingList in the project, the next code can be used inside Button click event:

            var qry = (from p in dc.Products
                       select p).ToList();
            BindingList list = new BindingList(qry);
            IEnumerable sel = list.Where(m => m.ProductName.Contains("Ch") == true);
            BindingSource1.DataSource = sel;