LINQ query using lambda expression

Question

I have this linq query, which is working fine, but I want to make it shorter by using a lambda expression. Any suggestions or examples might help.

selectedPersons = (from d in entities.PERSONS_DATA
                   where d.PERSON_ID == pid
                   select d).First();

I disagree. I believe the below is more readable. This is more of a preference than fact. — drizzie
– drizzie, Commented Feb 4, 2016 at 3:33

Chris Van Opstal · Accepted Answer · 2016-02-04 03:39:39Z

2

selectedPersons = entities.PERSONS_DATA.First (d => d.PERSON_ID == pid);

Chris Van Opstal

37.7k10 gold badges77 silver badges91 bronze badges

answered Feb 4, 2016 at 3:31

drizzie

3,3612 gold badges30 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

why single? why not first?

You are correct, it should be first. Updated answer.

Thank you so much...didn't thought it would be this simple :)

JBrooks · Accepted Answer · 2016-02-04 03:43:59Z

0

If you can use:

electedPersons = entities.PERSONS_DATA.Find(pid);

If there is a chance the pid might not match a row the First will throw an exception. So in this case use:

electedPersons = entities.PERSONS_DATA.FirstOrDefault(d => d.PERSON_ID == pid);

if(electedPersons != null)
   ....

answered Feb 4, 2016 at 3:43

JBrooks

10k2 gold badges31 silver badges32 bronze badges