Combing a file and appending file name as a column in a csv using C'

See more:

C#

Hello,

I need to add combine multiple csv files but adding a header called Source which will be populated with the filename.I have a power shell script that works but Ive tired adding to my C# program. Ive used System.Management.Automation and followed some tutorials but still not working. I was wondering if someone could write it up for me if i provided my powershell skript and add notes to help me in the future.

Thank you

 cd c:\folder
    
    $files = Get-ChildItem ".\" | Where-Object { $_.Extension -eq ".csv" }
    
    for ($i=0; $i -lt $files.Count; $i++) {
        $outfile = $files[$i].FullName + "out" 
        $csv = Import-Csv $files[$i].FullName 
        $newcsv = @()
        foreach ( $row in $csv ) {
            $row | Add-Member -MemberType NoteProperty -Name 'Source' -Value   $files[$i].BaseName
            $newcsv += $row
        }
    
         $newcsv | Export-Csv $files[$i].Name -NoTypeInformation
    
    }

$files = Get-ChildItem C:\folder\*.csv 
$files | ForEach-Object {Import-Csv $_} | 
    Export-Csv -NoTypeInformation C:\folder\combined.csv

What I have tried:

I have a power shell script that works but Ive tired adding to my C# program. Ive used System.Management.Automation and followed some tutorials but still not working.