Convert SQL to LINQ (with case expression)
01:10 13 Nov 2020

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
c# linq