Entity Framework Tip – Specifying Decimal Precision

By default, Entity Framework takes the .Net decimal Type and maps it to SQL Server’s decimal(18,2) data type. If you’ve got a property on an Entity that is of Type decimal, but down in your database, you’re allowing for greater precision than 2 decimal places (scale is actually the proper term for the number of […]

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 […]