how to store dynamically the desired value in my linqued query variable

Question

I have this query

  var empno = (from LApp in db.Employees
                    select new { LApp.EmployeeNumber }).ToList();

when executed I have this in empno

what I want is to trim the starting zeros and store it in empno

i.e {EmployeeNumber="2"} and so on... How is it possible?

score 0 · Answer 1 · answered May 11 '16 at 11:56

You can use TrimStart() to remove leading zeros, something like this :

var empno = (from LApp in db.Employees
             select new { EmployeeNumber = LApp.EmployeeNumber.TrimStart('0') }
            ).ToList();

I have no idea if TrimStart() can be translated to SQL, you might need AsEnumerable() if TrimStart() turned out not supported.

1 Answers1