If the data is stored in a database it will be faster to send the query to the database instead of getting all data and query it in memory.
A third way to do it will be linq to datasets, but i doubt any of these 3 methods differ much in performance.