CODEWITHSUNDEEP
asp.netasp.net-mvclinqlinq-to-sql
Mike
Mike

Reputation: 2922

Returning a single value with Linq to SQL

I'm learning Linq to SQL and I'm having trouble grasping it. I'm trying to simply return a single (boolean) value in C# with a Linq query.

I want to see if the owner of a story would like an email notification sent when new comments are added. I would like the method that contains the Linq to SQL to return a boolean value.

 public bool NotifyOnComment(string username){
        var notify = (from s in db.AccountSettings
                      where s.UserName == username
                      select s.NotifyOnComment).DefaultIfEmpty(false);

        // clueless
    }

Update:

I'm doing the following now:

var notify = (from s in db.AccountSettings
                      where s.UserName == username
                      select s.NotifyOnComment).SingleOrDefault();

        return (bool)notify;

Upvotes: 14

Views: 31648

Answers (4)

Necro
Necro

Reputation: 41

var notify = (from s in db.AccountSettings
              where s.UserName == username
              select s.NotifyOnComment).Count();

return  Convert.ToBoolean(notify);

Upvotes: 4

Justin Niessner
Justin Niessner

Reputation: 245489

var notify = (from s in db.AccountSettings
              where s.UserName == username
              select s.NotifyOnComment).DefaultIfEmpty(false).First();

//notify will either hold a bool or the AccountSettings object so
return (!(notify == false)); // Thanks Nick. Amazing what you'll do in a hurry.

Upvotes: 9

Joey
Joey

Reputation: 354834

Linq, by default always returns collections. If you need a single value, you can apply the .Single(), .SingleOrDefault() or .First() or .FirstOrDefault() methods.

They differ slightly in what they do. Single() and SingleOrDefault() will only work if there is exactly or at most one record in the result. First() and FirstOrDefault() will work, even if there are more results.

The *OrDefault() variants will return the default value for the type in case the result contained no records.

Upvotes: 29

bruno conde
bruno conde

Reputation: 48255

If you expect just one result just use Single or SingleOrDefault to get the bool. If you want the first result you can use First or FirstOrDefault.

Upvotes: 1

Related Questions