Solving ‘Spatial types and functions are not available’ with Entity Framework

Using SQL Server’s Geospatial features with Entity Framework is awesome. I was crusing along just fine with using DbGeography for an ASP.Net application I’m working on… Right up until I deployed to the server. Yep. It worked on my machine, but alas, I was hitting a runtime exception on my test server. This was the […]

SQL Sever Synonyms, Entity Framework, & Integrated Security

Jump to… Scenario Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ Resolving the error Creating the view Granting permissions Was this article helpful? Please share! Scenario This may be an edge case, but I spent enough time (a couple of days) spinning on this that I thought it warranted a signpost on the Internet. Suppose we […]