How much Entity Framework is good for database that contains tables with large records ?

Question

Hi guys,

I am working with VS 2010, Entity framework, SQl-Server 2005, ASP.Net web forms. Currently, I am working on the Data access layer library which soon will be a web service, using Entity Framework collaboration with different design patterns like repository pattern and some best practices that posts in different blogs. I am also test each repository using the Unit testing project. Thumbs up! Working fine.

The thing I am worried about is, how much is good for retrieving data from a table that can contain 80-100k records ?

Thanks

Answer 1

I go with @SteveCav and @Craig Stuntz comment. I just tried with a table that has more than hundredth of thousands records. It just works fine.