I am using EF 5.0 and Code first approach in my project.
There are 10-15 tables in my database, and I have two context classes.
Now, for slow start up I have read a lot of articles and blogs. I found that installing
EF power tool will allow me to generate views which will help in improving the slow startup issue.
Previously for first call it was taking 40 seconds (for getting around 85 rows). After creating view, this time is reduced to 30 seconds.
Which is not significant considering that currently the database does not holds large data.
Further search suggested me to install EF CodeFirst View Generation T4 Template for C# and create View by this template.
But when i try creating View by this template using the steps in
it gives me error :
Compiling transformation: 'System.Data.Entity.Design.EntityFrameworkVersions' does not contain a definition for 'Version3'
Why this happens?
Please suggest me something for improving the performance of EF 5.0 Code first.