Databases
StackOverflow2013
Postsdbo
PONested LINQ Query Question
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONested LINQ Query Question
    primarykey
    data
    text
    <p>I ran into an issue today and I have been stumped for some time in trying to get the results I am searching for.</p> <p>I currently have a class that resembles the following:</p> <pre><code>public class InstanceInformation { public string PatientID {get; set;} public string StudyID {get; set;} public string SeriesID {get; set;} public string InstanceID {get; set;} } </code></pre> <p>I have a <code>List&lt;InstanceInformation&gt;</code> and I am trying to use LINQ (or whatever other means to generate paths (<strong>for a file-directory</strong>) based on this list that resemble the following:</p> <pre><code>PatientID/StudyID/SeriesID/InstanceID </code></pre> <p>My issue is the data is currently unstructured as it comes in the previously mentioned form (List) and I need a way to group all of the data with the following constraints:</p> <ul> <li><strong>Group InstanceIDs by SeriesID</strong></li> <li><strong>Group SeriesIDs by StudyID</strong></li> <li><strong>Group StudyIDs by PatientID</strong></li> </ul> <p>I currently have something that resembles this:</p> <pre><code>var groups = from instance in instances group instance by instance.PatientID into patientGroups from studyGroups in (from instance in patientGroups group instance by instance.StudyID) from seriesGroup in (from instance in studyGroups group instance by instance.SeriesID) from instanceGroup in (from instance in seriesGroup group instance by instance.InstanceID) group instanceGroup by patientGroups.Key; </code></pre> <p>which just groups all of my InstanceIDs by PatientID, and it's quite hard to cull through all of the data after this massive grouping to see if the areas in between (StudyID/SeriesID) are being lost. Any other methods of solving this issue would be more than welcome.</p> <p>This is primarily just for <strong>grouping the objects</strong> - as I would need to then iterate through them (using a foreach)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStereško
    1. USRion Williams
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONested LINQ Query Question
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PONested LINQ Query Question
      1. USSilence Dogood
      1. VTFavorite
    3. VO
      singulars
      1. PONested LINQ Query Question
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWould this help? var result = instances.GroupBy(i=> new{ i.InstanceID , i.SeriesID, i.StudyID, i.PatientID })
      singulars
      1. PONested LINQ Query Question
      1. USWorldIsRound
    2. CONope - Thanks though HelloWorld, this resulted in just a list of all of the items in my list. I think the problem I am having is trying to use LINQ to build relationships.
      singulars
      1. PONested LINQ Query Question
      1. USRion Williams
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload