Databases
StackOverflow2013
Postsdbo
POFastest collection for collection of items which each has collections of items to iterate through
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFastest collection for collection of items which each has collections of items to iterate through
    text
    copied!<p>I have a small collection (about 10 items) that each has a medium collection (from 200 to sometimes 500) of items linked (Many-to-one relationship, if I'm correct). </p> <p>I am looking for a way to iterate through the lists like this:</p> <pre><code>var cardSetQry = from cs in mDb.CARD_SET select cs; List&lt;CARD_SET&gt; listCardSets = cardSetQry.ToList(); Dictionary&lt;string, List&lt;CARD&gt;&gt; cardsList = new Dictionary&lt;string, List&lt;CARD&gt;&gt;(); foreach (var cardSet in listCardSets) { CARD_SET set = cardSet; var cardQry = from c in mDb.CARD where c.CARD_SET_IDE == set.CARD_SET_IDE select c; if (cardQry.Any()) { HashSet&lt;CARD&gt; listCards = new HashSet&lt;CARD&gt;(cardQry.ToList()); foreach (var card in listCards) { card.CARD_MASTER_IDE = null; card.CARD_CHILD_IDE = null; mDb.SaveChanges(); } cardsList.Add(set.CARD_SET_NAME, listCards); } } </code></pre> <p>I'm using the <code>dictionary</code> because I need both the card set name and the list of objects related, but I'm open to suggestions. This method is called once when the app is started and has to iterate through every items.</p> <p>As for the second list (<code>HashSet</code>), I've started using this since last week. Small research made me believe that a hashSet is a fast collection type. But I don't know how it works.</p> <p>So, the question: to achieve what I need to do, what would be the fastest collections to use, and why?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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