ASP.ET MVC 4 to view data from several tables ViewBag

Question

I need to output information from two tables

public class Team
{
    [Key]
    public int TeamId { get; set; } 
    public int TypeId { get; set; }
    public string TeamName { get; set; }


}public class TeamType
{
    [Key]
    public int TypeId { get; set; }
    public string TypeName { get; set; }

    public virtual ICollection<Team> Teams { get; set; } 
}

I build this class

public abstract class MyAppController : Controller
{
    //
    // GET: /MyApp/
    private RenegadeEntities db = new RenegadeEntities();

    public RenegadeEntities DataContext
    {
        get { return db; }
    }

    public MyAppController()
    {
        ViewBag.TeamList = db.TeamTypes.Include("Teams").ToList();
    }
}

in view i do following:

@using Renegades.Helpers
@model IEnumerable<Renegades.Models.TeamType>
@foreach (var t in ViewBag.TeamList)
                            {
                                <li>
                                    <span>@t.TypeName</span>
                                    <ul id="sub_team_menu">
                                     @foreach (var team in t.Team)
                                     {
                                         <li>team.TeamName</li>
                                     }
                                    </ul>
                                </li>
                            }

Please help me to understand how can i output data from two or more tables in my view

Answer 1

If tables are connected to each other through foreign key like in your case then you can use other table as property. Like TeamType.Teams. But I see that you are not referencing the TeamType in your Team class.

Edit your class like:

public class Team
{
    [Key]
    public int TeamId { get; set; } 
    public int TypeId { get; set; }
    public string TeamName { get; set; }
    public virtual TeamType Type{get;set;}  // Add this to your class
}

Then use Team.Type to access Type table as property. Like:

 @foreach (var team in t.Team)
{
    <li>team.Type.TypeName</li>
}

But if the tables are not connected to each other then simplest answer is you have to create ViewModel for that. Now what is a ViewModel, that is not so simple, To study about ViewModel follow the link :

http://www.codeproject.com/Articles/687061/Using-Multiple-Models-in-a-View-in-ASP-NET-MVC-4

Here is another more simpler link:

http://sampathloku.blogspot.ae/2012/10/how-to-use-viewmodel-with-aspnet-mvc.html