public base_risk GetRiskSite(DbGeometry inLocation) { base_risk br = null; using (DataMapsEntities me = new DataMapsEntities()) { br = me.base_risk.Where(f => f.geom.Contains(inLocation)).FirstOrDefault() as base_risk; } return(br); }
public void loadRiskFiles(string inFileName) { List <base_risk> myRiskSites = new List <base_risk>(); IFeatureSet fs = FeatureSet.Open(inFileName); DataTable dt = fs.DataTable; for (int i = 0; i < dt.Rows.Count; i++) { base_risk risk = new base_risk(); IFeature f = fs.Features[i]; risk.geom = DbGeometry.FromText(f.BasicGeometry.ToString()); risk.RISK = GetNullableDouble(dt.Rows[i], "RISK"); // risk.LABEL = dt.Rows[i]["LABEL"]; myRiskSites.Add(risk); } using (me = new MapEntites()) { me.Database.ExecuteSqlCommand("Truncate Table [base_risk]"); me.base_risk.AddRange(myRiskSites); me.SaveChanges(); } }