asp.net mvc - Retrieving associated elements based on ID in entity query -


i have entity query groups number of property reviews property. im having trouble query pull rest of data on property based on propertyid. thanks!

example results:

|propertyid | numofreviews |     streetaddress     |    city    |       1             14             1600 speaker st.        miami 

query:

var query1 = r in db.reviews                     group r r.propertyid g                     select new                     {                         propertyid = g.key,                         numofreviews = g.count()                         //get rest of data                     }; 

property model:

 public partial class property {             public int propertyid { get; set; }     public string streetaddress { get; set; }     public string city { get; set; }     public string zip { get; set; }     public string state { get; set; }     public string country { get; set; }     public string route { get; set; }      public virtual icollection<review> reviews { get; set; } } 

review model:

  public partial class review {     public int reviewid { get; set; }     public int propertyid { get; set; }     public int rating { get; set; }     public string review { get; set; }         public virtual property property { get; set; } } 

can come @ opposite direction?

var query = p in db.properties             select new {                 propertyid = p.propertyid,                 numofreviews = p.reviews.count()                 //grab remaining properties off of p variable need             }; 

Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -