ER-Model

26.06.2025

Have you ever missed being able to easily create an ER-model from a set of tables in Finance and Operations? Well, Paul Noakes, has created an extension that helps with exactly that. This extension has helped me a lot in the past, and is still proving to be helpful in many scenarios.

Simply add the tables you want to have a schema for and with a click of a button you have a file that can be opened and visualized in dbdiagram.io/d.

  1. Download Waywo.DbSchema.AddIn.dll file.
  2. Identify the AddinExtensions folder: Determine the correct location for Visual Studio extensions. For a Unified Developer experience (local Visual Studio installation), the path generally includes Common7\IDE\Extensions.
    C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\Extensions\me5uszn4.ihc\AddinExtensions
  3. Copy the DLL: Copy the Waywo.DbSchema.AddIn.dll file into the AddinExtensions folder you identified. If the specific subfolder (like me5uszn4.ihc) doesn't exist, you may need to create it.
  4. Restart Visual Studio: After copying the DLL, close and reopen Visual Studio to ensure the add-in is recognized.
  5. Test and verify: After installation, the menu "Generate entity relation schema" is available under "Dynamics 365 - Addins".

Potential configuration (1):

In some cases, you might need to edit the DynamicsDevConfig.xml file in your user documents to configure the add-in, by adding the below path, where the path points to the .

<AddInPaths xmlns:d2p1="https://schemas.microsoft.com/2003/10/Serialization/Arrays">

<d2p1:string>C:\AddInExtensions</d2p1:string>

</AddInPaths>

Potential configuration (2):

Installing the extension manually by opening options and selecting the Dynamics 365 and hitting the Install Extension button. Navigate to the Waywo.DbSchema.AddIn.dll is stored, select it and click Open.

Blog
Share