score:191

Accepted answer

depends how much you like the linq query syntax, you can use the extension methods directly like:

var item = items.first(i => i.id == 123);

and if you don't want to throw an error if the list is empty, use firstordefault which returns the default value for the element type (null for reference types):

var item = items.firstordefault(i => i.id == 123);

if (item != null)
{
    // found it
}

single() and singleordefault() can also be used, but if you are reading from a database or something that already guarantees uniqueness i wouldn't bother as it has to scan the list to see if there's any duplicates and throws. first() and firstordefault() stop on the first match, so they are more efficient.

of the first() and single() family, here's where they throw:

  • first() - throws if empty/not found, does not throw if duplicate
  • firstordefault() - returns default if empty/not found, does not throw if duplicate
  • single() - throws if empty/not found, throws if duplicate exists
  • singleordefault() - returns default if empty/not found, throws if duplicate exists

score:2

i'll tell you what worked for me:

int id = int.parse(insertitem.ownertableview.datakeyvalues[insertitem.itemindex]["id_usuario"].tostring());

var query = user.first(x => x.id_usuario == id);
tbusername.text = query.username;
tbemail.text = query.email;
tbpassword.text = query.password;

my id is the row i want to query, in this case i got it from a radgrid, then i used it to query, but this query returns a row, then you can assign the values you got from the query to textbox, or anything, i had to assign those to textbox.

score:4

you could use the extension method syntax:

var item = items.select(x => x.id == 123).firstordefault();

other than that, i'm not sure how much more concise you can get, without maybe writing your own specialized "first" and "firstordefault" extension methods.

score:9

that can better be condensed down to this.

var item = items.first(x => x.id == 123);

your query is currently collecting all results (and there may be more than one) within the enumerable and then taking the first one from that set, doing more work than necessary.

single/singleordefault are worthwhile, but only if you want to iterate through the entire collection and verify that the match is unique in addition to selecting that match. first/firstordefault will just take the first match and leave, regardless of how many duplicates actually exist.

score:13

these are the preferred methods:

var item = items.singleordefault(x => x.id == 123);

or

var item = items.single(x => x.id == 123);

score:13

just to make someone's life easier, the linq query with lambda expression 

(from x in items where x.id == 123 select x).firstordefault();

does result in an sql query with a select top (1) in it.

score:19

firstordefault or singleordefault might be useful, depending on your scenario, and whether you want to handle there being zero or more than one matches:

firstordefault: returns the first element of a sequence, or a default value if no element is found.

singleordefault: returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence

i don't know how this works in a linq 'from' query but in lambda syntax it looks like this:

var item1 = items.firstordefault(x => x.id == 123);
var item2 = items.singleordefault(x => x.id == 123);

Related Query

More Query from same tag