"System.ArgumentNullException: Value cannot be null" in MVC 3

Question

When I am developing a basic Employee application of CRUD Operations using jQuery dialog and Entity Framework, I am getting two type of error when I am debugging and when I am building the solution, I know they both linked to each other but I am not able to figure out

Error 1 when building:

The type arguments for method 'System.Linq.Enumerable.OrderBy(System.Collections.Generic.IEnumerable, System.Func)' cannot be inferred from the usage. Try specifying the type arguments explicitly

This the code(in Model class):

public IEnumerable<tblEmployee> GetEmployeePage(int pageNumber, int pageSize, string searchCriteria)
{
    if (pageNumber < 1)
        pageNumber = 1;

    return testEmp.tblEmployees
      .OrderBy(searchCriteria) //I am getting error here//
      .Skip((pageNumber - 1) * pageSize)
      .Take(pageSize)
      .ToList();
}

Error 2 when debugging:

System.ArgumentNullException: Value cannot be null.

The code as below (in View):

@model Emp_Mvc_Application.Models.PagedEmployeeModel 
@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_Layout.cshtml";
    WebGrid grid = new WebGrid(rowsPerPage: Model.PageSize);
    grid.Bind(Model.TblEmp, autoSortAndPage: false, rowCount: Model.TotalRows);
}

Jason Evans · Accepted Answer · 2014-03-12 13:13:59Z

2

Your search criteria needs to be a lambda expression e.g.

OrderBy(e => e.EmployeeID)

Instead of a string try this

public IEnumerable<tblEmployee> GetEmployeePage(int pageNumber, int pageSize, Func<tblEmployee, object> searchCriteria)
{
if (pageNumber < 1)
        pageNumber = 1;

    return testEmp.tblEmployees
      .OrderBy(searchCriteria) 
      .Skip((pageNumber - 1) * pageSize)
      .Take(pageSize)
      .ToList();
}

Call it like so:

var result = GetEmployeePage(1, 10, e => e.EmployeeId)

edited Mar 12, 2014 at 13:13

answered Mar 12, 2014 at 13:08

Jason Evans

29.2k16 gold badges95 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:04:06Z

0

It looks like you are passing a string in as your orderby criteria - that method is expecting a delegate. That seems like a misleading error but I believe that is your issue.

For example:

.OrderBy(e => e.LastName)

If you need to be able to sort by a string criteria you may want to look here- How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Mar 12, 2014 at 13:09

Kelly Robins

7,3236 gold badges46 silver badges66 bronze badges

Collectives™ on Stack Overflow

"System.ArgumentNullException: Value cannot be null" in MVC 3

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related