将SQL转换为Linq [英] Converting SQL to Linq

问题描述

select dayofweek, application, SystemOutageFrom,
Case when (DateDiff(hour, b.SystemOutageFrom, b.SystemOutageTo) < 0) then DateAdd(day, 1, b.SystemOutageTo)
else b.SystemOutageTo end as SystemOutageTo from (
select dayofweek, application, DateAdd(day, (dayofweek + 1 - DATEPART(weekday, GetDate())), 
(Cast (SystemOutageFrom as datetime) + CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME))) as SystemOutageFrom,
DateAdd(day, (dayofweek + 1 - DATEPART(weekday, GetDate())),
(Cast (SystemOutageTo as datetime) + CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)) ) as SystemOutageTo
from weeklyoutage ) b  order by dayofweek, b.SystemOutageFrom

我的问题是如何在Linq中放入这个复杂的查询？任何想法都会有所帮助。

My question is how do I put this complex query in Linq? Any ideas to start will be helpful.

推荐答案

您可以尝试http://www.sqltolinq.com/。我没有你的数据库所以我无法测试它，但你可以下载试用10天并测试它。

You can try http://www.sqltolinq.com/. I don't have your database so I can not test it but you can download the trial for 10 days and test it.

Can you please give detailed question ,table names and all that so i can help you

这篇关于将SQL转换为Linq的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！