I am in the process of developing a dungeons and dragons campaign management app. I ran a campaign on roll 20 from 1 – 20, but I felt like the site left a lot to be desired. I’m going to build it using Angular as the front end and C# on the back. I’m going to use an azure sql server to host and manage the database with entity framework. I want to be able to host a session, manage a fight, and manage the story. I want a DM to be able to host a session and players connect to it and get updates in realtime. I want to be able to manage different campaigns and the content within them.
As it stands now, I have finally built up the basic CRUD functionality and User auth. I can register an account, create a campaign, add some chapters and scenes to those chapters and that’s pretty much it. Not too fancy, I know, but it’s a decent place to start.
I am loving that I started with Entity Framework (EF) early in this project. I had originally started crafting the SQL tables by hand, then I found out about EF and started using migrations instead. Coincidentally, it was mentioned where I work and I was introduced to EF Core Power Tools, which I am looking forward to getting to work with. The visualizer for the database is pretty neat, and man does it feel good to be able to make quick changes such an many-to-one relationships in code and have EF handle all the SQL commands.
There’s still a lot of work to be done, but hopefully I will get the Codex (container for campaign details) fleshed out by the end of the weekend, and can then focus on actually using that data to build out the session creation service. I will need to continue research into handy tools DMs need as well.