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)));
}
