0

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?

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
2
  • 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? Commented Mar 8, 2018 at 13:57
  • 1
    no you should not use EF. try dotnetperls.com/sqlclient Commented 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.