MicrosoftHi Davide,
great article, thanks. However, I am not sure if ExecuteScalarAsync is the best method for retrieving data in that case. Dapper can only retrieve 2033 characters with a single query. In our case, if the dataset is large enough, JSON will be truncated which will lead to an exception when trying to parse it. My proposition is to use QueryAsync<string> or something else which returns collection which one we can later join into one string before trying to call JsonDocument.Parse(). Let me know what you think.
