private Int16 ProvinceIdFromGeocode(Int32 provinceGeocode) { Int16 provinceId = 0; XElement geocodeXml = XElement.Load(TambonHelper.BasicGeocodeFileName()); var query = from c in geocodeXml.Descendants(TambonHelper.TambonNameSpace + "entity") where ((Int32)(c.Attribute("geocode")) == provinceGeocode) select c.Attribute("name"); foreach (String s in query) { provinceId = _provinceIds[s]; } return(provinceId); }