Quality of the autogenerated sql queries in Visual Studio
I was having an issue with the auto generated delete statement. In my mind the delete should have just been DELETE [tablename] where [PK] = @param but instead it generates a query with 4 ORs. DELETE FROM Market WHERE (@IsNull_Name = 1) AND (Name IS NULL) AND (@IsNull_Description = 1) AND (Description IS NULL) AND (MarketId = ...