Well you switch to a different linq query as your heuristic changes. This isn't a linq vs SQL debate. I'm pointing out that linq allows explicit ordering, and

Well you switch to a different linq query as your heuristic changes. This isn't a linq vs SQL debate. I'm pointing out that linq allows explicit ordering, and if you know the shape of your data, you can account for changes in it. As with most coding, right tool for the job, YMMV for SQL or linq.