Question

How can I write this query using LINQ?

SELECT CAST(CASE WHEN [IsForReplication] = 1  THEN  Yes  
                   ELSE  No  END AS NCHAR) as [IsForReplication], * 
FROM [SAN].[dbo].[PolicyInterval]

Answer 1

var query = from pi in context.PolicyInterval
            let IsForReplication = pi.IsForReplication ? "Yes" : "No"
            select new
            {
                IsForReplication,
                PolicyInterval = pi,
            };

Answer 2

var result = PolicyInterval.Select(entry => new {IsForReplication = entry.IsForReplication.Equals(1).ToString(), data = entry});

友情链接