Modern SQL Server can handle NoSQL-style JSON data. Stop serializing/deserializing in C#; do it in SQL!
SELECT JSON_VALUE(LogData, '$.Browser') as Browser FROM WebLogs WHERE JSON_VALUE(LogData, '$.Status') = 'Error'
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Modern SQL Server can handle NoSQL-style JSON data. Stop serializing/deserializing in C#; do it in SQL!
SELECT JSON_VALUE(LogData, '$.Browser') as Browser FROM WebLogs WHERE JSON_VALUE(LogData, '$.Status') = 'Error'