如何使用 C# 在 SQL Server 2008 R2 中拆分和存储 XML

<?xml version="1.0" encoding="UTF-8"?>
<searchResult>
    <pagination>
        <itemsPerPage>{Number of Inventories per Page}</itemsPerPage>
        <numberOfItems>{Number of Inventories}</numberOfItems>
    </pagination>
    <itemList>
        <item>
            {Requested Salesforce fields e.g:}
            <Id>{Salesforce Id}</Id>
            <Name>{Name}</Name>
            <pb__IsForSale__c>{e.g.}false</pb__IsForSale__c>
            <pb__IsForLease__c>{e.g.}true</pb__IsForLease__c>
            <pb__ItemDescription__c>{Item Description}</pb__ItemDescription__c>
            <pb__PurchaseListPrice__c>{Item List Price e.g.:}2000000.00</pb__PurchaseListPrice__c>
            <CurrencyIsoCode>{Currency Iso Code e.g:}EUR</CurrencyIsoCode>
            <pb__UnitBedrooms__c>{Number of Bedrooms}</pb__UnitBedrooms__c>
            <asset>
                <Id>{internal Propertybase InventoryAsset Id}</Id>
                <category>{Images, Videos or Documents}</category>
                <isExternalLink>false</isExternalLink>
                <title>{title}</title>
                <filename>{original name of the uploaded file}</filename>
                <url>{full url to image/video/document}</url>
                <thumbnailUrl>{full url to thumbnail image}</thumbnailUrl>
                <midresUrl>{full url to thumbnail image}</midresUrl>
                <tags>{comma separated tags}</tags>
                <mimeType>{e.g. image/jpeg}</mimeType>
            </asset>
            <asset>
                <Id>{internal Propertybase InventoryAsset Id}</Id>
                <category>{Images, Videos or Documents}</category>
                <isExternalLink>true</isExternalLink>
                <title>{title}</title>
                <url>{full url to image/video/document}</url>
                <tags>{comma separated tags}</tags>
            </asset>
            <asset>
               {...}
            </asset>
            {more assets ...}
        </item>
        <item>
            {...}
        </item>
        {more items ...}
    </itemList>
</searchResult>

好吧，我有上面的XML，我需要从中将项目标签及其子节点作为属性存储在数据库中，并且必须将资产标签及其子节点存储在另一个表中，并将item id作为项目表中的外键，我该怎么做做了很多谷歌工作，但无法找到让它工作的方法