I am asked to save and output a tournament bracket, like NCAA or US Open, two parties play and the winner move on to next round. To display the whole bracket, I need to find a way to maintain the hierarchy, say I have the following class:
public class Contest
public int ContestantId1;
public int ContestantId2;
public int RoundNumber;
This is good for a single contest inside the tournament, but how do I change the class or use other classes to support hierarchy?
Also if possible can someone show me the best way to model this in SQL server tables?
View Complete Post