How to check results of LINQ to SQL query?

Question

In a WPF app I'd like to check if a return of a LINQ to SQL query contains some records, but my approach doesn't work:

        TdbDataContext context = new TdbDataContext();
        var sh = from p in context.Items where p.Selected == true select p;

        if (sh == null)
        {
            MessageBox.Show("There are no Selected Items");
        }

Where am I wrong?

Answer 1

A linq query will never be null because it will always return an IQueryable. Try calling sh.Any() instead.

if (!sh.Any())
    MessageBox.Show("There are no Selected Items");