I'm using EF Code First in my new project. I'm not going to use Auto Migration feature and have not [__MigrationHistory] table in db. But with looking at Profiler, I can always see EF issues a query like this before any other query:
SELECT
[GroupBy1].[A1] AS [C1]
FROM ( SELECT
COUNT(1) AS [A1]
FROM [dbo].[__MigrationHistory] AS [Extent1]
) AS [GroupBy1]
Haw can I disable this feature?
The only way to disable this feature is not using any database initializer. Once you are using database initializer (you expect EF to create or change database) you will always have queries to this table.
To turn off database initializer use this at the bootstrap of your application:
Database.SetInitializer<YourContext>(null);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With