Wednesday, March 8, 2017

Buggish: Visual Studio 2017 - The designer encountered an error while loading the table definition

The designer encountered an error while loading the table definition

Fix

Restarting computer


Failed Attempts


  • Tried reconnecting to Azure db
  • Tried restarting Visual Studio 2017
  • Tried using Visual Studio 2015


Other Odd Behaviors

This was the first time using Visual Studio 2017 (just installed).
An empty web project created.
Connected to Azure db previously created couple years ago and has been in use.
"View Designer" was working initially.
Right before breaking, I just created a new column and new unique index to 3 tables.
Initially unable to "View Designer" on those tables, but able to on the other tables.
After several attempts, unable to "View Designer" on all tables with VS2017 and 2015.
Disconnected and reconnected with no success.
Restarting Visual Studio with no success.
Rebooting my system (running Visual Studio) appears to have fixed the problem.

My guess is some connection was held up... but doesn't make a lot of sense restarting application would fix that problem.