sql - WPF C# JSON length issue

Question

Below is my code in C#. It is trying to get SQL result as JSON from database. I run this SQL query "SELECT XX FROM AA FOR JSON AUTO" in SQL server Management Studio, if the table has 5 rows, it is ok. But if the table has 2000 rows or more, then it will truncate the string result. Is there any method to allow C# to get full length of JSON result?

   SqlCommand query= new SqlCommand("SELECT XX FROM AA FOR JSON AUTO", cn);
                    cn.Open();
                    string JSON= query.ExecuteScalar().ToString();
                    cn.Close();
     

question from:https://stackoverflow.com/questions/65942249/wpf-c-sharp-json-length-issue

Answer 1

Waitting for answers