> > The 'ToList()' workaround is silly really, you don't want to fetch > > all data to do an aggregate in-memory
> eh?!??!?? > NH ha to workaround RDBMS issue. > NH have to work around to commercial companies visual components. I think Frans' point is that even though the Count() seems redundant after a Take(), it's still a completely valid LINQ query. Certainly, when one is directly writing the LINQ query, it's not a problem to simply add a ToList(), but when working with third-party components like the original poster is, it's not always reasonable to expect them to be able to modify the query. Having said that, I think everyone is aware how complex writing a LINQ provider is :) -- Roy
