Missing column from Sql Generated

[Manmeetsm]

EF core 2.1.1 is generating incorrect SQL for order by columns.

await context.IndustryType
  .OrderBy(x => x.Name)
  .Select(x => new LookupValue { Id = x.IndustryTypeId, Text = x.Name, Code = x.Name })
  .ToListAsync();

Generates : -

SELECT [e].[IndustryTypeId] AS [Id], [e].[Name] AS [Code] ## Missing Text Alias ##
FROM [IndustryType] AS [e]
ORDER BY [Text] 

It should be

SELECT [e].[IndustryTypeId] AS [Id], 
[e].[Name] AS [Text],  # This is Missing #
[e].[Name] AS [Code] 
FROM [IndustryType] AS [e]
ORDER BY [Text] 

[smitpatel]

Duplicate of #12180