Converting SQL to Linq

Question

1.00/5 (3 votes)

See more:

SQL

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

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

Posted 23-Jul-13 6:08am

TryAndSucceed

Updated 23-Jul-13 6:33am

v5

Add a Solution

Comments

joshrduncan2012 23-Jul-13 12:30pm

What's your question?

ZurdoDev 23-Jul-13 12:39pm

Have you learned LINQ at all?

TryAndSucceed 23-Jul-13 12:42pm

I am a beginner and mostly have been working on the Linq queries to just retrieve data but not manipulation in the queries. I have searched for this and there are ways that is SQLMethods.DateDiffHour for getting difference in hours,but I am confused in placing them around in query.

2 solutions

Solution 2

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

Posted 25-Jul-13 19:07pm

RomilGandhi

Comments

Sushil Mate 26-Jul-13 1:40am

wrong place, use comment/question section widget.

RomilGandhi 26-Jul-13 1:44am

ok thanx

TryAndSucceed 31-Jul-13 11:43am

Thanks Romil. I found solution. I created a separate method to do what it was doing in the query.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ExcelledProducts CEO · Accepted Answer · 2013-07-23T08:20:00

Solution 1

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.

Posted 23-Jul-13 8:20am

ExcelledProducts CEO

Comments

TryAndSucceed 23-Jul-13 15:20pm

It helped a bit as it says that Floor and DateDiff are not supported by Linq to convert.

[no name] 23-Jul-13 18:39pm

@Faraaz Habeeb - well that just means that you will need to find a different way to do it try looking up "LINQ equivalent to SQL Floor" and "LINQ equivalent to SQL DateDiff"