take powershell object save as xml and load in c#

Question

I have the following powershell script that scans a location and adds the file details to a xml file,

Get-ChildItem -recurse c:\DATA | Select-Object  * , @{Name="Kbytes";Expression={ "{0:N0}" -f ($_.Length / 1Kb) }},@{Name="Age";Expression={ (((Get-Date) - $_.CreationTime).Days) }}  | Export-Clixml c:\DATA\Final.xml

As far as I understand this should be a object in the .net framework, assuming a dataset ? what I would like to do is load this object into a c# application and use it as a dataset.

How would I load the object into a dataset in c# ?

By using Export-CliXML you are seriealizing the data. so, When you deserialize this, it won't be a live object. All the methods available on the object will be lost. — ravikanth
– ravikanth, Commented Jun 18, 2012 at 18:21

user189198 · Accepted Answer · 2012-06-18 18:22:11Z

6

Add reference to the System.Management.Automation.dll assembly.
Create a PowerShell Runspace
Open the Runspace
Create a PowerShell Pipeline object with the Import-CliXml command
Invoke the Pipeline

Close the Runspace

    var rs = RunspaceFactory.CreateRunspace();
    rs.Open();
    var pl = rs.CreatePipeline(@"Import-CliXml c:\DATA\Final.xml;");
    var result = pl.Invoke();
    rs.Close();

answered Jun 18, 2012 at 18:22

user189198

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

Comments

Adrian Mole · Accepted Answer · 2020-05-05 12:53:50Z

1

A faster approach might be:

-For lists

object[] xmlAsList =
     System.Management.Automation.PSSerializer.DeserializeAsList(System.IO.File.ReadAllText(@"C:\Users\batman\Desktop\myList.clixml"));

-For generic objects

object importedObject =
 System.Management.Automation.PSSerializer.Deserialize(System.IO.File.ReadAllText(@"C:\Users\batman\Desktop\myObject.clixml"));

Then, you manage the results via: System.Management.Automation.PSObject using the Members property.

edited May 5, 2020 at 12:53

Adrian Mole

52.2k193 gold badges61 silver badges101 bronze badges

answered May 5, 2020 at 10:18

Garfius

678 bronze badges

Collectives™ on Stack Overflow

take powershell object save as xml and load in c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related