Select All Rows Using Entity Framework

Question

I'm trying to select all the rows out of a database using entity framework for manipulation before they're sent to the form

var ptx = [modelname].[tablename](); ptx.[tablename].Select(????) 

what goes in the ????

Answer 1

I used the entitydatasource and it provide everything I needed for what I wanted to do.

_repository.[tablename].ToList();

Answer 2

Entity Framework has one beautiful thing for it, like :

var users = context.Users;  

This will select all rows in Table User, then you can use your .ToList() etc.

---

For newbies to Entity Framework, it is like :

PortalEntities context = new PortalEntities(); var users = context.Users; 

This will select all rows in Table User