translating a SQL query into a LINQ to SQL query

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]

Jeff Mercado · Accepted Answer · 2011-02-25 06:51:24Z

2

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

answered Feb 25, 2011 at 6:51

Jeff Mercado

136k34 gold badges267 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bonshington · Accepted Answer · 2011-02-25 06:52:05Z

0

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

answered Feb 25, 2011 at 6:52

Bonshington

4,0622 gold badges29 silver badges20 bronze badges

Collectives™ on Stack Overflow

translating a SQL query into a LINQ to SQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related