Create a ViewModel that contains all the required content for this page. In this case a ViewModel with a Tournament and List of PlayRoundHoles
public class MyViewModel
{
public Tournament MyTournament { get; set; }
public IList<PlayRoundHoles> MyPlayRoundHoles { get; set; }
}
Then your action method should return this strongly-viewed type.
public class TournamentController
{
public ActionResult View(int tournamentId)
{
var t = //get tournament
var p = //call sproc (may use the tournament id)
MyViewModel model = new MyViewModel();
model.MyTournament = t;
model.MyPlayRoundHoles = p;
return View(model);
}
}
Your View can then look something like
<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<MyViewModel>" %>
//tournament details using Model.MyTournament
//play round holes details using Model.MyPlayRoundHoles
To improve on this you could create a PartialView that seperates the display of your PlayRoundHoles
<% Html.RenderPartial("MyPlayRoundHoles", Model.MyPlayRoundHoles); %>