What is the Best Way to Perform Geo Spatial Searches with Entity Framework Code First CTP 5?

Question

I'd really like to give Entity Framework 4 Code First CTP a try with a greenfield app but I want to make sure that geo spatial searches will not be a problem before I do, or I'll go another route.

Has anyone performed a geo-spatial search with EF CF? If so, how did you do it and why?

Answer 1

It's a problem insofar as it's not supported in L2E. But you can write a proc which returns the right results, and consume that with L2E.

I think NerdDinner has an example of this.

Edited to add: You can also use straight SQL in EF 4 without a proc.