Returning a single value with Linq to SQL

indiankings

New Member
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.\[code\] public bool NotifyOnComment(string username){ var notify = (from s in db.AccountSettings where s.UserName == username select s.NotifyOnComment).DefaultIfEmpty(false); // clueless }\[/code\]Update:I'm doing the following now:\[code\]var notify = (from s in db.AccountSettings where s.UserName == username select s.NotifyOnComment).SingleOrDefault(); return (bool)notify;\[/code\]
 
Top