Databases
StackOverflow2013
Postsdbo
POWhy is IEnumerable.Count() capped at 200?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy is IEnumerable.Count() capped at 200?
    primarykey
    data
    text
    <p>Is there a limit to the rows that IEnumerable.Count() (or IQueryable.Count()) using LINQ to SQL? For whatever reason, if my query returns more than 200 records, I only get 200 from IEnumerable.Count(). I've even tried using IEnumerable.LongCount() (even though the number of results shouldn't be high enough to need it). I've also verified that calling COUNT on the database returns more than 200 records.</p> <p>I've checked MSDN and tried Googling it, but to no avail. </p> <p>Am I going crazy, or is there something that I'm missing somewhere? I suppose this isn't really a big deal (as the program is inserting the right number of records), but it'd be nice to be able to log the number of records transferred.</p> <blockquote> <p>Could we see some sample code?</p> </blockquote> <pre><code>public IEnumerable&lt;Irms_tx_modify_profile_ban&gt; ExtractNewAdmits() { var results = from a in _dc.Applications select (Irms_tx_modify_profile_ban)new RMSProfile { //assign column names to property names }; //Don't know why, but Bad Things happen if you don't put the //OfType call here. IEnumerable&lt;Irms_tx_modify_profile_ban&gt; narrowed_results = results.OfType&lt;Irms_tx_modify_profile_ban&gt;(); Program.log.InfoFormat("Read {0} records from Banner.", narrowed_results.Count()); return narrowed_results; } </code></pre> <p>The reason for the comment about bad things happening is due to <a href="https://stackoverflow.com/questions/378895/operation-could-destabilize-the-runtime">the issues brought up in this thread</a>. What I did just find out is that if I call Count on narrowed_results (IEnumerable), it returns the right amount. If I call it on results (IQueryable), it returns just 200. I'll go ahead and solve Skeet's answer (since he mentioned the difference between IQueryable and IEnumerable), but if anyone is able to explain why this is happening, I'd like to hear it.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJason Baker
    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
    1. VO
      singulars
      1. POWhy is IEnumerable.Count() capped at 200?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhy is IEnumerable.Count() capped at 200?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAssign the _dc.Log to something so you can see what SQL is being generated. AsEnumerable.Count will cause the query to execute and the count will operate on the results loaded into memory. Performing it on the IQueryable will cause the count to be translated to the server...
      singulars
      1. POWhy is IEnumerable.Count() capped at 200?
      1. USDamienG
 

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