find the max value throw the dlink

[pankajprakash]

Hi

I have a table which contain the filed

id, departmentid, sectionid, name




now i have to find the max id of the same department and section. How can get the max id through the dlink

[saran23]

Hi

I have a table which contain the filed

id, departmentid, sectionid, name




now i have to find the max id of the same department and section. How can get the max id through the dlink

the query is

Select Max(id) from tablename where departmentid=sectionID

[pankajprakash]

Hi

I have a table which contain the filed

id, departmentid, sectionid, name




now i have to find the max id of the same department and section. How can get the max id through the dlink

i got the answer

id = obIncidentDataC ontext.Incident _PersonsInvolve ds.Where(x => x.departmentid == departmentid && x.sectionid ==sectionid).Se lect(x => x.ID).Max();