Data Storage

[pjlplourde]

What are you planning to use for data storage? SQL, SQLite, MySQL, MongoDB, CosmosDB, text files?

[kevball2]

My thought was to begin with writing out the data to a json file. I don't have much practice with working with JSON so I thought that would be a good place to start. Eventually I want to move to a web app with CosmosDB but want to get the logic sorted first.

[pjlplourde]

A JSON file can only hold one single JSON object, so not ideal, and a text file or CSV cannot easily hold JSON data. My suggestion for the start is to either use MongoDB or CosmosDB to store your JSON data. This is handled in your class library in any event, so the UI doesn't matter and you can switch to a web app later if you wish. If you want, I can go ahead and create your DataAccessLibrary and set it up to work with your choice of MongoDB or CosmosDB, so that all you'll have to do is put the connection string in your appsettings.json.

[kevball2]

CosmoDB would be my preference then. If you would like to create the DataAccessLibrary that would be great! I had seen this ComsoDB project, but might be overkill - https://github.com/IEvangelist/azure-cosmos-dotnet-repository

[pjlplourde]

Ok, I'll fork and create a DataAccessLibrary to use CosmosDB.

[pjlplourde]

Pull request created. Should all be good except for (1) you will need the connection info for your CosmosDB to be put into the appsettings.json file and (2) you may need to map the db-side models to your ui-side models.