private IList <Address> NHGis(bool useSquare, bool regularSize) { Random ran = new Random(DateTime.Now.Second); var session = SessionFactory.GetSession(); var criteria = session.CreateCriteria <Address>(); criteria.Add(SpatialRestrictions.Within("Coordinates", useSquare ? GetRandomSquare(ran, regularSize) : GetRandomIrregularPolygon(ran, regularSize))); return(criteria.List <Address>()); }
public void ReadTestGis() { var session = SessionFactory.GetSession(); var criteria = session.CreateCriteria <Address>(); var ran = new Random(); criteria.Add(SpatialRestrictions.Within("Coordinates", GetRandomPolygon(ran))); criteria.SetProjection(Projections.RowCount()); var count = criteria.UniqueResult(); }
private static void ReadSQlGis(int total) { Console.WriteLine(); Random ran = new Random(DateTime.Now.Second); for (int i = 0; i < total; i++) { Console.Write("\r{0:N2}% ", (i + 1) / Convert.ToDouble(total) * 100); var session = SessionFactory.GetSession(); var criteria = session.CreateCriteria <Address>(); criteria.Add(SpatialRestrictions.Within("Coordinates", GetRandomPolygon(ran))); criteria.SetProjection(Projections.RowCount()); var count = criteria.UniqueResult(); } Console.WriteLine(); }
/// <summary> /// Apply a "within" constraint to the named property /// </summary> public AbstractCriterion Within(object value) { return(this.Process(SpatialRestrictions.Within(this.propertyName, value))); }
/// <summary> /// Apply a "within" constraint to the named property /// </summary> public TReturn Within(object value) { return(this.Add(SpatialRestrictions.Within(this.propertyName, value))); }