Photo by Tanner Boriack on Unsplash

So why this post? because I messed up around 3000 data records in production and caused most of the fields to update to null or default values.

It was ugly.

Fortunately we managed to recover from the damage but why did that happen.

So consider this scenario. You have a table which contains posts and each post has a HeaderPicture stored as a blob in it. Now what happens if you are receiving an update for let’s say 12000 posts in your database and you need to do an update using Entityframework.

First idea would be to load the records…

Farhad Nowzari

Fullstack developer for around 10 years. Love to code for fun at free times if something interesting comes up and always ready to share the experience.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store