Stack Overflow en español Asked by user180658 on December 2, 2021
alguien sabe como puedo traducir la siguiente consulta MySQL a LINQ para poder utilizarlo con Entity Framework 5.0 (Desde ya agradezco cualquier ayuda que puedan brindarme)
select case when T.Count1 >= T.CountO then MaxValue1
when T.Count1 = 0 and T.CountO > 0 then MinValue0
end
from ( select count(case when Status = 0 then 1 else NULL end) as Count0,
count(case when Status = 1 then 1 else NULL end) as Count1,
max(case when Status = 1 then Value else NULL end) as MaxValue1,
min(case when Status = 0 then Value else NULL end) as MinValue0
from TuTabla
) AS T
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP