HI,

I'm using Ext JS 6.2 with a C# backend and trying to get data from my database in a grid. So far I got the entity framework setting up a database connection and using Linq I got my data. After parsing the result with javascriptserializer I got the json result to send to my ext frontend. It all works, the ajax call returns the data to the store, but the grid stays blank.

my c# controller

public ActionResult Index()
{
var context = new Database_Entities();
var table = (from Table in context.Table select Table).Take(1);
return Json(new JavaScriptSerializer().Serialize(new { Table = table }), JsonRequestBehavior.AllowGet);
}

the result

"{"Table":[{"ID":1,"strType":"ALL","lngParentID":null,"strHierarchy":"\\\\1\\\","lngExpanded":null,"lngIsFolder":null,"lngLevel":0,"strFullHierarchy":"\\\\ALL\\\","lngChildCount":8,"lngDurationPossible":1}"

the store

Ext.define('ExtExampleApplication.store.Table', {
extend: 'Ext.data.Store',
alias: 'store.table',
model: 'ExtExampleApplication.model.Table',
proxy: {
type: 'ajax',
url: '/Home',
reader: { type: 'json', rootProperty: 'Table'}
},
autoLoad: true
});

It all looks pretty straight forward, but no result in my ext app. What am I missing here? Is my problem the escaped Json and do I need a transform in my store?

Could somebody give me some pointers?

Thanks in advance.