This is a Visual Studio extension to generate an entity relation schema for Microsoft Dynamics 365 Finance and Operations (D365FO) using Database Markup Language (DBML)
The extension allows you to modify the generated schema by
- Adding / Removing individual tables
- Adding all tables that have an inbound relation to the selected table
- Adding all tables that have an outbound relation from the selected table
- Adding all related tables for all tables in the list
- Ignoring staging tables
- Ignoring self references
- Reducing the complexity of the schema by only including key fields
See this blog for further details and example usage.
You can use a tool such as dbdiagram.io to render the resulting DBML.
The extension is accessible from the Generate entity relation schema menu from the Dynamics 365 Addins menu or from the table designer.
Download the Waywo.DbSchema.Addin.dll from Releases. Unblock the .dll once downloaded (right click and view properties in file explorer.)
If you are installing this AddIn to Visual Studio within a Cloud Hosted Development Environment, you need to update the DynamicsDevConfig.xml file in your Documents\Visual Studio Dynamics 365 folder like this:
<?xml version="1.0" encoding="utf-8"?>
<DynamicsDevConfig xmlns:i="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://schemas.microsoft.com/dynamics/2012/03/development/configuration">
<AddInPaths xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d2p1:string>C:\D365CustomAddins</d2p1:string>
</AddInPaths>
</DynamicsDevConfig> You can then copy the Waywo.DBSchema.AddIn.dll file to the folder specified above (create the folder or change the path as necessary) and then restart Visual Studio.
If you are installing this AddIn to Visual Studio under the Unified Developer experience (i.e. you have installed Visual Studio locally) then you will need to copy the Waywo.DBSchema.AddIn.dll file directly to the D365FO AddIn folder which will be somewhere like the following depending on the edition of Visual Studio you have installed:
C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\Extensions\ej3ajitu.lxk\AddinExtensions
The referenced libraries will be in a folder similar to the following, depending on the platform version:
C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\Extensions\XXXXXXXX.YYY\
It's important to build with the libraries included with Visual Studio rather than the libraries in the AOS folder.
It seems safe to ignore the following error message:
Error NU1101 Unable to find package Microsoft.Dynamics.AX.Metadata.Core. No packages exist with this id in source(s): Microsoft Visual Studio Offline Packages.
