Sort (Order) List by alphabetically using Linq query in ASP.Net

Hi Richa,

I have checked the linq query. Its returning result correctly.

Please verify the result in the database aswell.

SQL

SELECT DISTINCT 
	w.scenario_id 'ScenarioId',
	w.scenario_displayId + ' | ' + w.scenario_name 'ScenarioName',
	w.scenario_name
FROM mapping_details x
INNER JOIN hdr_fdp_scenarios w
ON x.fdp_scenario = w.combined_name
ORDER BY w.scenario_name

If you want to show order by after merging the columns scenario_displayId and scenario_name then use below code.

var data = (from x in _repository.GetAllMappingDetails().ToList()
           join w in _repository.GetScenarioDDL().ToList() on x.FdpScenario equals w.CombinedName
           where w.StudyId == selectedStudyId
           orderby w.ScenarioName
           select new
           {
               ScenarioId = w.ScenarioId,
               ScenarioName = w.ScenarioDisplayId + " | " + w.ScenarioName
           }).Distinct().OrderBy(x=>x.ScenarioName).ToList();