Instead of loading a large data set in the memory all at once, you can take advantage of chunking to split the collection into chunks and then load or process these chunks as needed. To implement ...
LINQ is not just for SQL/ADO though. You can use it on containers. Even if you do use it against ADO.NET, you can do it against a ...