You started this thread by asking about SQL Server itself (and the way it handles query plans in particular). That's what we've been talking about ever since. Not Linq.
You might want to go back and read the responses to your question again to make sure you've got your context right.
i see your point, and it was wrong of me to describe the context in that way.
on the other hand, your previous statement was qualified with "in the real world", and to some extent the "real world" includes people using linq.
having said that, i agree that the consensus - if i haven't misunderstood something else - seems to be that sql engines don't do what i expected because it's assumed that people will use compiled statements. i don't use linq myself so am having to infer a lot from the article, but at some point i plan to check django and sqlalchemy to see when they use precompiled statements and when not.
You might want to go back and read the responses to your question again to make sure you've got your context right.