Solved

PowerShell to C# XML Help

Posted on 2011-09-24
5
397 Views
Last Modified: 2012-05-12
I just recently got into using PowerShell because it is quite amazing for, well, just about anything. And it's easy to learn, I do have a need to use c# time to time however, as I am part of a much larger project,  Is there something as simple as this PowerShell Call in C#

[xml]$myXML = Get-Content drive:\path\to\myfile.xml
0
Comment
Question by:jjthomas3
  • 3
  • 2
5 Comments
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 36593955
It should be as simple as:
System.Xml.XmlDocument myXML = new System.Xml.XmlDocument();

myXML.Load("drive:\path\to\myfile.xml");

Open in new window

0
 
LVL 1

Author Comment

by:jjthomas3
ID: 36713152
In PowerShell if I delcare

[xml]$myXML = Get-Content drive:\path\to\myfile.xml

And myFile.XML looks like this one here:

<?xml.....   >
<application name="my Application">
  <connections>234</connections>
  <lastUser>Mr. Sinatra</lastUser>
</application>

Open in new window


I do not have to write any more code to directly interact with the XML..... so that if I were to output the value of $myXML.Application.Name the return would be "my Application". Likewise, if I had the following XML file, services.xml:
 
<?xml....>
<services>
    <service>
         <name>SampleService01</spooler>
         <description>Windows Sample Service 01</description>
    </service>
    <service>
         <name>SampleService02</spooler>
         <description>Windows Sample Service 02</description>
    </service>
    <service>
         <name>SampleService03</spooler>
         <description>Windows Sample Service 03</description>
    </service>
    <service>
         <name>SampleService04</spooler>
         <description>Windows Sample Service 04</description>
    </service>
</services>

Open in new window


I could simply perform the following foreach loop
 
[xml]$services= Get-Content drive:\path\to\services.xml
foreach ($service in $services) {
     Write-Host "Service Name:`t$service.Name"
     Write-Host "Description :`t$service.Description"
     ......perform other actions or logic against service....
}

//Or even access the members/nodes directly

Start-Service $services.Services.Service[1].Name

Open in new window



I don't have to write any additional code to parse the data out of the XML File. I was hoping for something as simple in C# with having to iterate through NodeTypes, or using Reader.Read() with switch statements etc.
0
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 36714637
I don't believe you can get that much automatic interaction, at least not without some initial scaffolding, but I also don't believe the code to interact with the file is that much different. Given you last code post ( http:#codeSnippet8210165 ), I would envision an equivalent in C# to be:

namespace _27326029
{
    class Program
    {
        static void Main(string[] args)
        {
            System.Xml.XmlDocument myXML = new System.Xml.XmlDocument();

            myXML.Load(@"input.xml");

            foreach (System.Xml.XmlNode service in myXML.SelectNodes("//service"))
            {
                System.Console.WriteLine("Service Name: {0}", service.SelectSingleNode("name").InnerText);
                System.Console.WriteLine("Description: {0}\n", service.SelectSingleNode("description").InnerText);
            }

            System.Console.ReadKey();
        }
    }
}

Open in new window



Untitled.png
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 36714648
What I meant by "automatic interaction" was demonstrated in your code as:

t$service.Name

Open in new window


It appears that PS actually creates an underlying object for you with the property names set to the node names. You'll notice above that I had to refer to the nodes using strings (in the Select*Node* calls). You can get something similar to what you have, but it would rely on the aforementioned "scaffolding".
0
 
LVL 1

Author Closing Comment

by:jjthomas3
ID: 36894582
PowerShell makes it much easier, but unfortunately there's no automatic serialization/deserialization. So, that having been said, there's not much more code  than what I was doing in PS. Thanks.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Office 365 Maximum Recipients limitation 3 36
Invoke command powershell 4 27
IF statment In Powershell 12 19
PS call executable Files in Order 4 17
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question