I have a filter implemented with PTWContents = await _context.PTWContents.Where(x => x.OrgID == UserDataRole.OrgID && x.PTWStatus.Equals(SearchPTWStatus)).OrderByDescending(x => x.PTWNo).ToListAsync(); where SearchPTWStatus is a string which is working perfectly. But when I try to use the same approach where the search parameter is an integer I got no result. What else should I do?

Compare it with == instead of Equals PTWContents = await _context.PTWContents.Where(x => x.OrgID == UserDataRole.OrgID && x.PTWStatus == SearchPTWStatus).OrderByDescending (x => x.PTWNo).ToListAsync();

I had to use PTWContent = await _context.PTWContents.Where(x => x.OrgID == UserDataRole.OrgID && x.PTWNo == (SearchPTWNo)).SingleOrDefaultAsync(); == instead of Equals and it worked

Answers

asp.net core search parameter int not working

Marius Vasile

565

I have a filter implemented with

PTWContents = await _context.PTWContents.Where(x => x.OrgID == UserDataRole.OrgID && x.PTWStatus.Equals(SearchPTWStatus)).OrderByDescending(x => x.PTWNo).ToListAsync();

where SearchPTWStatus is a string which is working perfectly.

But when I try to use the same approach where the search parameter is an integer I got no result. What else should I do?