Binding entity framework to TreeView MVC

[Victor]

Hi everyone,

I am developing an ASP.NET Web Application, in which I am accessing an SQL database to retrieve information from a table.

The information accessed from SQL (one single table) is stored in an entity framework. Each item in the framework contains ID, ParentID and name.

In my application so far, I can print every item in the entity framework and its information (using a for loop).

 

I would like to generate a TreeView using Telerik to display each item, and its respective children items (we can figure that out from ParentID). I had a look at demos but none seemed to apply to my case, as the data that is contained in the entity framework is dynamic (it will not always be the same, sometimes they will be more or less levels in the tree,etc), so we cannot hard code the tree elements.

 

Does anyone know if this can be done?

Thanks.

[Victor]

Just to clarify, I am coding using MVC and that is my only option.

[Bozhidar]

Hi,

Please take a look at the following demo, which shows how you can bind the Kendo MVC TreeView to a self-referencing table through EntityFramework:
https://demos.telerik.com/aspnet-mvc/treeview/remote-data-binding

If you need any further assistance, please don't hesitate to contact us again.

Regards,
Bozhidar
Progress Telerik

[Steve]

I am trying to get a treeview to show in a popup window from a custom command button in a grid.

Following the remote binding demo, I get an error:

Uncaught TypeError: item.level is not a function
    at eval (eval at compile (kendo.all.min.js:25), <anonymous>:3:222)

From controller:

        public JsonResult Move_Read(long? id)
        {
            using (var context = new Entities(DSRConfigurationManager.GetInstance().GetDatabaseConnectionString()))
            {
                var containers = from c in context.cdsl_container
                                 where (c.cdsl_parent_container_id ?? 0) == (id ?? 0)
                                 select new
                                 {
                                     id = c.cdsl_container_id,
                                     Name = c.container_label,
                                     hasChildren = c.cdsl_container1.Any(),
                                     ParentID = c.cdsl_parent_container_id
                                 };
                return Json(containers, JsonRequestBehavior.AllowGet);
            }
        }

From cshtml:

<script type="text/x-kendo-template" id="MoveTemplate">
    @(Html.Kendo().TreeView()
        .Name("treeview")
        .DataTextField("Name")
        .DataSource(dataSource => dataSource
                        .Read(read => read.Action("Move_Read", "Container"))
                    )
        .ToClientTemplate()
    )
</script>

[Steve]

Followup: The root cause of the problem had to do with an "ObjectContext has been disposed" error on the database reader.  All is working now.