BolfTracker.Infrastructure.EntityFramework.GameRepository.GetAllFinalized C# (CSharp) Метод

        public IEnumerable<Game> GetAllFinalized()
        {
            using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
            {
                connection.Open();

                string query = "SELECT g.* FROM Game g INNER JOIN GameStatistics gs ON gs.GameId = g.Id";

                var games = connection.Query<Game>(query).ToList();

                return games;
            }
        }