search

dotnet / docs

This repository contains .NET Documentation.
https://learn.microsoft.com/dotnet
Creative Commons Attribution 4.0 International
4.28k stars 5.91k forks source link

The odd-even integer example obfuscates the article #43627

Open ClarkFrazier opened 3 days ago

ClarkFrazier commented 3 days ago

Type of issue

Other (describe below)

Description

Ineffective example presented before an adequate explanation of functionalit y.

[Enter feedback here]

Page URL

https://learn.microsoft.com/en-us/dotnet/csharp/linq/standard-query-operators/grouping-data

Content source URL

https://github.com/dotnet/docs/blob/main/docs/csharp/linq/standard-query-operators/grouping-data.md

Document Version Independent Id

6a93a042-3dc5-7e82-a325-8937c72e46c2

Article author

@BillWagner

Metadata

Related Issues

BillWagner commented 3 days ago

Hi @ClarkFrazier

I'd like to learn more about what you want different here. That example does serve the purpose of explaining the syntax using an obvious grouping. Do you want the explanation before the sample? Or do you have a different example to suggest?

ClarkFrazier commented 2 days ago

Hi Bill,

Thank you for responding.

What do LINQ methods do and what are their inputs and outputs? Perhaps the order below would be useful. Is the syntax needed before the explanation? Suggested order:

  1. A clear explanation of what the statement does in a single sentence or short paragraph.
  2. A clear definition of query parameters (any that apply): Common table parameters, select list, ( into) new table, (from) data sources, (where) search conditions, group by, having, partitioning, and order by. Also, if applicable, union, except, and intersect to expand or reduce the result set.
  3. Suggested usages.
  4. Use case examples to illustrate syntax using string parameters in addition to integers.

If a query does not work, use case examples may help. Simple list and integer use case examples could show a pathway to more complex use cases. Are there examples using strings and dictionaries in addition to integers and lists? Is there a recommended way to build a partitioned list of source data elements grouped by the form key?

I am working on a small project that merges two Excel data sources mapped in a third Excel spreadsheet to populate a PDF form. A few years ago I built and application with Transact-SQL stored procedures to merge Excel instance, catalog, and mapping spreadsheets into SQL Server tables that define eBay listings. This project was intended to replicate some of the SQL Server functionality to user environments where SQL Server might not be available. One objective of the code rewrite is to minimize use of for or foreach loops for repetitive operations. The initial c# version made do with traditional C language style elements including multiple switch statements embedded in a foreach loop. The new code flattens the merged dataset definition joining a row from source data with a row in a catalog data into a dictionary with unique keys from the mapping spreadsheet. Each row is associated with an action and a form key. Some form keys associate with multiple actions, requiring a group by to build a form key list. Elements associated with each form key are processed as directed by an associated action into a unique, merged, or no-action form element.

Does a LINQ and set operations for SQL Server developers document exist?

I hope this helps.

Thank you,

Clark Frazier

From: Bill Wagner @.> Sent: Tuesday, November 19, 2024 8:10 AM To: dotnet/docs @.> Cc: ClarkFrazier @.>; Mention @.> Subject: Re: [dotnet/docs] The odd-even integer example obfuscates the article (Issue #43627)

Hi @ClarkFrazierhttps://github.com/ClarkFrazier

I'd like to learn more about what you want different here. That example does serve the purpose of explaining the syntax using an obvious grouping. Do you want the explanation before the sample? Or do you have a different example to suggest?

- Reply to this email directly, view it on GitHubhttps://github.com/dotnet/docs/issues/43627#issuecomment-2485672456, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ANHIF6HIKIDB27O62754W3D2BM2BBAVCNFSM6AAAAABSAHKMQWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOBVGY3TENBVGY. You are receiving this because you were mentioned.Message ID: @.**@.>>