Entity Framework – Raw SQL Queries for the Complicated Query & Return To List

Entity Framework – Raw SQL Queries for the Complicated Query & Return To List

 
   public List<PlayerDetail> getPlayerDetail()
   {
      return context.Database.SqlQuery<PlayerDetail>(
               @"SELECT [dbo].[PLAYER].[PLAYER_ID] AS PLAYER_ID
               ,[dbo].[PLAYER].[PLAYER_NAME] AS PLAYER_NAME
               ,[dbo].[NATION].[NATION_NAME] AS PLAYER_NATION
               ,[dbo].[TEAM].[TEAM_NAME] AS PLAYER_TEAM
               FROM [dbo].[PLAYER]
               LEFT JOIN [dbo].[NATION]
               ON [dbo].[PLAYER].[PLAYER_NATION] = [dbo].[NATION].[NATION_ID]
               LEFT JOIN [dbo].[TEAM]
               ON [dbo].[PLAYER].[PLAYER_TEAM] = [dbo].[TEAM].[TEAM_ID]
               ORDER BY [dbo].[PLAYER].[PLAYER_ID]"
      ).ToList();
   }
 
   public class PlayerDetail
   {
      public Int32 PLAYER_ID { get; set; }
      public string PLAYER_NAME { get; set; }
      public string PLAYER_NATION { get; set; }
      public string PLAYER_TEAM { get; set; }
   }