LINQ to SQL and Entity Framework don’t support the geometry data type… boo…

Today I had a conversation with a co-worker that started with my declaration of not wanting to ever have to code a stored procedure. Adamantly I know that there are places where sprocs are the solution to a problem but in today’s landscape I feel those are edge cases. Our argument..err..I mean conversation had all the usual discussion points. co-worker points: sprocs are faster sprocs are more secure sprocs provide a layer in n-tier My points: the dollar cost of milliseconds of speed true see comments; but all queries should be parameterized hence not a valid argument. an unnecessary abstraction...

Note: This code does not support caching or security trimming. It is simply a way to build something that compares to the .NET TreeView control using the MVC pattern. Recently one of my clients had the "perfect storm" of requirements, restrictions, deadlines and policies that lead to the need to develop a MVC TreeView(ish) control.   Requirements: Database storage – Site administrations needed a simple interface into editing and I was not about to write something to update XML files. NOT use the SQL Service Broker for easy SQL caching support – Security concerns….I...

In the past, when building small web applications with up to a couple concurrent users, I’ve placed the database on the same system as the web server. Blasphemy!!!…not really. You see, knowing that database systems will entirely consume their allocated memory allows for clear capacity planning. There are many factors that need to be taken into consideration when designing an architecture and for the sake of this post lets just say that: This system does not require a ridiculous amount of memory This system does not require HA And really, while every project sponsor will tell you that their...