public int GetCount(string filter)
{
using (var db = new KendoDataContext())
{
return(db.Employees.Where(filter).Count());
}
}
public IEnumerable <Employee> GetPaged(int skip, int take, string sort, string filter)
{
// using pattern to demonstrate scenario where IQueryable is evaluated in a different context / scope
using (var db = new KendoDataContext()){
return(db.Employees.Where(filter).OrderBy(sort).Skip(skip).Take(take).ToList());
}
}