I am using .net Web Api to get data for my data grid. The call is made via ajax call like this
$.ajax({
type: 'GET',
dataType: 'json',
contentType: "application/json; charset=utf-8",
url: ReportURL, // "api/AppData/InvoiceReport/10"
success: function (mydata) {
console.log(mydata);
createReportGrid(myData); // this function creates a KENDO grid
},
error: function (error) {
alert(error);
}
});
The Web API method Looks like this
[HttpGet]
public HttpResponseMessage InvoiceReport(int Id)
{
// some llogic of data retrieving
// objReportDataList is of Type List<vmReport>
// thisstructure contains a DataTable, and 2 more list type
return Request.CreateResponse(HttpStatusCode.OK, objReportDataList);
}
These calls work perfectly for Rows Count approx 100K rows
Web Api serializes perfectly. But when the Row Count exceeds 200K i get 500 internal server error The stack traces tells "System-OutOfMemoryException-occured-in-mscorlib-dll"
NOTE - I cant use server pagination to get little data only. This Million rows data is working on a ASP.NET Webforms application. We have migrated to MVC pattern and used WebApi for fetching Data but this error is occuring. PS - I have tried many many solutions, but helpless
Please Guide me to Get this error removed and my reports get going
</div>