private static void AddTeamToLeague(FootballContext context, Team team, League league) { if (league != null) { if (team.Leagues.Contains(league)) { Console.WriteLine("Existing team in league: {0} belongs to {1}", team.TeamName, league.LeagueName); } else { team.Leagues.Add(league); context.SaveChanges(); Console.WriteLine("Added team to league: {0} to league {1}", team.TeamName, league.LeagueName); } } }
private static void CreateTeamsIfNotExists( FootballContext context, IEnumerable<XElement> xTeams, League league) { foreach (var xTeam in xTeams) { // Find the team by team name and country name (if exists) var teamName = xTeam.Attribute("name").Value; var xCountry = xTeam.Attribute("country"); string countryName = null; if (xCountry != null) { countryName = xCountry.Value; } var team = context.Teams .Include(t => t.Leagues) .FirstOrDefault( t => t.TeamName == teamName && t.Country.CountryName == countryName); // Create the team if it does not exists if (team != null) { Console.WriteLine("Existing team: {0} ({1})", team.TeamName, countryName ?? "no country"); } else { // Create a new team in the DB team = new Team() { TeamName = teamName, Country = context.Countries.FirstOrDefault( c => c.CountryName == countryName), }; context.Teams.Add(team); context.SaveChanges(); Console.WriteLine("Created team: {0} ({1})", team.TeamName, countryName ?? "no country"); } AddTeamToLeague(context, team, league); } }
private static League CreateLeagueIfNotExists(FootballContext context, XElement xLeague) { League league = null; var xElementLeagueName = xLeague.Element("league-name"); if (xElementLeagueName != null) { string leagueName = xElementLeagueName.Value; league = context.Leagues.FirstOrDefault(l => l.LeagueName == leagueName); if (league != null) { Console.WriteLine("Existing league: {0}", leagueName); } else { // Create a new league in the DB league = new League() { LeagueName = leagueName }; context.Leagues.Add(league); context.SaveChanges(); Console.WriteLine("Created league: {0}", leagueName); } } return league; }