In Entity Framework 5.0 spatial data types are supported so now we can create Linq queries to query nearby locations, calculate distances and check if locations intersect with an area. This articles demonstrates how to insert and update locations with latitude and longitude coordinates and how to query them in different ways.
- Setup of demo project
- Inserting and updating locations
- Calculating distances to a given location
- Calculating distances to a given route
- Locations that intersect with an area
Today I posted the second part of my series of articles about the ADO.NET Entity Framework. This article covers a few handy testing and learning tools like eSqlBlast and LINQPad. It also describes some techniques on how to view the generated T-SQL statements when executing Entity SQL or LINQ to Entities queries.