showing data from a json file in database using C#

Question

i have one json file and i deserialize this one in c# console entity frame work now i want to show data that was stored in the file to my table in sql server this is my code i tried to Equalize the fields in my file to my table fields what should i do next ?

 using (var context = new UNIEntities1())
            {
                var majorId = context.Major.Where(e =>e.MajorName == dto.Major).Select(e => e.IdMajor);
                return new student1()
                {
                    StudentName = dto.StudentName,
                    Age = dto.Age,
                    Address = dto.Address,
                    Major = majorId,
                    PhoneNumber = dto.PhoneNumber

                };
            }

this is the code for deserialization

 public static StudentDto Deserialize()
        {
            var Student = JsonConvert.DeserializeObject<StudentDto>(File.ReadAllText(@"unii.json"));

            return Student;
        }

this part works but i do not Know how to save this data to my data base and then show it ?

next thing you should do is add punctuation, because it is very confusing. Do you mean you want to store it in the database? where's the code for deserializing the json? and where's the code to save to the database? — Glenn van Acker
– Glenn van Acker, Commented Dec 3, 2019 at 13:03
please update your question instead of putting your code in the comments. that's not very readable. if you want to add it to the database, just use context.Add(student1) — Glenn van Acker
– Glenn van Acker, Commented Dec 3, 2019 at 13:07
I did what you said sorry i am new in Programming and i just open my account that is why i did not know how to answer your question.context.add doesn't work here i used ado.net to bring my table from sql server. — nazanin77
– nazanin77, Commented Dec 3, 2019 at 13:10
I understand, but to prevent your question from being downvoted or removed, you need to be very clear, and add all relevant code. If you have a student context defined, you can simply add to the context, and then call savechanges on that context. that should do it. — Glenn van Acker
– Glenn van Acker, Commented Dec 3, 2019 at 13:13

rjs123431 · Accepted Answer · 2019-12-03 13:17:39Z

1

You can do something like this:

// get the deserialize object
var dto = Deserialize(); 

// create a new instance of Student from the dto
var newStudent = new Student
{
    StudentName = dto.StudentName,
    Age = dto.Age,
    Address = dto.Address,
    Major = dto.Major,
    PhoneNumber = dto.PhoneNumber
}; 

// save it to the database
using (var context = new UNIEntities1())
{
    context.Student.Add(newStudent);
    context.AcceptChanges(); // or SaveChanges()
}

answered Dec 3, 2019 at 13:17

rjs123431

6884 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

showing data from a json file in database using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related