IQueryable Count method takes longer to execute.

For those new to Entity Framework and facing the performance issues, you are in the right place.

In my case, i have a database with around 300 tables and growing. This results in the entity framework taking a lot of time(around 2-3 mins) to execute the first query over the EF. The reason for this is the generation of views by the EF when executing the queries for the first time after rebuilding the code.

There are couple of solutions to overcome those.
- Pre-generation of views during the code build process [Check the link]
- Lazy loading of EF [Check the link]
- Other performance points to look at [Check the link]

Pre-generation of views helps the most as it clears the major impact on the performance.

Hope this helps!