Databases
StackOverflow2013
Postsdbo
POHow to access count property of a dynamic type in C# 4.0?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to access count property of a dynamic type in C# 4.0?
    primarykey
    data
    text
    <p>I have the follow method that returns a dynamic object representing an <code>IEnumerable&lt;'a&gt;</code> ('a=anonymous type) :</p> <pre><code> public dynamic GetReportFilesbyStoreProductID(int StoreProductID) { Report report = this.repository.GetReportByStoreProductID(StoreProductID); if (report == null || report.ReportFiles == null) { return null; } var query = from x in report.ReportFiles orderby x.DisplayOrder select new { ID = x.RptFileID, Description = x.LinkDescription, File = x.LinkPath, GroupDescription = x.ReportFileGroup.Description }; return query; } </code></pre> <p>I want to be able to access the <code>Count</code> property of this <code>IEnumerable</code> anonymous type. I'm trying to access the above method using the following code and it is failing:</p> <pre><code> dynamic Segments = Top20Controller.GetReportFilesbyStoreProductID(StoreProductID"); if (Segments.Count == 0) // &lt;== Fails because object doesn't contain count. { ... } </code></pre> <ul> <li>How does <code>dynamic</code> keyword operate?</li> <li>How can I access the <code>Count</code> property of the <code>IEnumerable</code> anonymous type?</li> <li>Is there a way I can use this anonymous type or do I have to create a custom object so that I can pass back a strongly-typed <code>IEnumerable&lt;myObject&gt;</code> instead of <code>dynamic</code>? </li> </ul> <p>I'd prefer to not do that if I can as this method is only called in one place and creating a throw-away object seems like overkill.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGustavo Mori
    1. USRodney
    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. POHow to access count property of a dynamic type in C# 4.0?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to access count property of a dynamic type in C# 4.0?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to access count property of a dynamic type in C# 4.0?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou should **strongly** consider creating *real* types instead of anonymous types and return an `IEnumerable` of that. Using dynamic for this purpose annihilates all the advantages of static typing.
      singulars
      1. POHow to access count property of a dynamic type in C# 4.0?
      1. USKirk Woll
    2. CO@Kirk Reports could be dynamic? not exactly in this case but still
      singulars
      1. POHow to access count property of a dynamic type in C# 4.0?
      1. USBas
    3. COWhen you're defining a one-off type just to pass back from a method, there are very few, if any advantages to static typing.
      singulars
      1. POHow to access count property of a dynamic type in C# 4.0?
      1. USmquander
 

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