SQL to LINQ query conversion issue.

Question

0.00/5 (No votes)

See more:

I am a new one to LINQ and EF and trying to convert a query into LINQ.But unable to get it.

SQL

select  TU.username, TU.email, TL.Logid from TBL_A TU
left join  TBL_B TL on tu.userid = TL.userid
 where TU.teamid = 1001
 and Convert(Date,TL.logindt) = Convert(Date,getdate())
 and logid not in (select logid from  TBL_C where scheduleid = 8)

I have tried different approaches,

Tried to divide the query in subqueries and so on,, but unable to succeed.

ANy help would be appreciated.

Posted 22-May-14 2:32am

VICK

Add a Solution

1 solution

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)

Kumar Prateek · Answer 1 · 2014-05-22T02:55:00

Solution 1

Can you try the below LINQ query.

Hope that this one helps you out...
You might be needed to check the WHERE clause.

var query =( from TU in TBL_A 
	  join TL in TBL_B on  TU.userid equals TL.userid
	  where TU.teamid = 1001
	  select new 
	  {
		TU.username, 
		TU.email, 
		TL.Logid
	  }).ToList();

Posted 22-May-14 2:55am

Kumar Prateek

Comments

VICK 22-May-14 23:59pm

You have just wrote the respective LINQ for the first part of query.. remaining 2 are still to be implemented and are actually the problematic part for me... :(

and secondly you missed the second where clause as well.. i.e.

and Convert(Date,TL.logindt) = Convert(Date,getdate())

Kumar Prateek 3-Jun-14 10:07am

Do let us know your solution for the same.
And I have already specified that you need to check the where clause which can be done very easily with the .net libraries.