MssqlRow to json string without knowing structure and data type on compile time

Asked Dec 10 '21 at 18:24

Active Jun 12 '23 at 20:57

Viewed 42 times

I'm trying to query a database to get data, convert it to json file and send it to another service. Because those queries can have any column in any table it is impossible to define all structures and data types. I was trying to use sqlx lib but whatever I do MssqlRow won't compile because it cannot infer the type.

Each row should be separate json, so no list of jsons.

Jsons show be created in service, not on db level.

edited Jun 12 '23 at 20:57

Yuri Astrakhan

8,808
6
63
97

asked Dec 10 '21 at 18:24

HelloKitty

Is just asking SQL Server to produce the JSON an option? See (e.g.) [this question](https://stackoverflow.com/q/43587311/4137916) (some approaches do not require that you know the table structure). – Jeroen Mostert Dec 10 '21 at 18:46
Not really because I will do some operations like hash and modulo on first column and then convert it to json. – HelloKitty Dec 10 '21 at 18:49
That's a different question. – David Browne - Microsoft Dec 10 '21 at 18:51

MssqlRow to json string without knowing structure and data type on compile time

0 Answers0