'SSMS Tables (expanding...) when trying to refresh

I have sql server management studio (SSMS) v18.9.1 and visual studio 2022 v17.1.1.

I'm using EF Migrations (dotnet 6) and after making changes to the pocos, I run add-migration followed by update-database from the package manager console window in visual studio.

If I try to refresh SSMS by right-clicking\Tables\Refresh I'm presented with SSMS Tables (expanding...) message. The table do eventually appear but this can take up to 10 minutes.

My colleague is experiencing the same behaviour on his laptop.

Any ideas how to fix?

sql-serverentity-framework-coressmsvisual-studio-2022


Solution 1:[1]

if you are accessing your local database it will be fast. if you accessing azure or cloud database it will take time based on load. it will not occur often.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 mugeshmuthukumaran

Related Questions