Databases
StackOverflow2013
Postsdbo
POC# LINQ for tree oriented data structure of classes
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POC# LINQ for tree oriented data structure of classes
    primarykey
    data
    text
    <p>I have List where myObj has it own list of objects called example mySubObj. Object mySubObj has prop string Name.</p> <p>So I want to create new List base on prop string Name from mySubObj.</p> <p>I wrote this code, but it seems that it's wrong:</p> <pre><code>var por = msgs.Where(x =&gt; x.Parameters .Where(p =&gt; p.ParameterName == s).Count() == 1); </code></pre> <p>Can anyone help me with LINQ?</p> <p>EDIT: This is whole code:</p> <pre><code> foreach (string s in parameters) { using (StreamWriter streamWriter = new StreamWriter(outputFolder + "/" + s + ".xls")) { streamWriter.Write("No.\tMessage\tMS\tTime\tSC"); var por = (from m in msgs from p in m.Parameters where p.ParameterName == s select m).Distinct(); List&lt;string&gt; headeri = new List&lt;string&gt;(); List&lt;string&gt; vrijednosti = new List&lt;string&gt;(); foreach (L3Message p in por) { foreach (Parameter pam in p.Parameters) { TraverseForHeaders(pam, ref headeri); } } foreach (string head in headeri) { streamWriter.Write("\t" + head); } streamWriter.Write("\n"); </code></pre> <p><strong>Edit 2:</strong></p> <p>Here is two of my classes, with this it should be more specified:</p> <pre><code>public class L3Message { public int Number { get; set; } public string MessageName { get; set; } public string Device { get; set; } public string Time { get; set; } public string ScramblingCode { get; set; } public List&lt;Parameter&gt; Parameters { get; set; } public L3Message() { Parameters = new List&lt;Parameter&gt;(); }} public class Parameter { public int numOfWhitespaces { get; set; } public string ParameterName { get; set; } public string ParameterValue { get; set; } public Parameter Parent { get; set; } public List&lt;Parameter&gt; SubParameters { get; set; } public Parameter() { SubParameters = new List&lt;Parameter&gt;(); } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohnDoeKazama
    1. USJohnDoeKazama
    plurals
    1. PL
      singulars
      1. LTLinked
    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. POC# LINQ for tree oriented data structure of classes
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POC# LINQ for tree oriented data structure of classes
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POC# LINQ for tree oriented data structure of classes
      1. USArion
      1. VTFavorite
    1. CODo you want to have all the messages that have some parameter with name x?
      singulars
      1. POC# LINQ for tree oriented data structure of classes
      1. USaKzenT
    2. COHow does this seem wrong? What are you trying to do? What are you getting versus what you except?
      singulars
      1. POC# LINQ for tree oriented data structure of classes
      1. USJustin Pihony
    3. COHmm. I found problem, but not solution, problem is that myObj has both ParameterNames, and this LINQ do what it is supose to do. Except I want in output take myObj witch have only mySubObj with one define ParameterName, another way to say I want role out all subObj with name different than string s. I'll edited question.
      singulars
      1. POC# LINQ for tree oriented data structure of classes
      1. USJohnDoeKazama
 

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