How to select all using IQueryable

Question

Using MVC3, I have a Student Repository (in a project) and a StudentService (in another project). In the service I want to create a function that returns all of the students that are in the db table. This is a new way of doing things for me so I'm a bit new. in the GetAllStudents Function below, How could I change the syntax to select all.

In Repository:

      namespace SpeakOut.Data
{
   public class StudentRepository
{
    SpeakOutDataContext context;
    private Table<StudentEntity> table;
    public StudentRepository()
    {
        context = new SpeakOutDataContext();
        table = context.GetTable<StudentEntity>();
    }


    public IQueryable<Student> Select()
    {
        return table.Select(x => new Student
                                {
                                    WNumber = x.WNumber,
                                    CatalogueYear = x.CatalogueYear,
                                    Standing = x.Standing
                                });
    }
}

}

In Services:

   namespace SpeakOut.Services
   {
  public class StudentService
 {
    private StudentRepository repository;
    public StudentService()
    {
        repository = new StudentRepository(); 

    }

    public IQueryable<Student> GetAllStudents()
    {
        return repository.Select().All(x => x.FirstName) ; //**This line is where I don't know how I would call all the students**
    }


}

}

Answer 1

You don't even need just a blank Select, you can just call .AsQueryable, or just return 'table' as an IQueryable.