在C＃中使用XmlReader在xml段中查找值

Question

我正在使用XML阅读器来搜索我们使用的xml配置文件。我想找到某个键​​下的值，如果它们不存在，可以更改它们或添加它们。

XML示例

<DBSimulatorConfigurations> 
    <Configurations> 
    <DBSimulatorConfiguration> 
     <Key>Test1</Key> 
     <Submit>0</Submit> 
     <Amend>0</Amend> 
     <Update>0</Update> 
     <Delete>1</Delete> 
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds> 
    </DBSimulatorConfiguration> 
    <DBSimulatorConfiguration> 
     <Key>Test2</Key> 
     <Submit>0</Submit> 
     <AutoUpdate>0</AutoUpdate> 
     <Amend>0</Amend> 
     <Update>0</Update> 
     <Delete>1</Delete> 
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds> 
    </DBSimulatorConfiguration> 
    <DBSimulatorConfiguration> 
    </Configurations> 
</DBSimulatorConfigurations> 

到目前为止的代码......注释掉位不“Test1的”

XmlReader reader = XmlReader.Create("C:\\<path>\\DBConfigs.xml"); 
while(reader.Read()) 
{ 
    if (reader.ReadToDescendant("Key")) 
    { 
     reader.Read(); 
     if (reader.Value == "Test1") 
     { 
      Console.WriteLine("Found_1 {0}", reader.Value); 
      // Doesn't work :( 
      // reader.Read(); 
      //if (reader.ReadToDescendant("Submit")) { 
      // Console.WriteLine("Value for Submit is {0}", reader.Value); 
      //} 
     } 

     if (reader.Value == "Test2") 
     { 
      Console.WriteLine("Found_2 {0}", reader.Value); 
     } 

     reader.Read(); //this moves reader to next node which is text 
     if (reader.ReadToDescendant("Full.2")) { 
      Console.WriteLine("Found {0}", reader.Value); 
     } 

    } 

但我希望做的就是找到和变化中寻找价值'Submit'或'Amend'等的值，或者如果没有输入'Submit'，那么我会添加一个。

但首先我想能够找到并更改Test1的值。

Answer 1

这是一种方法，使用XDocument：

string xml = @" 
<DBSimulatorConfigurations> 
    <Configurations> 
    <DBSimulatorConfiguration> 
     <Key>Test1</Key> 
     <Submit>0</Submit> 
     <Amend>0</Amend> 
     <Update>0</Update> 
     <Delete>1</Delete> 
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds> 
    </DBSimulatorConfiguration> 
    <DBSimulatorConfiguration> 
     <Key>Test2</Key> 
     <Submit>0</Submit> 
     <AutoUpdate>0</AutoUpdate> 
     <Amend>0</Amend> 
     <Update>0</Update> 
     <Delete>1</Delete> 
    <ResponseTimeInSeconds>100</ResponseTimeInSeconds> 
    </DBSimulatorConfiguration> 
    <DBSimulatorConfiguration> 
    </DBSimulatorConfiguration> 
    </Configurations> 
</DBSimulatorConfigurations>"; 

XDocument xdoc = XDocument.Parse(xml); 
//search for all nodes with <DBSimulatorConfiguration> element 
var elements = xdoc.Root.Elements().Elements().Where(x => x.Name == "DBSimulatorConfiguration"); 
//iterate through all those eleemnt 
foreach (var element in elements) 
{ 
    //now find it's child named Submit 
    var submitElement = element.Elements().FirstOrDefault(x => x.Name == "Submit"); 
    //if such element is found 
    if (submitElement != null) 
    { 
     //here you can change Submit element, like this: 
     // submitElement.Value = "abc"; 
     //or you can check for something 
     if (submitElement.ElementsBeforeSelf().Any(x=> x.Name == "Key" && x.Value== "Test2")) 
     { 
      //this is submitElement which is after element named Key with value Test2 
      submitElement.Value = "some specific value"; 
     } 
    } 
    else 
     element.Add(new XElement("Submit", 999)); 
} 

Answer 2

这似乎工作，以找到价值和更新。我已经更新了它，因此我可以为特定值找到任何值。

//search for all nodes with <DBSimulatorConfiguration> element 
string xml = "<path>.DBConfig.xml"; 
XDocument xdoc = XDocument.Load(xml); 
var elements = xdoc.Root.Elements().Elements().Where(x => x.Name == "DBSimulatorConfiguration"); 
//iterate through all those eleemnt 

foreach (var element in elements) 
{ 
    //Console.WriteLine("Empty {0}", element.Value); 
    //now find it's child named Submit 
    var configKey = element.Elements().FirstOrDefault(x => x.Name == "Key"); 
    var configSubmit = element.Elements().FirstOrDefault(x => x.Name == "Submit"); 
    var configAmend = element.Elements().FirstOrDefault(x => x.Name == "Amend"); 
    var configUpdate = element.Elements().FirstOrDefault(x => x.Name == "Update"); 
    var configDelete = element.Elements().FirstOrDefault(x => x.Name == "Delete"); 

    //if such element is found 
    if (configSubmit != null) 
    { 
     if (configKey.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1")) 
     { 
      Console.WriteLine("Found Key for Test1 {0}", configKey.Value); 
     } 
     if (configSubmit.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1")) 
     { 
      configSubmit.Value = "1"; 
      Console.WriteLine("Submit value is updated to {0}", configSubmit.Value);   
     } 
     if (configAmend.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1")) 
     { 
      Console.WriteLine("Amend value is: {0}", configAmend.Value); 
     } 
     if (configUpdate.ElementsBeforeSelf().Any(x => x.Name == "Key" && x.Value == "Test1")) 
     { 
      Console.WriteLine("Update value is: {0}", configUpdate.Value); 
     } 
    } 
} 
xdoc.Save("<path>.DBConfig.xml"); 

这是做这件事最有效的方法吗？