Loading

asp.net core search parameter int not working

Marius Vasile

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta5y ago
Accepted answer
Compare it with == instead of Equals
PTWContents = await _context.PTWContents.Where(x => x.OrgID == UserDataRole.OrgID && x.PTWStatus == SearchPTWStatus).OrderByDescending (x => x.PTWNo).ToListAsync();
Marius Vasile5y ago
I had to use
PTWContent = await _context.PTWContents.Where(x => x.OrgID == UserDataRole.OrgID && x.PTWNo == (SearchPTWNo)).SingleOrDefaultAsync();
== instead of Equals and it worked