Is it possible to convert JSON data in C#?

[dapoole]

Hi there,

I am DBA with zero C# programming experience however I would like to ask all C# programmers out there how they would handle large JSON data. Currently I have a very slow query when trying to convert filestream NVARBINARY(MAX) stored JSON data into NVARCHAR(MAX) from within SQL Server, such as:

SELECT ID,
JSONDATA,
(CONVERT(NVARCHAR(MAX),JSONDATA)) AS 'JSON'
FROM Forms

Is there a method in C# where this (CONVERT(NVARCHAR(MAX),JSONDATA)) conversion can be taken out of the database to be performed in the application layer?
When (CONVERT(NVARCHAR(MAX),JSONDATA)) is removed from the query it returns extremely fast. With (CONVERT(NVARCHAR(MAX),JSONDATA)) included it takes many minutes.

TIA

 

[jmcilhinney]

I'd look here:

http://www.newtonsoft.com/json

I've never used it but I've heard good things from many people. I would imagine that there's a NuGet package.

 

[dapoole]

Thanks. Anyone know what the performance comparison is between doing a conversion from within the database engine to using C# at the application layer is? Which would be quicker?

This:

SELECT CONVERT(nvarchar(max),JSONDATA) FROM Forms

Or this:


using(var command =newSqlCommand(connection))
{
command.CommandText=@"SELECT JSONDATA FROM Forms";
command.Open();
byteArray = command.ExecuteScalar()asbyte[];
}

var result =System.Text.Encoding.UTF8.GetString(byteArray);

 

[jmcilhinney]

What's stopping you testing it for yourself?

 

[dapoole]

What's stopping you testing it for yourself?

Did you not read, I know zero about C#? Can you help test this out for me or not?