Wsrtjtyk

Is this a correct JSON string I get? I add a MenuList JSON column into the Menusss table, I'm trying to use the Pomelo.EntityFrameworkCore.MySql to create a dynamic side menu in ASP.NET Core 2.1

The problem is here, if my Menusss table didn't add the MenuList JSON, it will show me an error code "Unknown Column", but when I add a MenuList JSON into Menusss table, I get a difference JSON string here.

MySql:

CREATE TABLE Menusss(

    MenuId INT NOT NULL AUTO_INCREMENT,

    MenuName VARCHAR(250),

    ParentId INT,

    ActiveNo BOOL,

    MenuList JSON

);

JSON:

[

    {

        "menuId": 1,

        "menuName": "VEHICLE TRADING",

        "parentId": null,

        "activeNo": 1,

        "menuList": {

            "object": [

                {

                    "menuId": 2,

                    "menuName": "Purchase Agreement",

                    "parentId": 1,

                    "activeNo": 1,

                    "menuList": {

                        "object": ,

                        "json": ""

                    }

                }

            ],

            "json": "[{"MenuId":2,"MenuName":"Purchase Agreement","ParentId":1,"ActiveNo":1,"MenuList":{"Object":,"Json":""}}]"

        }

    }

]