11,578 questions
Try using the following project by cloning, run the script, build/run.
NuGet Package list
Connection is in appsettings.json
Visual Studio 2019 Version 16.11.0 Winforms Issue with Microsoft.EntityFrameworkCore.SqlServer Version 5.0.9
![](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(160, 49%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
john zyd
421
Reputation points
Hello:
Today, in the morning, I found Visual Studio 2019 has a new version, so I installed the new version: 16.11.0, and I also found there were quite a number of Windows updates, I also installed all the updates, and did a reboot, then I shutdown my PC to take a rest.
In the afternoon, I have to create one WinForms App (C#) project, and I have to use nuget package of EntityFrameworkCore, I had used the nuget until version 5.0.8, the package worked well.
Today, I found there are new version for this EntityFrameworkCore, the new version is: 5.0.9.
So, I want to use the latest version of such package, but I can’t install it in a WinForms App project, from my testing, this version of package can be installed on C# Console Project, either AnyCPU or x64.
But for WinForms App project, when I installed this version of nuget package, the installation stops at this point:
Successfully installed 'Microsoft.IdentityModel.Tokens 5.6.0' to InstallEFCore509Form,
and Visual Studio 2019 UI has been freezing for a long time, I wait for more than 15 minutes, it can’t finish the installation.
There are still 76 packages to be installed, according to the packages installed from C# console project.
I think there must be some issue with the Winforms project template for version 16.11.0.
Please check and find a fix, as I can’t create new Winforms project any more using Visual Studio version 16.11.0.
My OS is Windows 10 Version 21H1.
Thanks,
See the attached picture for details.
Developer technologies | C#
{count} vote
-
![](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(115.19999999999999, 4%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Timon Yang-MSFT 9,606 Reputation points2021-08-12T03:12:59.247+00:00 @john zyd
I updated Visual Studio to Version 16.11.0 and then tested it, but I couldn't reproduce the problem. Both 5.0.8 and 5.0.9 were installed normally.
My operating system is Windows 10 20H2, I am not sure if this is the cause of the problem, can you find a machine with other operating system versions for testing? -
john zyd 421 Reputation points
2021-08-13T16:53:04.497+00:00 Hello:
As I have only one PC now, so I can't change OS or do other testing.
But the issue was even worse, it seems in VS 2019 version 16.11.0 for WinForms project, trying to install many other nuget packages can freeze the IDE from the GUI interface.
If using PM command line, it seems to be better.
Any way, for older version, like 16.10.1(2, 3, 4). I didn't have any issue to install any nuget packages. Maybe too many new features cause the problem.
If there are not many complains, this only means not many people are using the combinations now: VS 2019 16.11.0 with WinForms with SQL Server 5.0.9.
Currently, I may clone some old solution, and change some code to make a new solution, but I wish next version 16.11.1 could be a good soultion.
By the way, my Windows 10 Version is: 21H1 (OS Build 19043.1165).
Maybe you can try this version of Windows 10?
Thanks, -
john zyd 421 Reputation points
2021-08-13T21:57:13.383+00:00 Hello:
I have tried to repair Visual Studio 2019 twice, but after reboot, I saw some errors:
Package 'Microsoft.Windows.UniversalCRT.HeadersLibsSources.Msi,version=10.0.26624.1' failed to repair.But still I can't install SQL Server nuget package in WinForms project.
By the way, can I rollback to previous Visual Studio 2019 version, like 16.10.4?
I can't find any instructions on how to do this.
Please advise! -
Timon Yang-MSFT 9,606 Reputation points
2021-08-16T06:20:09.94+00:00 @john zyd
If you want to roll back visual studio to the previous version, you can refer to this document: -
john zyd 421 Reputation points
2021-08-16T10:26:40.67+00:00 Hello:
I have other findings: I installed Visual Studio 2022 Preview 3, and I can create WinForm App project, install SQL server nuget packages.
The other versions of SQL Server nuget packages worked well.
But for 5.0.9 version, VS2022 Preview 3 also stuck.
PM> Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 5.0.9
Therefore, I think, this version of SqlServer caused the headache.
You can try to use VS2022 Preview 3 to see if you can re-produce the issue.
Thanks, -
Timon Yang-MSFT 9,606 Reputation points
2021-08-17T08:24:40.627+00:00 @john zyd
I installed the latest version of Visual Studio 2022 Preview, but unfortunately, this package can still be installed normally.
I suggest that you can submit your issue in its GitHub repository and ask them to check.
You can continue to use 5.0.8 in the current project. Compared with it, 5.0.9 has basically no functional additions and bug fixes.
EF Core 5.0.9
Sign in to comment
1 answer
Sort by: Most helpful
-
Karen Payne MVP 35,586 Reputation points Volunteer Moderator2021-08-11T14:29:36.513+00:00 -
john zyd 421 Reputation points
2021-08-11T16:09:37.083+00:00 Hello:
I tried to follow your instruction, but I can only git clone this repo: https://github.com/karenpayneoregon/windows-forms-csharp.git
However, after I cloned it, I found there are many project folders, but I can’t find the project “PictureBoxSqlServer_efcore”, the one which uses EF Core 5.0.9.
But anyway, either this works or not, it is not a standard way to develop any C# WinForms App project, you have to ask the related department to fix the issue ASAP.
Thanks, -
Karen Payne MVP 35,586 Reputation points Volunteer Moderator
2021-08-11T17:08:08.663+00:00 Sorry, I forgot the project is in a different branch
https://github.com/karenpayneoregon/windows-forms-csharp/tree/Version1
Sign in to comment -