TransWikia.com

Convertir MySQL a LINQ (Entity Framework 5)

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP