Here's my simplified domain
public class Notification
{
public Guid ID { get; set; }
public string Name { get; set; }
public IEnumerable<Location> Locations { get; set; }
}
public class Location
{
public Guid Id { get; set; }
public string Name { get; set; }
public decimal Longitude { get; set; }
public decimal Latitude { get; set; }
}
Notifications and Locations have a many-to-many relationship (defined in table LocationsOnNotification). What I'd like
to do is query for the nearest 10 Notifications from a given longitude and latitude.
I've been trying
to use ICriteria, but I'm not sure how
to specify the ordering correctly:
return Session.CreateCriteria<Notification>()
.SetFirstResult(firstIndex)
.SetMaxResults(maxResults)
.AddOrder(Order.Asc( WHAT GOES HERE! ))
.List<Notification>();
What I've been thinking of so far is adding a formula property
to the Location mapping; something like this:
<property name='Distance' formula='lots of geometry'/>
But I'm not sure if that can take in parameters (since I'd need
to pass in the user's location
to calculate the distance), plus I'm not sure how
to specify it in the Order.Asc clause given that it's a property on a many-to-many association class.
Any ideas? Or perhaps I should take a different approach altogether.
Thanks in advance!
