Linq Query Count

Question

Hi
I have below code & i want that if there is more than 1 record it should give message
TicketAnalysi objUpload = context.TicketAnalysis.Single(rec => rec.TicketID == Convert.ToInt32(hdfTicketId.Value));
Thanks

Aravind Govindaraj · Accepted Answer

Please find the code
var moreThanOneRecordExists = context.TicketAnalysis.Where(rec => rec.TicketID == Convert.ToInt32(hdfTicketId.Value)).Skip(1).Any();

Vishal Joshi · Answer

Hello
You can check count.  please try below code.
if(context.TicketAnalysis.where(rec => rec.TicketID == (int)hdfTicketId.Value).count() == 1){
TicketAnalysi objUpload = context.TicketAnalysis.Single(rec => rec.TicketID ==
(int)hdfTicketId.Value);
}
else{
// Error Message
}
Thank you