Hi....what Is best pratictice to filter list

There are two ways.

1. Filtering on IEnumerable 

 here the filtering happens on memory, which means all data loads to the memory, and then filtering takes place when you use Where() extension method.

2. Filtering on IQueryable

here filtering happens on the SQL Server and filtered data is sent to the client/server(MVC/API etc)