I have a web application with:
- 1 Terabyte DB
- 200+ tables
- At least 50 tables with 1+ million records each
- 10+ developers
- 1000s of concurrent users
This project is currently using Ad-Hoc Sql, which is generated by custom ORM solution. Instead of supporting custom ORM (which is missing a lot of advanced features), I am thinking to switch to Entity Framework.
I used EF 4.1 (Code-First) on a smaller project and it worked pretty well, but is it scalable for a much larger project above?