SQL query on Entity Framework

Question

How do I do this sql query to entity framework?

select 
id,
column1,
column2 =  case when (select max(column2) from table1 b where b.id = a.id) = a.column2 
then 'Positive' else 'Negative' end
from table1 a

Do you mean how to write it into Linq To Entities or do you want to execute this sql command though DbContext? — dvjanm
– dvjanm, Commented Oct 19, 2013 at 18:36
Sorry, but I just read the sql command and I have some notification. (select max(column2) from table1 b where b.id = a.id). Beacuse of the where caluse it will always have one record in result. So the column2 always 'Positive'. (if id is really primary key as I expected) — dvjanm
– dvjanm, Commented Oct 20, 2013 at 8:04

Alireza · Accepted Answer · 2013-10-19 18:34:17Z

1

var query = from t in context.table1
            let column2_temp = context.table1.Where(p=>p.id==t.id).Max(p=>p.column2)
            let column2 = column2_temp == t.column2? "Positive" : "Negative"
            select new {t.id, column2}

answered Oct 19, 2013 at 18:34

Alireza

10.5k6 gold badges46 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

SQL query on Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related