public static List<ContestTeamMember> GetTeamMembersFromTeamId(int teamId)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return (from c in data.TeamMemberDataProviders
where c.team_id == teamId
select
new ContestTeamMember
{
Score = (float)c.score,
Initialized = c.initialized,
InitialScore = (float)c.initial_score,
UserId = c.user_id
}).ToList();
}
}