Hello,
I have a query and I need to use "Not equal" in this.
Query:
- HRMSContext Entities = (this.HRMSRepository.Context as HRMSContext);
- var query = from a in Entities.SCRB_t_UnidentifiedDeadBody_PS.Where(i => i.District == iDISTRICT_CD && i.PoliceStation == iPS_CD)
- join ad in Entities.SCRB_t_UnidentifiedDeadBody on a.PanchnamaNo equals ad.PanchnamaNo
- join d in Entities.m_district.Where(i => i.LANG_CD == 99) on a.District equals d.DISTRICT_CD
- join p in Entities.m_police_station.Where(i => i.LANG_CD == 99 && i.DISTRICT_CD == iDISTRICT_CD) on a.PoliceStation equals p.PS_CD
- select new
- {
- PanchnamaNo = a.PanchnamaNo,
- GDDate = a.GDDate,
- Find_Date = a.Find_Date,
- DISTRICT = d.DISTRICT
- };
How to replace "equals(red color)" to "not equal" .
Please help.
Thanks in advance.