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; } } |