Linq support for a single result

Is the following the best way of getting a single result:

Site thisSite = (from site in Query<site>.All where site.OldSiteId == 13 select site).First<site>();

You do not appear to support "Single" ?

Tony Steele NeighbourNet Ltd

This thread was imported from our support forum. The original discussion may contain more detailed answer. Original topic by Anonymous.

DataObjects.Net

asked Jul 28 '09 at 00:15

Editor
46●156●156●157

No, we do. Single must work, there are even special tests for this. I remember we did a lot to support this construct in subqueries (really non-trivial, e.g. EF does not support this).

To be checked.

(Jul 28 '09 at 00:15) Alex Yakunin

One Answer:

oldest newest most voted

Try the following queries (they are same): Site thisSite = (from site in Query<site>.All where site.OldSiteId == 13 select site).Single(); Site thisSite = Query<site>.All.Where(site => site.OldSiteId == 13).Single(); Site thisSite = Query<site>.All.Single(site => site.OldSiteId == 13);

The following exceptions may occur during execution of 'Single' method:

System.InvalidOperationException: Sequence contains more than one element. - when more than one element returned by query
System.InvalidOperationException: Sequence contains no elements. - no element returned at all.

answered Jul 28 '09 at 05:52

Editor
46●156●156●157

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

DataObjects.Net ×574

Asked: Jul 28 '09 at 00:15

Seen: 2,660 times

Last updated: Jul 28 '09 at 00:15

Subscription:

Related questions