store json data in database using C# [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 8 years ago.

Improve this question

temp= {
       "Vikas": 1,
       "Pravin": 2,
       "Akshay": 5,
       "Vijay": 3,
       "Prasad": 4 
      }

This is value I am getting in temp variable I want to store this data in database with one additional column like following

name      rank   createdby
vikas      1       nitin
pravin     2       nitin
akshay     5       nitin
vijay      3       nitin
Prasad     4       nitin


Note:  name column is employee name so it is anything

I tried like getting in C#

[System.Web.Services.WebMethod]
public static string setAnswer(string jsondata)
{
    List<string[]> data = JsonConvert.DeserializeObject<List<string[]>>(jsondata);
}

Question.

1) how to get this json data in C# and add additional column

2) Is it possible to pass whole data using multiple row insert in one query instead of using loop and insert single row.

depends on the database you are using. If the db allows bulkinsert its definitly possible. to add a row to an array you have to copy the whole array. — Sebastian L
– Sebastian L, Commented Feb 6, 2017 at 11:00
yes to avoid for loop you can use table valued parameters you need to convert list to datatable check this link blog.sqlauthority.com/2008/08/31/… let me know if you require more help — Chintan Udeshi
– Chintan Udeshi, Commented Feb 6, 2017 at 11:02
I assume temp = is your way of saying that you have a variable with that content, not that this is part of the payload/string because this part is not legal json. — Lasse V. Karlsen
– Lasse V. Karlsen, Commented Feb 6, 2017 at 11:10

Lasse V. Karlsen · Accepted Answer · 2017-02-06 11:13:14Z

3

The correct way to deserialize this content:

{
    "Vikas": 1,
    "Pravin": 2,
    "Akshay": 5,
    "Vijay": 3,
    "Prasad": 4 
}

Is to deserialize it into a Dictionary<string, int>.

Here's a LINQPad example:

void Main()
{
    const string json = @"{
        ""Vikas"": 1,
        ""Pravin"": 2,
        ""Akshay"": 5,
        ""Vijay"": 3,
        ""Prasad"": 4
    }";
    Dictionary<string, int> empsAndNumbers =
        JsonConvert.DeserializeObject<Dictionary<string, int>>(json);
    empsAndNumbers.Dump();
}

which outputs:

answered Feb 6, 2017 at 11:13

Lasse V. Karlsen

394k107 gold badges651 silver badges845 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BWA · Accepted Answer · 2017-02-06 11:16:44Z

3

Edited after explantions:

You can deserialize it to dictionary in this way:

var data = JsonConvert.DeserializeObject<Dictionary<string, int>>(temp);

I this point we have dictionary with data. How to save it into DB depends how you access to db.

edited Feb 6, 2017 at 11:16

answered Feb 6, 2017 at 11:03

BWA

5,7748 gold badges39 silver badges49 bronze badges

5 Comments

User Over a year ago

thanks for reply but no..no... this is employee name so i cannot make it static it may be anything so this is not possible to make class

Lasse V. Karlsen Over a year ago

A dictionary of string to int is more appropriate, Dictionary<string, int>.

BWA Over a year ago

@Pravin you don say it, this is very imprtant thing for solution. Edit question and add this info.

BWA Over a year ago

@LasseV.Karlsen with this info you are right

User Over a year ago

okk I will add in question

Dronacharya · Accepted Answer · 2017-02-06 11:21:25Z

2

Create an Entity : MemberRank

public class MemberRank
{
    public int Id { get; set; }
    public string MemberName { get; set; }
    public int Rank{ get; set; }
    public string CreatedBy { get; set; }
}

Then in Controller,

var membersText = File.ReadAllText(Path.Combine(envContentRootPath, @"PathOfTheFile"));
var members = JsonConvert.DeserializeObject<List<MemberRank>>(membersText);
members.ForEach(cb => cb.CreatedBy = "nitin");
_dbContext.Set<MemberRank>().AddRange(members);
_dbContext.SaveChanges();

For this to work, you need to change your json file as follows:

[
  {
     "memberName" : "Vikas",
     "rank" : 1
  },
  {
     "memberName" : "Pravin",
     "rank" : 2
  },
  {
     "memberName" : "Akshay",
     "rank" : 5
  },
  {
     "memberName" : "Vijay",
     "rank" : 3
  },
  {
     "memberName" : "Prasad",
     "rank" : 4
  }
]

edited Feb 6, 2017 at 11:21

answered Feb 6, 2017 at 11:12

Dronacharya

1,29112 silver badges13 bronze badges

3 Comments

Lasse V. Karlsen Over a year ago

How do you get Json.net to deserialize the example json into your MemberRank type?

BWA Over a year ago

Where do you have in question info about EF?

Dronacharya Over a year ago

I am assuming that he is using EF, Sir.

Collectives™ on Stack Overflow

store json data in database using C# [closed]

3 Answers 3

Comments

5 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

3 Comments

Linked

Related