Hi Guys, I have a query about NH Spatial. I've read the wiki and the example unit test files that show the most common queries, and can't find what I was looking for so I though I would ask here before I resort to trying things in good old SQL. Basically, I want to run an HQL query that goes somethimg like this:
SELECT TOP 100 LOCATIONS ORDER BY DISTANCE FROM THISLOCATION Is this possible in NHibernate spatial??? If not does anyone know if its possible (or computationally feasible) in SQL? I figure the database would probably need to work out the distance between "thislocation" and every other location before returning results..... or does spatial indexing make this kind of query scalable in SQL server 2008?? Any insight would be greatly appreciated. Kevin. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "NHibernate Contrib - Development Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com.ar/group/nhcdevs?hl=en -~----------~----~----~----~------~----~------~--~---
