search

plan-your-vote / plan-your-vote-cms

1 stars 8 forks source link

DB entity relational diagrams #82

Open medhatelmasry opened 4 years ago

medhatelmasry commented 4 years ago

Generate DB entity relational diagrams dynamically [ SQL Server tool ]

ryanliang88 commented 4 years ago

Not sure if this is what you're looking for:

This may be already implemented via DgmlController - This should be documented too (see Medhat). You'll need to go to that route to generate diagrams. i.e. http://dpyvweb.azurewebsites.net/dgml

You'll need this to view it. Drag dgml into project and double-click to view image

Sample image

EF6 is now an option in .NET Core now but I'm not certain if this would be a good step to take since .NET 5 is likely going to use EF Core (only?).

joey-tang commented 4 years ago

This is another version that Victor generated with DBeaver

db

joey-tang commented 4 years ago

I've created a button that opens a '.html' page of the entity diagrams. For reference: http://blog.medhat.ca/2019/03/inspecting-your-net-classes-with-net.html Command used: 'generateomd /source=./Models /output=./wwwroot/diagram '

This issue will be set to pending by Medhat, as we want to run a script on deployment to get the most up to date diagram.