JSON result is having larger size

Check this

https://www.uptech.team/blog/filter-1gb-json-on-frontend-and-not-crash-browser

How To Filter 1GB JSON On The Frontend And Not Crash The Browser

1. JSON files can be up to 1 GB.
2. No opportunity to add pagination on the backend — just accept as fact :(

 Hello Mark,

You can stringify JSON data to reduce size.

you can use library called Newtonsoft.Json. below is the common to install.

Install-Package Newtonsoft.Json -Version 13.0.1

Below is the sample code you can stringyfy JSON

return Json(JsonConvert.SerializeObject(LocationAddress),JsonRequestBehavior.AllowGet);

It will convert data as below format

"[\r\n  {\r\n    \"Result\": null,\r\n    \"Description\": null,\r\n    \"Id\": 0,\r\n    \"employee\": \"fata\",\r\n    \"department\":

In Javascrip you can use JSON.Parse() to get back in the expected format.

Jignesh Kumar dear I cannot do paging as It is not listing , The point is this is the manager login form when he login first time I want to get all location data from table having 200000 rows and save it in local storage , why the data is 60 MB ,  can we apply serialization or decerlizaation to reduce the size or my approach of api writing is wrong , I check your provided code as well but it still give lenth issue with return New JSON .

Hi Mark,

If you have huge volume of data in respone then you can implement pagination and bring only require data to display.

https://www.c-sharpcorner.com/article/how-to-implement-paging-using-skip-and-take-operators-in-linq/

Hi Mark,

You can use the paging concept with the Web API to send the data in chunks based upon the page and page size. I already worked with the such APIs which returns large dataset.

You can also refer to below link in case you want to see pagination implementtion in ASP.NET Web API.

https://code-maze.com/paging-aspnet-core-webapi/

I hope this will help you.

"[\r\n  {\r\n    \"Result\": null,\r\n    \"Description\": null,\r\n    \"Id\": 0,\r\n    \"employee\": \"fata\",\r\n    \"department\": 

getting this format how to format it 

Thanks Sachin Singhv & Jignesh Kumar for the response , I am getting data in visual studio even in postman i am getting data as i increased the maxjonlength to int.maxvalue, but the issue is it return 48 MB of data which hands my machine and everything , actuall the table has 300000 rows and 6 columns only with int and string so how it can make 48 MB 

So, in VS you are getting data without any issue when you put debugger?

Dear Sachin Singh its not related to vs i am checking using postman it is huge data even though if there are one million record it should not exceed 15-20 MB , the issue might be intentiating the new object everytime check the above code

Which VS version are you using, for VS 2019 and VS 2022, this issue is fixed. 

Please use the latest VS. You can still work on old workloads (webform) with VS 2022

The issue is larger size around 48 MB Jignesh Kumar

Hi Mark,

Please use this to make it work,

public JsonResult GetEmployeesLocation(string Country)
LocationAddress loc=new LocationAddress();
try
{
using(DBENTITY db=new DBENTITY())
{
List MyLoc=(from m in db.locations where m.country=="USA"
                                                  select new LocationAddress
                                                  {
                                                 State=g.state,
                                                 City=g.city,
                                                 village=g.village,
                                                 state_ID=(int)g.SID,
                                                 City_ID=(int)C_ID,
                                                 Village_ID=(int)V_ID,
                                                  });
LocationAddress.location=MyLoc
 return new JsonResult
            {
                Data = LocationAddress,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet,
                MaxJsonLength = int.MaxValue
            };
}
}