Entity Framework - 3 tier - PagedData GetList Method

[muratto]

Hello,

I'm trying to build a 3 tier architecture with Ado.NET Entity Framework.

I want to select only paged records from Database.

But I can't find a solution to make dynamic with Linq to Entites or ObjectQuery.
How can I enable orderby and searchCriteria parameters.

This is the static code...

Thanks

public List<Customer> CustomerList(string searchCriteria, string orderby, int start, int pageSize)
{
    var q = from c in context.Customer
               Where c.CustomerName.Contains("John")
               Orderby c.CustomerName
               Skip(start).Take(pageSize)
               select();
 
    return q.ToList();
}