Orchard CMS Update Common_BodyPartRecord table

Question

I need to make some text changes to over 100 blog posts migrated from a Wordpress site. I was going to do this via SQL to update rows in the Common_BodyPartRecord table.

When I update the rows the changes are not reflected in the front end. I understand Orchard uses NHibernate, is there some sort of caching I am not aware of?

I know that you are advised to not mess about in the database, so is there a better way to do some bulk text manipulation? If necessary I can generate an Orchard module and do this via a database migration.

NB All blog posts are latest and published.

Answer 1

It's not exactly caching per se, it's that the body part is also stored on the Infoset, which is a blob of XML that you can find on the content item records. You need to change both.