Attribute Missing from linq query result

Question

0.00/5 (No votes)

See more:

Please find below the linq query

C#

var result = (from sd in students
                              select sd.Student_ID).Except(from m in query1
                                                          select m.Student_ID).ToList();

from this query I am getting the exact results. Now I want to populate other data of students so what I have done is wrote other linq query. Below here, But I am not getting r.Student_ID attribute to compare with students table. Intellisense not giving r.Student_ID. Please help!

C#

var finalResult = (from sd in dbcDefaulter.Student_Details
                               from r in list where r == sd.Student_ID
                               orderby sd.Student_ID
                               select new { sd.Student_ID, sd.Name, sd.Class, sd.Section, sd.F_Name, sd.F_Mobile }).Distinct().ToList();

Posted 20-Sep-14 0:25am

SandeepKushwah

Updated 20-Sep-14 0:26am

v2

Add a Solution

Comments

SandeepKushwah 20-Sep-14 13:00pm

Any One there to help on it?

Jameel VM 21-Sep-14 3:06am

why you are not try to join the two collection?

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)

Raul Iloc · Answer 1 · 2014-09-20T21:16:00

1.You should declare your first LINQ expression, but not to execute it, like below:

C#

var firstQuery= from sd in students
                                from m in query1
                                where sd.Student_ID != m.Student_ID 
                              select sd.Student_ID;

2.Then use the above first query in the second one like below:

C#

var finalResult = (from sd in dbcDefaulter.Student_Details
                                  from r in firstQuery where r.Student_ID == sd.Student_ID
                                  orderby sd.Student_ID
                                  select new { sd.Student_ID, sd.Name, sd.Class, sd.Section, sd.F_Name, sd.F_Mobile }).Distinct().ToList();