Archive | SQL Server RSS for this section

Spatial Data in Entity Framework 5.0

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.


ADO.NET Entity Framework – part 2

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.