Listbox control in MVC with Entity Framework

Question

I am very new in Entity Framework here and try to create a simple listbox control but the listbox comes out empty. Please help and tell me what I did wrong here.

DAL (Entity Framework):

namespace DataAccess
{
using System;
using System.Collections.Generic;

public partial class Client
{
    public Client()
    {
        this.AnotoPGCFiles = new HashSet<AnotoPGCFile>();
        this.Client1 = new HashSet<Client>();
        this.Client11 = new HashSet<Client>();
        this.ClientBillingSetups = new HashSet<ClientBillingSetup>();
        this.ClientDataStores = new HashSet<ClientDataStore>();
        this.ClientDepartments = new HashSet<ClientDepartment>();
        this.ClientFileNames = new HashSet<ClientFileName>();
        this.ClientReports = new HashSet<ClientReport>();
    }

    public int ID { get; set; }
    public string Name { get; set; }
    public string ContactName { get; set; }
    public string ContactEmail { get; set; }
    public string PathToLogo { get; set; }
    public bool Disabled { get; set; }
    public System.DateTime Created { get; set; }
    public int TimeZoneID { get; set; }

    public virtual AnotoLicensePool AnotoLicensePool { get; set; }
    public virtual ICollection<AnotoPGCFile> AnotoPGCFiles { get; set; }
    public virtual ICollection<Client> Client1 { get; set; }
    public virtual Client Client2 { get; set; }
    public virtual ExternalSystemDemographicConfiguration  ExternalSystemDemographicConfiguration { get; set; }
    public virtual ICollection<Client> Client11 { get; set; }
    public virtual Client Client3 { get; set; }
    public virtual TimeZone TimeZone { get; set; }        
 }
}

Controller:

public ActionResult Index()
 {
  ViewData["ReportFormat"] = "html";
  ViewBag.Title = "Home Page";

  var db = new DataAccess.Client();
  IEnumerable<SelectListItem> clients = db.Client1
        .Select(c => new SelectListItem
        {
              Value = c.ID.ToString(),
              Text = c.Name
        });

  ViewBag.Clients = clients;
  return View();
 }

View:

@Html.ListBox("ListClients", (IEnumerable<SelectListItem>) ViewBag.Clients)

Check your code that fills data into Client1 collection. Place a breakpoint at the statement that selects values into this collection and check if the values are getting filled. Also, check the query that is hit to backend using SQL Server profiler. Examine the query to find out what is going wrong. — S. Ravi Kiran
– S. Ravi Kiran, Commented Jan 24, 2013 at 13:03

Honorable Chow · Accepted Answer · 2013-01-24 17:43:19Z

1

You need to ToList() that query to resolve it. Doing the select doesn't resolve the expression.

ViewBag.Clients = clients.ToList();

answered Jan 24, 2013 at 17:43

Honorable Chow

3,1833 gold badges26 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Listbox control in MVC with Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related