780 questions
How many tables?
SQL Server version?
Entity Framework Core 5.0 scaffold-dbcontext hangs within Package Manager
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 72%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jim Thomas
41
Reputation points
I have created my first scaffold-dbcontext command and run it in Package Manager Console in Visual Studio 16.6.2. After 'Build succeeded.' the PM just hangs. I can do nothing except restart Visual Studio to get PM back. When I re-open the project the output files appear in the Entities folder of the project, as expected. How do I eliminate the hang?
PM> scaffold-dbcontext -provider Microsoft.EntityFrameworkCore.SqlServer -connection "Data Source=sqldevi\devi;Initial Catalog=anami;Integrated Security=true;Pooling=false;" -OutputDir Entities –Context Anami –Tables member_creditcard
Build started...
Build succeeded.
Here are the packages in the .net core 3.1 project. Note that, as a console app, Program.cs is just the original stub, there is no other code, hence the project compiles successfully!
Packages
Microsoft.CodeAnalysis (3.7.0)
Microsoft.Data.SqlCLient (2.0.1)
Microsoft.EntityFrameworkCore (5.0.2)
Microsoft.EntityFrameworkCore.SqlServer (5.0.2)
Microsoft.EntityFrameworkCore.Tools (5.0.2)
Developer technologies .NET Entity Framework Core
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Daniel Zhang-MSFT 9,651 Reputation points2021-03-18T06:36:49.163+00:00 Hi @Jim Thomas ,
First, please modify your Visiual Studio.
And in order to check if it is caused by your Scaffold-DbContext, I suggest you try anotehr command via Package Manager Console such as Get-DbContext.
Then check if there are any generated files under your outputdir, try it again with a different outputdir.
It is better to provide more information to reproduce the situation.
Please follow this document.
Best Regards,
Daniel Zhang -
Jim Thomas 41 Reputation points
2021-03-19T11:10:18.887+00:00 What do you mean by 'Modify' your Visual Studio? Do you mean Repair or Upgrade? Regardless, I uninstalled VS 16.6.2 and re-installed it - made no difference to the hanging issue.
I tried another command like get-dbcontext but that command also hangs.
You asked to check if there are generated files in the output dir. That has always been true regardless of the output dir. But note that these files do not appear (using File Explorer) when VS/PM is hung. When I close VS then the files appear in the output dir (using File Explorer). Naturally when I then restart VS the files now show up in the project. Very odd that closing down Visual Studio causes the output dir files to appear!
You asked for more information so I added the -verbose option to the command. That command is in the attached file. Note that my solution is called dbScaffoldCore and the project name is dbScaffold.
-
Jim Thomas 41 Reputation points
2021-03-19T11:17:56.697+00:00 Since my response is limited to 1000 chars here is more info.
Although the program compiles just fine there is a warning which is included below:
1>CSC : warning CS8032: An instance of analyzer Microsoft.EntityFrameworkCore.InternalUsageDiagnosticAnalyzer cannot be created from C:\Users\jimt.nuget\packages\microsoft.entityframeworkcore.analyzers\5.0.2\analyzers\dotnet\cs\Microsoft.EntityFrameworkCore.Analyzers.dll : Could not load file or assembly 'Microsoft.CodeAnalysis, Version=3.7.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
The odd thing is Microsoft.CodeAnalysis version 3.7 is indeed one of the packages I have installed and it appears in the list of installed packages. Do not know which file or assembly it could not find. Does this warning potentially have anything to do with the hang?
-
Jim Thomas 41 Reputation points
2021-03-20T23:09:35.083+00:00 I determined this warning is not relevant. I created a new project using
PM> Install-Package Microsoft.EntityFrameworkCore.Tools
and nothing more so there are no warnings. scaffold-dbcontext still hangs.
-
Jim Thomas 41 Reputation points
2021-03-21T00:59:59.283+00:00 I upgraded my Visual Studio to 16.8.4 - still experience the hang.
I tried Microsoft.EntityFrameworkCore.Tools 5.0.4 - still experience the hang.
I tried Microsoft.EntityFrameworkCore.Tools 6.0 Preview - still experience the hang.
My virus scanner is turned off so that is not preventing the file writing.
-
Daniel Zhang-MSFT 9,651 Reputation points
2021-03-22T06:35:16.14+00:00 Hi @Jim Thomas ,
Based on your description, I suggest you can start a new thread and report this issue to VS Product Team in our Developer Community with some reproduced or detailed information.
And you can get more professional answer.
Thank you for your understanding.
Best Regards,
Daniel Zhang
Sign in to comment
1 answer
Sort by: Most helpful
-
ErikEJ 341 Reputation points MVP2021-03-17T18:07:38.433+00:00 -
Jim Thomas 41 Reputation points
2021-03-17T18:30:13.3+00:00 Just one table in the command: –Tables member_creditcard and SQL Server version 14.0.
Sign in to comment -