Entity Framework – Dynamic LINQ – Where Query on Child Item

Entity Framework – Dynamic LINQ – Where Query on Child Item

 
   using System;
   using System.Collections.Generic;
   using System.Linq;
   using System.Linq.Dynamic;
   using DAO;
 
   namespace DynamicLINQTest
   {
     class Program
     {
       static void Main(string[] args)
       {
         string wherequery = "PLAYER.Any(PLAYER_NAME.Contains(@0))";
 
         List<TEAM> list = getList(wherequery, "Cristiano");
 
         foreach (var team in list)
         {
           Console.WriteLine(team.TEAM_NAME);
 
           foreach(var player in item.PLAYER)
           {
             Console.WriteLine(player.PLAYER_NAME);
           }
 
           Console.WriteLine("");
         }
 
         Console.ReadLine();
       }
 
       static List<TEAM> getTeamList(string wherequery, params string[] value)
       {
         Soccer soccercontext = new Soccer();
 
         return soccercontext.TEAM.Where(wherequery, value).ToList();
       }
     }
   }