whats a good way to save a table of data to a file?
i've got a school project that im working on, i've got almost everything figured out but i cant figure out how to save the data to a file. i've tried using SQL but that seems like a massive hassle to get working, considering how small the project is
7 Replies
EFCore + sqlite is pretty easy to set up, i'd recommend that approach over something janky
however you could also write it as json or yaml to a file if you want to be lazy
i have been using sqlite. i haven't heard of EFCore though. i also have no idea where to even get started with json or yaml :woe:
i have an sqlite database all set-up and ready. i haven't had much luck with incorporating it into my code though. its getting pretty late now though, so i'll try out EFCore tomorrow
it depends what the end goal is, is something simple like CSV enough?
https://joshclose.github.io/CsvHelper/
there was a bit more to it but this is the important bit.
this might work. looks a lot more like what im used to using in unity (im using a winform for the first time for this project though)
Yeah CSV is really a convenient option if all you need to do is to store data to a file. But later on you might want to figure out EF with DB Engines as well. For now CSV can do the job tbf
if all you need to do is store flat/tabular data and not have to search through a lot of it CSV is plenty
databases are better when you have a lot of data or more complex structures