Apologies if this question is too vague, please let me know if further clarification is needed.
I commonly encounter situations where I need to take some new JSON structure I haven't encountered before (which I did not create), deserialize it into a dotnet script, and then work with the data for a week or two. Since it is cumbersome to have to keep writing out json every time I run the program, and deserializing JSON can get very slow depending on size (on a few instances, I've had ~10GB json files to work with).
At this point, the initial deserialization has gotten easier, thanks to IDEs having the option to paste JSON as classes (still requires some light fixing afterwards, but it's manageable), but I've still yet to find a good ORM/database option for my needs. In particular, no built-in handling (or limited built-in handling) for collections has been the biggest problem.
Almost every data structure I work with involves having a class that contains arrays, and/or a dictionary, often with the array or dictionary value being another class. Outside of that, though, all the types within each class are generally all primitive types and strings.
I used LiteDB for a while, but that handles any sort of nesting by just storing the entire collection as an entire bson. For one, this has led to situations where LiteDB is extremely slow. This also results in situations where it's not possible to store the structure as-is, because the object is larger than LiteDB allows size-wise for bson documents.
After that, out of a few options I tried, the most noteworthy were SQLite mapping packages, but those didn't work very well, and were often out of date.
Finally, recently I've been trying to use EFCore with an SQLite database provider. Unfortunately, EFCore currently has no support for dictionaries, and the only workaround that's even somewhat manageable is to create a class with the key and value types i want, and then change each dictionary to be a list of that class. EFCore also requires me to pull my database using a .Include() for every single nested property, which can get cumbersome if I have a lot of collections or nesting.
Tl;dr all I really want is something I can store the classes/objects I parse from JSON into a local database file, that handles collections like arrays and dictionaries. Are there any options for this at the current moment? Included a few sample classes in the comments, if it helps.
Edit: It seems that what I'm looking for doesn't exist, since the use case where it's not worth making a proper database schema is fairly limited. That's more or less what I expected, I just wanted to make this post to make sure. Thanks to everyone for the replies!