Store a typical xml file into database

Apr 23 2012 5:37 AM

XML file is Like below.

<?xml version="1.0" ?>
<!DOCTYPE PubmedArticleSet (View Source for full doctype...)>
- <PubmedArticleSet>
- <PubmedArticle>
- <MedlineCitation Owner="NLM" Status="In-Data-Review">
<PMID Version="1">22500280</PMID>
- <DateCreated>
<Year>2012</Year>
<Month>04</Month>
<Day>13</Day>
</DateCreated>
- <Article PubModel="Print-Electronic">
- <Journal>
<ISSN IssnType="Electronic">2093-6516</ISSN>
- <JournalIssue CitedMedium="Internet">
<Volume>45</Volume>
<Issue>2</Issue>
- <PubDate>
<Year>2012</Year>
<Month>Apr</Month>
</PubDate>
</JournalIssue>
<Title>The Korean journal of thoracic and cardiovascular surgery</Title>
<ISOAbbreviation>Korean J Thorac Cardiovasc Surg</ISOAbbreviation>
</Journal>
<ArticleTitle>Analysis.</ArticleTitle>
- <Pagination>
<MedlinePgn>101-9</MedlinePgn>
</Pagination>
- <Abstract>
<AbstractText Label="BACKGROUND" NlmCategory="BACKGROUND">small cell lung cancer.</AbstractText>
<AbstractText Label="MATERIALS AND METHODS" NlmCategory="METHODS"> molecular markers were selected.</AbstractText>
<AbstractText Label="RESULTS" NlmCategory="RESULTS"> recurrence.</AbstractText>
<AbstractText Label="CONCLUSION" NlmCategory="CONCLUSIONS"> disease-free survival.</AbstractText>
</Abstract>
<Affiliation>Korea.</Affiliation>
- <AuthorList CompleteYN="Y" Type="authors">
- <Author ValidYN="Y">
<LastName>Cho</LastName>
<ForeName>Sukki</ForeName>
<Initials>S</Initials>
</Author>
- <Author ValidYN="Y">
<LastName>Park</LastName>
<ForeName>Tae In</ForeName>
<Initials>TI</Initials>
</Author>
- <Author ValidYN="Y">
<LastName>Lee</LastName>
<ForeName>Eung-Bae</ForeName>
<Initials>EB</Initials>
</Author>
- <Author ValidYN="Y">
<LastName>Son</LastName>
<ForeName>Shin-Ah</ForeName>
<Initials>SA</Initials>
</Author>
</AuthorList>
<Language>eng</Language>
- <PublicationTypeList>
<PublicationType>Journal Article</PublicationType>
</PublicationTypeList>
- <ArticleDate DateType="Electronic">
<Year>2012</Year>
<Month>04</Month>
<Day>03</Day>
</ArticleDate>
</Article>
- <MedlineJournalInfo>
<Country>Korea (South)</Country>
<MedlineTA>Korean J Thorac Cardiovasc Surg</MedlineTA>
<NlmUniqueID>101563922</NlmUniqueID>
<ISSNLinking>2233-601X</ISSNLinking>
</MedlineJournalInfo>
</MedlineCitation>
- <PubmedData>
- <History>
- <PubMedPubDate PubStatus="received">
<Year>2011</Year>
<Month>9</Month>
<Day>09</Day>
</PubMedPubDate>
- <PubMedPubDate PubStatus="revised">
<Year>2011</Year>
<Month>9</Month>
<Day>28</Day>
</PubMedPubDate>
- <PubMedPubDate PubStatus="accepted">
<Year>2011</Year>
<Month>10</Month>
<Day>16</Day>
</PubMedPubDate>
- <PubMedPubDate PubStatus="epublish">
<Year>2012</Year>
<Month>4</Month>
<Day>03</Day>
</PubMedPubDate>
- <PubMedPubDate PubStatus="entrez">
<Year>2012</Year>
<Month>4</Month>
<Day>14</Day>
<Hour>6</Hour>
<Minute>0</Minute>
</PubMedPubDate>
- <PubMedPubDate PubStatus="pubmed">
<Year>2012</Year>
<Month>4</Month>
<Day>14</Day>
<Hour>6</Hour>
<Minute>0</Minute>
</PubMedPubDate>
- <PubMedPubDate PubStatus="medline">
<Year>2012</Year>
<Month>4</Month>
<Day>14</Day>
<Hour>6</Hour>
<Minute>0</Minute>
</PubMedPubDate>
</History>
<PublicationStatus>ppublish</PublicationStatus>
- <ArticleIdList>
<ArticleId IdType="doi">10.5090/kjtcs.2012.45.2.101</ArticleId>
<ArticleId IdType="pubmed">22500280</ArticleId>
</ArticleIdList>
</PubmedData>
</PubmedArticle>

<PubmedArticle>
    <MedlineCitation Owner="NLM" Status="In-Data-Review">
        <PMID Version="1">22518365</PMID>
        <DateCreated>
            <Year>2012</Year>
            <Month>04</Month>
            <Day>20</Day>
        </DateCreated>
        <Article PubModel="Print">
            <Journal>
                <ISSN IssnType="Print">1203-6765</ISSN>
                <JournalIssue CitedMedium="Print">
                    <Volume>17</Volume>
                    <Issue>1</Issue>
                    <PubDate>
                        <MedlineDate>2012 Jan-Feb</MedlineDate>
                    </PubDate>
                </JournalIssue>
                <Title>Pain research & management : the journal of the Canadian Pain Society = journal de la société canadienne pour le traitement de la douleur</Title>
                <ISOAbbreviation>Pain Res Manag</ISOAbbreviation>
            </Journal>
            <ArticleTitle>The hot foot syndrome: Evans' sign and the old way.</ArticleTitle>
            <Pagination>
                <MedlinePgn>31-4</MedlinePgn>
            </Pagination>
            <Abstract>
                <AbstractText Label="BACKGROUND" NlmCategory="BACKGROUND">escribed.</AbstractText>
                <AbstractText Label="OBJECTIVE" NlmCategory="OBJECTIVE">examination.</AbstractText>
                <AbstractText Label="METHODS" NlmCategory="METHODS"> mortality.</AbstractText>
                <AbstractText Label="RESULTS" NlmCategory="RESULTS">group.</AbstractText>
                <AbstractText Label="DISCUSSION" NlmCategory="CONCLUSIONS">carried out.</AbstractText>
                <AbstractText Label="CONCLUSION" NlmCategory="CONCLUSIONS">successful treatment.</AbstractText>
            </Abstract>
            <AuthorList CompleteYN="Y">
                <Author ValidYN="Y">
                    <LastName>Evans</LastName>
                    <ForeName>R J</ForeName>
                    <Initials>RJ</Initials>
                </Author>
                <Author ValidYN="Y">
                    <LastName>Watson</LastName>
                    <ForeName>C Peter N</ForeName>
                    <Initials>CP</Initials>
                </Author>
            </AuthorList>
            <Language>eng</Language>
            <PublicationTypeList>
                <PublicationType>Journal Article</PublicationType>
            </PublicationTypeList>
        </Article>
        <MedlineJournalInfo>
            <Country>Canada</Country>
            <MedlineTA>Pain Res Manag</MedlineTA>
            <NlmUniqueID>9612504</NlmUniqueID>
            <ISSNLinking>1203-6765</ISSNLinking>
        </MedlineJournalInfo>
        <CitationSubset>IM</CitationSubset>
    </MedlineCitation>
    <PubmedData>
        <History>
            <PubMedPubDate PubStatus="entrez">
                <Year>2012</Year>
                <Month>4</Month>
                <Day>21</Day>
                <Hour>6</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
            <PubMedPubDate PubStatus="pubmed">
                <Year>2012</Year>
                <Month>4</Month>
                <Day>21</Day>
                <Hour>6</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
            <PubMedPubDate PubStatus="medline">
                <Year>2012</Year>
                <Month>4</Month>
                <Day>21</Day>
                <Hour>6</Hour>
                <Minute>0</Minute>
            </PubMedPubDate>
        </History>
        <PublicationStatus>ppublish</PublicationStatus>
        <ArticleIdList>
            <ArticleId IdType="pubmed">22518365</ArticleId>
        </ArticleIdList>
    </PubmedData>
</PubmedArticle>

</PubmedArticleSet>

Answers (3)

System.String and System.String Builder Classes

CODE Page Approach