Feature Request: pre-generated views for EF Core 2

[gtrbarbarian]

Hi, I'm wondering if pre-generated view creation is going to be added to this tool in the future as it exists in the EF6 version of these tools? I can't find anything on the web about this topic.

Database engine: SQL Server

Visual Studio or SSMS version: (e.g. Visual Studio 2017 15.5.7)

[ErikEJ]

That feature does not exist in EF Core - are you having performance issues?

[gtrbarbarian]

Just upon first query, per usual with EF with large schemas. I guess I need to delve into the EF core source to see how it is performing initial loading. So this feature is not part of EF core due to the way initial DBContext loading is done? (i.e. initial context loading is done differently than EF6 and hence is not needed, or it just hasn't been created yet for EF Core 2). I appreciate your tutelage !

[ErikEJ]

have you tried the latest preview -I know some performance effort was done there (2.1 preview2)

[smbolt]

ErikEJ - like gtrbarbarian above, I am researching the topic of pre-generated views in EF Core. Can you address the question of whether such a mechanism exists in EF Core as it did in EF6?

[ErikEJ]

@smbolt I already did: #698 (comment) - it does not exist

[smbolt]

Thanks so much for your response. Can you tell me if there is a parallel concern with EF Core with "startup costs" that are concerning enough that a mechanism such as the EF6 pre-compiled views might be warranted?

[ErikEJ]

There are discussions here: dotnet/efcore#1906 and here: dotnet/efcore#9347