XML-mapping to SQL-server

Question

I want to map a xml file to a SQL Server table.

This is what I've done so far:

XmlTextReader reader = new XmlTextReader("navetout.xml");
XmlNodeType type;

while (reader.Read())
{
    type = reader.NodeType;

    if(type == XmlNodeType.Element)
    {
    }
}

//using Entity framework
static void writeToDatabase()
{
    BumsEntities _bums = new BumsEntities();

    _bums.Seamen.Add(new Seamen
                     {
                        PersonalIdentityNumber = "",
                        ReferedCivicRegistrationNumber = "",
                        UnregistrationReason = "",
                        UnregistrationDate = "",
                        MessageComputerComputer = "",
                        GivenNameNumber = "",
                        FirstName = "",
                        MiddleName = "",
                        LastName = "",
                        NotifyName = "",
                        NationalRegistrationDate = "",
                        NationalRegistrationCountyCode = "",
                        NationalRegistrationMunicipalityCode = "",
                        NationalRegistrationCoAddress = "",
                        NationalRegistrationDistributionAddress1 = "",
                        NationalRegistrationDistributionAddress2 = "",
                        NationalRegistrationPostCode = "",
                        NationalRegistrationCity = "",
                        NationalRegistrationNotifyDistributionAddress = "",
                        NationalRegistrationNotifyPostCode = "",
                        NationalRegistrationNotifyCity = "",
                        ForeignDistrubtionAddress1 = "",
                        ForeignDistrubtionAddress2 = "",
                        ForeignDistrubtionAddress3 = "",
                        ForeignDistrubtionCountry = "",
                        ForeignDate = "",
                        BirthCountyCode = "",
                        BirthParish = "",
                     });

    _bums.SaveChanges();
}

The code above is the database columns. What I want to be able to do is to load the xml file and insert the tags into the columns. The problem is that I don't know how to "translate" the xml tags to the database columns.. Can anyone help me out?

Which language are you doing this in, btw? I suppose C#? You might wanna tag with that (and entity framework). — G_H
– G_H, Commented Mar 31, 2016 at 9:26

Community · Accepted Answer · 2017-05-23 11:45:04Z

0

This is not the entire code, however should help :

XmlTextReader reader = new XmlTextReader("navetout.xml");
DataSet ds = new DataSet("XML Data");
ds.ReadXml(reader);

// Create Database Connection here

foreach(DataTable dt in ds.Tables){

//save datatable to database - You can use SqlBulkCopy

}

Saving DataTable to database

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Mar 31, 2016 at 9:40

Ravi Singh

2,08013 silver badges29 bronze badges

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

2 Comments

Simon.S Over a year ago

Thanks. What connection do you mean in "//Create connection here"?

Simon.S Over a year ago

What do you mean with saving datatable to database? I want to save XML to database. How I can translate the XML-tags to database columns?

Collectives™ on Stack Overflow

XML-mapping to SQL-server

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related