Restfull point in polygon in SQL Azure

I want to create a 开发者_开发问答restfull WCF service in Azure to store polygons drawn in Bing maps. Each polygon has also a descriptive text. Response format must be JSON.

The most important feature must be to retrieve the list of polygons (with text) for a given point (lat long) (so I must have a point in polygon routine).

I am not a geo expert, but I was recommended to use the geo spatial part of SQL Azure. How can this be done ?

---

I have a suggestion.
- First try implementing your polygon detection in standard SQL Server.
- then port your SQL Server solution to an Azure equivalent.
- and finally expose a WCF interface to your functionality.

If you break it down like this you may find it easier to ask more specific questions that are more likely to get answered.