Оптимизировать запрос linq - C#
Формулировка задачи:
var users = manageUserRepository.GetUsers().OrderBy(gridSortOptions.Column, gridSortOptions.Direction).AsPagination(page ?? 1, 10);
public IQueryable<UserView> GetUsers()
{
var dataContext = new whis2011wiski_ManageUser();
var users = from u in dataContext.aspnet_Users
select new UserView
{
UserId = u.UserId,
UserName = u.UserName,
LastActivityDate = u.LastActivityDate,
IsApproved = u.aspnet_Membership.IsApproved
};
return users;
}Решение задачи: «Оптимизировать запрос linq»
textual
Листинг программы
public IQueryable<UserView> GetUsers(int count)
{
var dataContext = new whis2011wiski_ManageUser();
var users = dataContext.aspnet_Users.Select(u=> new UserView
{
UserId = u.UserId,
UserName = u.UserName,
LastActivityDate = u.LastActivityDate,
IsApproved = u.aspnet_Membership.IsApproved
}).Take(count);
return users;
}