dimanche 23 août 2015

What's the best way to put an object in a table with SQL?

I have a program in C# that produces a lot of objects that contain an array of objects. Is it possible to store "object" arrays inside rows of an SQL table?

Example:

Object1 -> string name, Object2[] o2
Object2 -> int number, string name, Object3[] o3
Object3 -> int type, string condition, bool isDone, byte position

I will probably have around 1080 instances of Object1, with ~10 instances of Object2 per Object1, and ~10 instances of Object3 per Object 2 and I need to store this somehow in a usable format.

I'm thinking SQL would be the best solution for this, but I couldn't find anything on storing more complex data like in my given example.

Aucun commentaire:

Enregistrer un commentaire