Query ToList() returns null

Question

Class

public class Employee
{
    public string EmployeeID { get; set; }
    public string Surname { get; set; }
    public string FirstName { get; set; }
    public bool Employed { get; set; }
    public bool Administrator { get; set; }
}

Linq statement

var adminlist = db.Employees.Where(x => x.Administrator).Select(x => x.Administrator).ToList();

I'm sure this is a stupid question but please can anybody tell me why the above returns null? I've tried this too:

var adminlist = db.Employees.Where(x => x.Administrator).ToList();

Answer 1

Your second query will NEVER return null unless the database is inaccessible. IEnumerable.ToList() will never return null, only an empty list if no items were found. It will throw an exception if the source is null.

Your problem lies elsewhere.