Last post Nov 30, 2015 03:59 AM by issam1975
Nov 29, 2015 02:20 AM|issam1975|LINK
i am using ef 6.13 with firebird in a asp.net and Wpf desktop applicatiion. (Database First)
it's work really good except for the "first time query execution" slow problem
all my queries are slow first time but super fast after that .
i have read many articles on this like pregenerating views and compiled queries , some are outdated and some are for code first, and all this give me a little confusion on the subject .
so i am looking for a practical guidelines to get maximum performance with EF apps even in startup.
thanks and good day .
Nov 30, 2015 01:54 AM|Zhi Lv - MSFT|LINK
As far as I know, The Database First (EDMX) approach is being phased out. It will not be available in the next version of Entity Framework. You can use the EF power tools to reverse engineer a code first model from the database, or manually code the model.
If you want to improve the Query Performance, I suggest you could try to use Views. Here are some relevant articles, please refer to them:
Nov 30, 2015 03:59 AM|issam1975|LINK
thanks for sharing