Convert SQL to LINQ (with case expression)
How to convert LINQ from SQL query with a case expression.
CASE WHEN c.[Candidate_CreateBy] LIKE 'A%'
THEN (
SELECT [Admin_Name]
FROM [dbo].[Admin] a
WHERE c.Candidate_CreateBy = a.Admin_Id
)
ELSE c.[Candidate_Name]
END AS "name"
FROM [dbo].[Candidate] c