none
How to Design Table Schema and match json result

    Question

  • Hi 

    I have a json result like below

    [
     {
      Nid:1,
      Name:"user1",
      Info:["age":20,"address":"xxxxxx","note":"cccccc"]
     },
     {
      Nid:2,
      Name:"user2",
      Info:["age":30,"address":"yyyyyy","note":"zzzzzz"]
     }
    ]

    In SqlServer, How can I design the table schema (especially Info column), and I wish use EntityFrameworkCore to load all of data then show to client.

    please get me a sample more clearly, thanks


    Tuesday, July 03, 2018 3:10 PM

All replies