public static IEnumerable <Match> MatchByName() { using (var conn2 = new SQLite.SQLiteConnection(teamsDatabase)) { IEnumerable <Match> matches = MatchRepository.SelectAll(data); foreach (var joined in from match in matches join result in Temp.Repo.GetResult() on match.EventId equals result.result.Id where result.result.HasResult where result.team1.Name == match.GetHomeTeam() where result.team2.Name == match.GetAwayTeam() select(match, result.result)) { joined.match.HomeScore = joined.result.Team1FullTimeScore; joined.match.AwayScore = joined.result.Team2FullTimeScore; yield return(joined.match); } } }
public static IEnumerable <Match> MatchDefault() { using (var conn2 = new SQLite.SQLiteConnection(teamsDatabase)) { var conn = MatchRepository.SelectAll(data).Batch(100); var results = conn2.Table <Entity.Temp.Result>().ToList().ToArray(); foreach (var batch in conn) { foreach (var ty in from result in results where result.HasResult join match in batch on result.Id equals match.EventId select new { match, result }) { ty.match.HomeScore = ty.result.Team1FullTimeScore; ty.match.AwayScore = ty.result.Team2FullTimeScore; yield return(ty.match); } } } }