Json format for blobbed column in sqlserver

ServiceStack.OrmLite
1

I’m trying to query a blobbed column using the new Json function in sqlserver 2016 in SqlManagement but it complains about the format of the serialized Json data not having quotes around the properties.

Is there a setting to turn the quotes on in Ormlite?

2

The default complex type serializer for SQL Server uses JSV, you can change it with:

SqlServerDialect.Provider.StringSerializer = new JsonStringSerializer();
3

Thanks Mythz, that worked a treat.

4

So it saved to the db as expected, however I’ve got data that is in the previous Json format, is there a quick way to update all the blobbed data to use the JsonStringSerializer without losing any data?

5

Read the rows into memory in a List of POCOs using the default, change the configuration to JSON, then save the records again.