René's URL Explorer Experiment


Title: Extend [DataTable] with easy constructor and AddRow method · Issue #11987 · PowerShell/PowerShell · GitHub

Open Graph Title: Extend [DataTable] with easy constructor and AddRow method · Issue #11987 · PowerShell/PowerShell

X Title: Extend [DataTable] with easy constructor and AddRow method · Issue #11987 · PowerShell/PowerShell

Description: A list of [PSCustomObject] objects consumes multiple times the amount of memory as a [DataTable]. For a lot of .Net classes there are accelerators and PowerShell constructors but to create a [DataTable] in PowerShell is quiet an hassle, ...

Open Graph Description: A list of [PSCustomObject] objects consumes multiple times the amount of memory as a [DataTable]. For a lot of .Net classes there are accelerators and PowerShell constructors but to create a [DataT...

X Description: A list of [PSCustomObject] objects consumes multiple times the amount of memory as a [DataTable]. For a lot of .Net classes there are accelerators and PowerShell constructors but to create a [DataT...

Opengraph URL: https://github.com/PowerShell/PowerShell/issues/11987

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Extend [DataTable] with easy constructor and AddRow method","articleBody":"A list of `[PSCustomObject]` objects consumes multiple times the amount of memory as a `[DataTable]`. For a lot of .Net classes there are accelerators and PowerShell constructors but to create a `[DataTable]` in PowerShell is quiet an hassle, see e.g. [Creating table using Powershell](https://docs.microsoft.com/nl-nl/archive/blogs/rkramesh/creating-table-using-powershell).\r\n\r\nIt would be nice to be able to construct a data table the PowerShell way, e.g.:\r\n```PowerShell\r\n$Table = [DataTable]('Text', 'Number')\r\n```\r\nOr:\r\n```PowerShell\r\n$Table = [DataTable]@{Text = [String]; 'Number' = [Int]}\r\n```\r\n\r\nAnd add data rows like:\r\n```PowerShell\r\n$Table.AddRow(@('A', 1))\r\n```\r\nOr:\r\n```PowerShell\r\n$Table.AddRow(@{Text = 'A',  Number = 1})\r\n```\r\nAs I don't have enough experience with C#, I have created a derived `[DataTable]` class in \r\nPowerShell to test the idea:\r\n\r\n```PowerShell\r\nclass DataTable : Data.DataTable {\r\n\tDataTable([Array]$ColumnNames) {\r\n\t\tForEach ($ColumnName in $ColumnNames) { \r\n\t\t\tIf ($ColumnName -is [PSCustomObject]) {Write-Host 'PSCustomObject'}\r\n\t\t\tElse { $This.AddColumn($ColumnName) }\r\n\t\t}\r\n\t}\r\n\tDataTable([System.Collections.IDictionary]$ColumnNameTypes) {\r\n\t\tForEach($Key in $ColumnNameTypes.Get_keys()) { $This.AddColumn($Key, $ColumnNameTypes[$Key]) }\r\n\t}\r\n\t[Void]AddColumn([String]$ColumnName) {\r\n\t\t$DataColumn = New-Object Data.DataColumn($ColumnName)\r\n\t\t$This.Columns.Add($DataColumn)\r\n\t}\r\n\t[Void]AddColumn([String]$ColumnName, [Type]$ColumnType = [String]) {\r\n\t\t$DataColumn = New-Object Data.DataColumn($ColumnName, $ColumnType)\r\n\t\t$This.Columns.Add($DataColumn)\r\n\t}\r\n\t[Void]AddRow([Array]$Array) {\r\n\t\t$DataRow = $This.NewRow()\r\n\t\tFor ($i = 0; $i -lt $Array.Length; $i++) {\r\n\t\t\tIf ($i -lt $This.Columns.Count) { $DataRow.Item($i) = $Array[$i] }\r\n\t\t}\r\n\t\t$This.Rows.Add($DataRow)\r\n\t}\r\n\t[Void]AddRow([System.Collections.IDictionary]$Dictionary) {\r\n\t\t$DataRow = $This.NewRow()\r\n\t\tForEach ($Name in $Dictionary.get_Keys()) {\r\n\t\t\tIf ($This.Columns.Contains($Name)) { $DataRow.Item($Name) = $Dictionary[$Name] }\r\n\t\t}\r\n\t\t$This.Rows.Add($DataRow)\r\n\t}\r\n\t[Void]AddRow([PSCustomObject]$PSObject) {\r\n\t\t$DataRow = $This.NewRow()\r\n\t\tForEach ($Name in $PSObject.PSObject.Properties.Name) {\r\n\t\t\tIf ($This.Columns.Contains($Name)) { $DataRow.Item($Name) = $PSObject.$Name }\r\n\t\t}\r\n\t\t$This.Rows.Add($DataRow)\r\n\t}\r\n}\r\n\r\n#Example 1\r\n\r\n$MyDataTable = [DataTable]('a', 'b', 'c')\r\n$MyDataTable.AddRow(@(1,2,3))\r\n$MyDataTable\r\n\r\na b c\r\n- - -\r\n1 2 3\r\n\r\n#Example 2\r\n\r\n$Table = [DataTable]@{Text = [String]; 'Number' = [Int]}\r\n$Table.AddRow(@{Text = 'A'; Number = 1})\r\n$Table\r\n\r\nText Number\r\n---- ------\r\nA         1\r\n\r\n# Example 3\r\n\r\n# $Process = [DataTable]@((Get-Process | Select-Object -First 1).PSStandardMembers.DefaultDisplayPropertySet.ReferencedPropertyNames)\r\n$Process = [DataTable][Ordered]@{Id = [Int]; ProcessName = [String]}\r\nGet-Process | ForEach-Object { $Process.AddRow($_) }\r\n$Process","author":{"url":"https://github.com/iRon7","@type":"Person","name":"iRon7"},"datePublished":"2020-03-02T11:13:14Z","url":"https://github.com/PowerShell/PowerShell/issues/11987"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:96c85738-106c-8320-9792-d0123c43485e
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idB6CE:22AC9A:2483AE:319C26:6AFD51ED
html-safe-nonce9ffc8c58ea61f479a644a11eee630daaf9137ad031637abf2a3e9f97a819b66f
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCNkNFOjIyQUM5QToyNDgzQUU6MzE5QzI2OjZBRkQ1MUVEIiwidmlzaXRvcl9pZCI6IjM3NDMxNTU5ODEyNzg1OTc2MTMiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmaca8f54556d7a9833aa231490b1fc119a123a3ad39357a6f2cd5c0f23ffd7c2eba
hovercard-subject-tagissue:573902024
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/PowerShell/PowerShell/11987/issue_layout
twitter:imagehttps://opengraph.githubassets.com/f86fdaefe20e4a7561a410572bd49a903fa127261c6723a06ac1586c05ff8aa0/PowerShell/PowerShell/issues/11987
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/f86fdaefe20e4a7561a410572bd49a903fa127261c6723a06ac1586c05ff8aa0/PowerShell/PowerShell/issues/11987
og:image:altA list of [PSCustomObject] objects consumes multiple times the amount of memory as a [DataTable]. For a lot of .Net classes there are accelerators and PowerShell constructors but to create a [DataT...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameiRon7
hostnamegithub.com
expected-hostnamegithub.com
None66653c2e55a6fff2930be1bdf07ee4f8aa137e3956d056c822563be6f878755e
turbo-cache-controlno-preview
go-importgithub.com/PowerShell/PowerShell git https://github.com/PowerShell/PowerShell.git
octolytics-dimension-user_id11524380
octolytics-dimension-user_loginPowerShell
octolytics-dimension-repository_id49609581
octolytics-dimension-repository_nwoPowerShell/PowerShell
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id49609581
octolytics-dimension-repository_network_root_nwoPowerShell/PowerShell
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releaseb6f01f7cb9f35f8c09949773241a3d49dd04b340
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/PowerShell/PowerShell/issues/11987#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FPowerShell%2FPowerShell%2Fissues%2F11987
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FPowerShell%2FPowerShell%2Fissues%2F11987
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=PowerShell%2FPowerShell
Reloadhttps://github.com/PowerShell/PowerShell/issues/11987
Reloadhttps://github.com/PowerShell/PowerShell/issues/11987
Reloadhttps://github.com/PowerShell/PowerShell/issues/11987
PowerShellhttps://github.com/PowerShell
PowerShellhttps://github.com/PowerShell/PowerShell
Codehttps://github.com/PowerShell/PowerShell
Issues1.3k (1.3k)https://github.com/PowerShell/PowerShell/issues
Pull requests365 (365)https://github.com/PowerShell/PowerShell/pulls
Discussionshttps://github.com/PowerShell/PowerShell/discussions
Actionshttps://github.com/PowerShell/PowerShell/actions
Projectshttps://github.com/PowerShell/PowerShell/projects
Security and quality3 (3)https://github.com/PowerShell/PowerShell/security
Insightshttps://github.com/PowerShell/PowerShell/insights
https://github.com/PowerShell/PowerShell
New issuehttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/11987
New issuehttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/11987
Extend [DataTable] with easy constructor and AddRow methodhttps://github.com/PowerShell/PowerShell/issues/11987#top
Issue-Enhancementthe issue is more of a feature request than a bughttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Enhancement%22
Resolution-DeclinedThe proposed feature is declined.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-Declined%22
WG-Enginecore PowerShell engine, interpreter, and runtimehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22WG-Engine%22
https://github.com/iRon7
iRon7https://github.com/iRon7
on Mar 2, 2020https://github.com/PowerShell/PowerShell/issues/11987#issue-573902024
Creating table using Powershellhttps://docs.microsoft.com/nl-nl/archive/blogs/rkramesh/creating-table-using-powershell
iRon7https://github.com/iRon7
Issue-Enhancementthe issue is more of a feature request than a bughttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Enhancement%22
on Mar 2, 2020https://github.com/PowerShell/PowerShell/issues/11987#event-3087499773
iRon7https://github.com/iRon7
on Mar 2, 2020https://github.com/PowerShell/PowerShell/issues/11987#event-3087951517
Ilya (iSazonov)https://github.com/iSazonov
WG-Enginecore PowerShell engine, interpreter, and runtimehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22WG-Engine%22
on Mar 2, 2020https://github.com/PowerShell/PowerShell/issues/11987#event-3088897933
https://github.com/iSazonov
Ilya (iSazonov)https://github.com/iSazonov
on Mar 2, 2020https://github.com/PowerShell/PowerShell/issues/11987#issuecomment-593519510
Steve Lee (SteveL-MSFT)https://github.com/SteveL-MSFT
WG-Languageparser, language semanticshttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22WG-Language%22
on Oct 29, 2022https://github.com/PowerShell/PowerShell/issues/11987#event-7697289465
https://github.com/SteveL-MSFT
Steve Lee (SteveL-MSFT)https://github.com/SteveL-MSFT
on Oct 29, 2022https://github.com/PowerShell/PowerShell/issues/11987#issuecomment-1295884876
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
Resolution-No ActivityIssue has had no activity for 6 months or morehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-No%20Activity%22
on Nov 16, 2023https://github.com/PowerShell/PowerShell/issues/11987#event-10975236863
https://github.com/iRon7
iRon7https://github.com/iRon7
on Nov 16, 2023https://github.com/PowerShell/PowerShell/issues/11987#issuecomment-1814479044
Issue we would like to prioritize, but we can't commit we will get to it yethttps://github.com/dotnet/runtime/labels?q=wishlist
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
Resolution-No ActivityIssue has had no activity for 6 months or morehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-No%20Activity%22
on Nov 16, 2023https://github.com/PowerShell/PowerShell/issues/11987#event-10980955306
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
Resolution-No ActivityIssue has had no activity for 6 months or morehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-No%20Activity%22
on May 14, 2024https://github.com/PowerShell/PowerShell/issues/11987#event-12807161649
https://github.com/iRon7
iRon7https://github.com/iRon7
on May 15, 2024https://github.com/PowerShell/PowerShell/issues/11987#issuecomment-2111733532
Issue we would like to prioritize, but we can't commit we will get to it yethttps://github.com/dotnet/runtime/labels?q=wishlist
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
Resolution-No ActivityIssue has had no activity for 6 months or morehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-No%20Activity%22
on May 15, 2024https://github.com/PowerShell/PowerShell/issues/11987#event-12812159820
Patrick Meinecke (SeeminglyScience)https://github.com/SeeminglyScience
Needs-TriageThe issue is new and needs to be triaged by a work group.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Needs-Triage%22
WG-NeedsReviewNeeds a review by the labeled Working Grouphttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22WG-NeedsReview%22
WG-Languageparser, language semanticshttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22WG-Language%22
on May 15, 2024https://github.com/PowerShell/PowerShell/issues/11987#event-12822684248
https://github.com/SeeminglyScience
Patrick Meinecke (SeeminglyScience)https://github.com/SeeminglyScience
on Jun 2, 2025https://github.com/PowerShell/PowerShell/issues/11987#issuecomment-2932054599
Patrick Meinecke (SeeminglyScience)https://github.com/SeeminglyScience
Resolution-DeclinedThe proposed feature is declined.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-Declined%22
Needs-TriageThe issue is new and needs to be triaged by a work group.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Needs-Triage%22
WG-NeedsReviewNeeds a review by the labeled Working Grouphttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22WG-NeedsReview%22
on Jun 2, 2025https://github.com/PowerShell/PowerShell/issues/11987#event-17941066479
https://github.com/apps/microsoft-github-policy-service
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
on Jun 3, 2025https://github.com/PowerShell/PowerShell/issues/11987#issuecomment-2937403045
Microsoft GitHub Policy Servicehttps://aka.ms/1es-gitops
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
completedhttps://github.com/PowerShell/PowerShell/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Jun 3, 2025https://github.com/PowerShell/PowerShell/issues/11987#event-17968767485
https://github.com/apps/microsoft-github-policy-service
microsoft-github-policy-servicehttps://github.com/apps/microsoft-github-policy-service
on Jun 3, 2025https://github.com/PowerShell/PowerShell/issues/11987#issuecomment-2937403549
Microsoft GitHub Policy Servicehttps://aka.ms/1es-gitops
iRon7https://github.com/iRon7
https://aka.ms/PSRepoFeedbackhttps://aka.ms/PSRepoFeedback
Microsoft Formshttps://aka.ms/PSRepoFeedback
Sign up for freehttps://github.com/signup?return_to=https://github.com/PowerShell/PowerShell/issues/11987
Sign in to commenthttps://github.com/login?return_to=https://github.com/PowerShell/PowerShell/issues/11987
Issue-Enhancementthe issue is more of a feature request than a bughttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Issue-Enhancement%22
Resolution-DeclinedThe proposed feature is declined.https://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22Resolution-Declined%22
WG-Enginecore PowerShell engine, interpreter, and runtimehttps://github.com/PowerShell/PowerShell/issues?q=state%3Aopen%20label%3A%22WG-Engine%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.