/// <summary> /// /// </summary> /// <returns></returns> private static TeamList GetTeams() { TeamList list = new TeamList(); using( DBCommand cmd = new DBCommand( Con, CommandType.StoredProcedure ) ) { cmd.CommandText = "GetTeams"; while( cmd.Read() ) { list.AddDistinct( new Team { ID = cmd.GetInt( "Team_ID" ), Name = cmd.GetString( "Name" ) } ); } } return list; }