static void Main() { var db = new FootballEntities(); var temNames = db.Teams.Select(t => t.TeamName).ToList(); foreach (var temName in temNames) { Console.WriteLine(temName); } }
static void Main(string[] args) { var context = new FootballEntities(); var internationalMatches = context.InternationalMatches .OrderBy(i => i.MatchDate) .ThenBy(i => i.CountryHome.CountryName) .ThenBy(i => i.CountryAway.CountryName) .Select(i => new { homeCountry = i.CountryHome.CountryName, awayCountry = i.CountryAway.CountryName, homeCountryCode = i.CountryHome.CountryCode, awayCountryCode = i.CountryAway.CountryCode, league = i.League.LeagueName, matchDate = i.MatchDate, homeScore = i.HomeGoals, awayScore = i.AwayGoals }).ToList(); var root = new XElement("matches"); foreach (var internationalMatch in internationalMatches) { var matchNode = new XElement("match"); if (internationalMatch.matchDate != null) { if (internationalMatch.matchDate.Value.TimeOfDay.TotalSeconds == 0) { var date = internationalMatch.matchDate.Value.ToString("dd-MMM-yyyy"); matchNode.Add(new XAttribute("date", date)); } else { var date = internationalMatch.matchDate.Value.ToString("dd-MMM-yyyy hh:mm"); matchNode.Add(new XAttribute("date-time", date)); } } matchNode.Add(new XElement("home-country", internationalMatch.homeCountry, new XAttribute("code", internationalMatch.homeCountryCode))); matchNode.Add(new XElement("away-country", internationalMatch.awayCountry, new XAttribute("code", internationalMatch.awayCountryCode))); if (internationalMatch.league != null) { matchNode.Add(new XElement("league", internationalMatch.league)); } if (internationalMatch.homeScore != null && internationalMatch.awayScore != null) { matchNode.Add(new XElement("score", internationalMatch.homeScore + "-" + internationalMatch.awayScore)); } root.Add(matchNode); } var xmlDoc = new XDocument(root); xmlDoc.Save("../../international-matches.xml"); }
static void Main() { var context = new FootballEntities(); var leagues = context.Leagues .OrderBy(l => l.LeagueName) .Select(l => new { leagueName = l.LeagueName, teams = l.Teams.OrderBy(t => t.TeamName).Select(t => t.TeamName) }).ToList(); var initializer = new JavaScriptSerializer(); var json = initializer.Serialize(leagues); File.WriteAllText("../../leagues-and-teams.json", json); }
static void Main() { var context = new FootballEntities(); var xmlDoc = XDocument.Load("../../leagues-and-teams.xml"); var node = xmlDoc.XPathSelectElements("/leagues-and-teams/league"); var processing = 1; foreach (var element in node) { Console.WriteLine("Processing league #{0}...", processing++); var league = new League(); if (element.Element("league-name") != null) { var leagueName = element.Element("league-name").Value; if (!context.Leagues.Any(l => l.LeagueName == leagueName)) { league = new League() { LeagueName = leagueName }; context.Leagues.Add(league); Console.WriteLine("Created league: " + leagueName); } else { Console.WriteLine("Existing league: " + leagueName); } } var teams = element.XPathSelectElements("teams/team"); foreach (var team in teams) { if (team.Attribute("name") != null) { var currTeam = new Team(); var teamName = team.Attribute("name").Value; string countryName = null; if (team.Attribute("country") != null) { countryName = team.Attribute("country").Value; } if (!context.Teams.Any(l => l.TeamName == teamName)) { currTeam = new Team() { TeamName = teamName, Country = context.Countries.FirstOrDefault(c => c.CountryName == countryName) }; context.Teams.Add(currTeam); Console.WriteLine("Created team: New {0} ({1})", teamName, countryName??"no country"); } else { Console.WriteLine("Existing team: {0} ({1})", teamName, countryName); } if (league != null) { if (currTeam.Leagues.Contains(league)) { Console.WriteLine("Existing team in league: {0} to {1}", teamName, league.LeagueName); } else { Console.WriteLine("Added team to league: {0} to {1}", teamName, league.LeagueName); } } } } Console.WriteLine(); } }