I build an object in vb.net where I store data from JSON file that I get from a RESTApi. The object is nested and looks like this:

Public Class FullData
    Public Property userID As ULong
    Public Property data As List(Of String)
End Class

Public Class GeneralInfo
    Public Property id As Integer
    Public Property name As String
    Public Property data As List(Of FullData)
End Class

Now I want to store these data into a sql database and I am not sure what technique is appropriate and easy to implement.

Could someone help me with it?

1 Answer 1


Two tables with an extra GeneralInfoId col on FullData to provide the relationship.

As a side note, you would be wise to be consistent with your Id fields. You have one long and one int.

  • Thank you very much! I will change the datatype, this is a good note. Could you give me a hint how the connection should look like? I have heard about Entity Framework. Should I use this?
    – ruedi
    Mar 8, 2018 at 13:57
  • 1
    no you should not use EF. try dotnetperls.com/sqlclient
    – Ewan
    Mar 8, 2018 at 13:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.