private static System.Collections.Generic.List<GeoLocation> NewMethod()
{
var dbContext = new AIMS_DBEntities();
var divisions = (from d in dbContext.tblDivisions
where d.GPSLatitude != null && d.GPSLongitude != null
select new GeoLocation
{
DivisionId = d.Id,
Name = d.DivisionName,
Latitude = (double)d.GPSLatitude,
Longitude = (double)d.GPSLongitude
}).ToList();
var districts = (from d in dbContext.tblDistricts
where d.GPSLatitude != null && d.GPSLongitude != null
select new GeoLocation
{
DistrictId = d.Id,
Name = d.DistrictName,
Latitude = (double)d.GPSLatitude,
Longitude = (double)d.GPSLongitude
}).ToList();
return districts;
}
}