Databases
StackOverflow2013
Postsdbo
POHow to change Distinct funcationality within .NET?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to change Distinct funcationality within .NET?
    primarykey
    data
    text
    <p>I have an issue that I am sure someone out here have solved easier than what I am thinking to do. I have a list that have name and number. Name is required and could be duplicate and number could only be one, but not required.</p> <pre><code>|name|number| |A |2 | |A | | |B | | |C | | |C | | |D |4 | ------------- </code></pre> <p>At this moment I am performing a list.Distinct() on the name part, but it does not care about the number section. </p> <pre><code>newlist = oldlist.Distinct().ToList(); </code></pre> <p>If one name that is duplicate has a number I want to keep the one with the number, which is not happening. The case of two same names and two different numbers will not happen. Any ideas?</p> <p>One more thing: At this moment I don't care about sorting since distinct take care of that.</p> <p>I am adding all the code for better visibility of the StackOverflow Team:</p> <pre><code> class _ClientComparer : IEqualityComparer&lt;_Client&gt; { #region IEqualityComparer&lt;_Client&gt; Members public bool Equals(_Client x, _Client y) { if ((x.ClientNumber != 0) &amp;&amp; (y.ClientNumber != 0))//Both clients with numbers if (x.ClientNumber == y.ClientNumber)//both clients number the same then same clients. return true; else //if not the same they are different return false; else if (x.ClientName == y.ClientName) return true; else return false; } public int GetHashCode(_Client obj) { if (obj.ClientNumber != 0) return obj.ClientNumber.GetHashCode(); else return obj.ClientName.GetHashCode(); } </code></pre> <p>Above the IEqualityComparer implementation and below the Distinct Call.</p> <pre><code> public List&lt;_Client&gt; CollectAllClients() { List&lt;_Client&gt; ClientList = new List&lt;_Client&gt;(); while (this.Read()) { if (GetClientNumber() != 0) ClientList.Add(CreateClientInstance()); else ClientList.AddRange(CreateClientsInstance()); } ClientList = ClientList.Distinct&lt;_Client&gt;(new _ClientComparer()).ToList&lt;_Client&gt;() ; return ClientList; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGeo
    1. USGeo
    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. POHow to change Distinct funcationality within .NET?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou could supply some additional code (what exactly is `oldList`, how does the custom class look like etc.).
      singulars
      1. POHow to change Distinct funcationality within .NET?
      1. USGroo
    2. COThanks Groo for your comment. I added all my code related to this question, please let me know if this helps.
      singulars
      1. POHow to change Distinct funcationality within .NET?
      1. USGeo
 

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