How to add a serial number field Using Linq

jewel 1,206

I want a new field in my query to display a auto serial number.

  var data = from a in _context.tbl_Employees
             select new
             {
                 id = a.EmployeeID,
                 name = a.EmployeeName,
                 address = a.Address,
                 Slno =  // How Can Create?
           };

Accepted answer

Viorel 122.6K Reputation points

2024-08-08T09:53:44.14+00:00
Try this:

var data = _context.tbl_Employees.Select( ( a, i ) => new { id = a.EmployeeID, name = a.EmployeeName, address = a.Address, Slno = i + 1 } );
Please sign in to rate this answer.

1 person found this answer helpful.
jewel 1,206 Reputation points

2024-08-08T12:24:26.53+00:00

Thanks to answer, But it's Not working

Viorel 122.6K Reputation points

2024-08-08T12:34:42.5133333+00:00

Probably the _context.tblEmployees is empty.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer