SQL Server rows appear to not be deleting

The Stupid Problem You are working on a database that you are not very familiar with as a developer – meaning that you are not going to think of every little thing that a DBA...

Sql Server tSql: DELETE statement executes but won’t delete

Problem I ran into the most puzzling issue recently where I was executing a DELETE statement inside of a transaction among other statements inside of a stored procedure. Then the weirdest most puzzling thing happened, the statement executed,...

Entity Framework: Basic CRUD Operations

I like Entity Framework (EF), I think it is a little too rigid sometimes and it would be very nice if there was a very straight forward way to get Plain Old CLR Objects (POCO)...