title: System.Data.Entity.DbSet cannot be called with instance of type System.Data.Entity.Core.Objects.ObjectQuery
body: <p>I'm getting the following error when trying to call the list method</p>
  
  <p>Additional information: Method 'GRCWebApp.Models.Day Find(System.Object[])' declared on type 'System.Data.Entity.DbSet<code>1[GRCWebApp.Models.Day]' cannot be called with instance of type 'System.Data.Entity.Core.Objects.ObjectQuery</code>1[GRCWebApp.Models.Day]'</p>
  
  <p>The Controller is</p>
  
  <pre><code>        public ActionResult ListClubMembershipType(int clubId)
      {
          //Populate the list
          var types = from s in db.MembershipTypes
                      where (s.ClubId == clubId)
                      orderby s.Type
                      select s;
          ViewBag.typesCount = types.Count();
          var model = types.Select(t =&gt; new ListMembershipTypeViewModel            
      {
          Type = t.Type,
          ClubId = clubId,
          Cost = t.Cost,
          ReducedCost = t.ReducedCost,
          ReducedDate = db.Days.Find(t.DayId).DayNum + "/" + db.Months.Find(t.MonthId).MonthName,
          MinAge = t.MinAge,
          MaxAge = t.MaxAge,
      });
  
          return PartialView("_ListClubMembershipType", model);
      }
  </code></pre>
  
  <p>and the error is on the ReducedDate line</p>
  
  <p>The Day Model is:</p>
  
  <pre><code>public class Day
  {
      public int DayId { get; set; }
  
      [Column(TypeName = "int")]
      public int DayNum { get; set; }
  
      public virtual ICollection&lt;MembershipType&gt; MembershipTypes { get; set; }
  }
  </code></pre>
  
  <p>The Month Model is:</p>
  
  <pre><code>    public class Month
  {
      public int MonthId { get; set; }
  
      [Column(TypeName = "nvarchar")]
      public String MonthName { get; set; }
  
      public virtual ICollection&lt;MembershipType&gt; MembershipTypes { get; set; }
  }
  </code></pre>
  
  <p>The MembershipType Model is:</p>
  
  <pre><code>        public int MembershipTypeId { get; set; }
  
      [StringLength(150)]
      [Column(TypeName = "nvarchar")]
      public String Type { get; set; }
  
      [StringLength(350)]
      [Column(TypeName = "nvarchar")]
      public String Description { get; set; }
  
      [Column(TypeName = "int")]
      public int ClubId { get; set; }
  
      [Column(TypeName = "decimal")]
      public Decimal Cost { get; set; }
  
      [Column(TypeName = "decimal")]
      public Decimal ReducedCost { get; set; }
  
      [Column(TypeName = "int")]
      public int? DayId { get; set; }
  
      [Column(TypeName = "int")]
      public int? MonthId { get; set; }
  
      [Column(TypeName = "int")]
      public int MinAge { get; set; }
  
      [Column(TypeName = "int")]
      public int MaxAge { get; set; }
  
      [Column(TypeName = "bit")]
      public bool? Dormant { get; set; }
  }
  </code></pre>
  
  <p>The ViewModel Is:</p>
  
  <pre><code>    public class ListMembershipTypeViewModel
  {
      [Display(Name = "Type")]
      public String Type { get; set; }
  
      public int ClubId { get; set; }
  
      [Display(Name = "Full Cost")]
      public Decimal Cost { get; set; }
  
      [Display(Name = "Reduced Cost")]
      public Decimal ReducedCost { get; set; }
  
      [Display(Name = "Reduced From")]
      public string ReducedDate { get; set; }
  
      [Display(Name = "Min Age")]
      public int MinAge { get; set; }
  
      [Display(Name = "Max Age")]
      public int MaxAge { get; set; }
  }
  </code></pre>
  
  <p>I'm trying to combine the values from two other table to make up a string that shows the day number and the month word</p>
  
  <p>Ive tried adding the ToString but that generates the same error</p>