Does this support Json data

[jnothstine]

I have a column in my database that is json data. I can write a statement that looks something like this:

.Where(x => (JsonValue(Convert(x, IJsonDataContainer).Data, "$.userInfo.userName) == "someValue' ")

Where $.userInfo.userName is a path into the json that is stored in the Data column of the table.

Does this tool support that kind of syntax? I don't see it but I, hopefully, am missing something.

Thanks,

Jerry.

[StefH]

No sorry.

[jnothstine]

Stef, Thanks for the quick response. We did actually get it to do exactly what we want. ☺ Corey worked on it for a short period of time and got it to work. Said it was quite easy. Corey, can you please explain to Stef what you did to make it do what we want? Thanks, Jerry. From: Stef Heyenrath <notifications@github.com> Sent: Wednesday, January 2, 2019 1:09 PM To: StefH/System.Linq.Dynamic.Core <System.Linq.Dynamic.Core@noreply.github.com> Cc: Jerry Nothstine <Jerry.Nothstine@waterstreetcompany.com>; Author <author@noreply.github.com> Subject: Re: [StefH/System.Linq.Dynamic.Core] Does this support Json data (#234) No sorry. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#234 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AAvlI5ZIcCE_DekUFjTylyF6X-_8wX81ks5u_RG_gaJpZM4ZkcZI>.

[jnothstine]

In our existing EntityFramework Core implementation we had a JsonExtensions.JsonValue method that was registered within the DbContext as a ‘DbFunction’. This method simply trick the EntityFramework Core system to pass-through the SQL system function JSON_VALUE(string, string). In order for me to get the functionality to work within the System.Linq.Dynamic.Core libraries, I had to create a CustomTypeProvider that registered the previously mentioned JsonExtentions class within the System.Linq.Dynamic.Core libraries. Once I did that, I was able to pass through the existing DbFunction logic through the expression parser and have it generate the expression without error. I imagine this would work for any type of UDF or SQL system function.

…

-Corey From: Jerry Nothstine <Jerry.Nothstine@waterstreetcompany.com> Sent: Wednesday, January 2, 2019 1:52 PM To: StefH/System.Linq.Dynamic.Core <reply@reply.github.com> Cc: Corey Kamarainen <Corey.Kamarainen@waterstreetcompany.com> Subject: RE: [StefH/System.Linq.Dynamic.Core] Does this support Json data (#234) Stef, Thanks for the quick response. We did actually get it to do exactly what we want. ☺ Corey worked on it for a short period of time and got it to work. Said it was quite easy. Corey, can you please explain to Stef what you did to make it do what we want? Thanks, Jerry. From: Stef Heyenrath <notifications@github.com<mailto:notifications@github.com>> Sent: Wednesday, January 2, 2019 1:09 PM To: StefH/System.Linq.Dynamic.Core <System.Linq.Dynamic.Core@noreply.github.com<mailto:System.Linq.Dynamic.Core@noreply.github.com>> Cc: Jerry Nothstine <Jerry.Nothstine@waterstreetcompany.com<mailto:Jerry.Nothstine@waterstreetcompany.com>>; Author <author@noreply.github.com<mailto:author@noreply.github.com>> Subject: Re: [StefH/System.Linq.Dynamic.Core] Does this support Json data (#234) No sorry. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#234 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AAvlI5ZIcCE_DekUFjTylyF6X-_8wX81ks5u_RG_gaJpZM4ZkcZI>.

[jnothstine]

Hey Stef, Want to thank you for this package. I worked on one for three weeks and it barley got things done that I needed. Then, I “fell” onto this one while searching for something else. It took us less than half a day to remove ours and implement yours. This is super cool!! Thanks, Jerry. From: Jerry Nothstine Sent: Wednesday, January 2, 2019 1:52 PM To: 'StefH/System.Linq.Dynamic.Core' <reply@reply.github.com> Cc: Corey Kamarainen <Corey.Kamarainen@waterstreetcompany.com> Subject: RE: [StefH/System.Linq.Dynamic.Core] Does this support Json data (#234) Stef, Thanks for the quick response. We did actually get it to do exactly what we want. ☺ Corey worked on it for a short period of time and got it to work. Said it was quite easy. Corey, can you please explain to Stef what you did to make it do what we want? Thanks, Jerry. From: Stef Heyenrath <notifications@github.com<mailto:notifications@github.com>> Sent: Wednesday, January 2, 2019 1:09 PM To: StefH/System.Linq.Dynamic.Core <System.Linq.Dynamic.Core@noreply.github.com<mailto:System.Linq.Dynamic.Core@noreply.github.com>> Cc: Jerry Nothstine <Jerry.Nothstine@waterstreetcompany.com<mailto:Jerry.Nothstine@waterstreetcompany.com>>; Author <author@noreply.github.com<mailto:author@noreply.github.com>> Subject: Re: [StefH/System.Linq.Dynamic.Core] Does this support Json data (#234) No sorry. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#234 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AAvlI5ZIcCE_DekUFjTylyF6X-_8wX81ks5u_RG_gaJpZM4ZkcZI>.

[StefH]

@jnothstine;

I'm glad everything worked as defined for you!

[wakuflair]

@jnothstine

Thanks for your explanation. I learned a lot.
However I have a problem with the column name.
I constructed my query string like this: MyTable.Where("DbFunctions.JsonValue(\"column1\", \"$.name\") ... ), but DynamicLINQ generated the SQL JSON_VALUE('column1', '$.name'), where the column1 is generated as a string, rather than a column name, so my query failed.

Could you give me a sample of how your JsonExtensions is defined and how your query string constructs?

[superjulius]

@wakuflair @jnothstine This is a quite old issue but I am facing the same problem with the column name being interpreted as a string. It must be a dumb thing but could not get it working on my end...