Boostrap Treeview with EF and MVC

Question

Hi I am creating an asp.net mvc bootstrap treeview following http://www.c-sharpcorner.com/UploadFile/3d39b4/bootstrap-tree-view-in-Asp-Net-mvc/. My issue is Sandeep is hardcoding in the BookViewMpdel items. I want to use a query to get it from the SQL Server database. Any help will be appreciated.

Kwasi Denkyira · Answer

I have finally got it working and will share my code here. I can do a write up for any one who want a TreeView using EF6 MVC5 and bootstrap. public ActionResult Edit() { var variant = from p in db.Products from v in p.PlatformVariants where p.Inactive == false && v.Archived == false select v; var product = from p in db.Products from v in p.PlatformVariants where p.Inactive == false && v.Archived == false select p; var productNew = product.Project().To ().Distinct().ToList(); foreach (var item in productNew) { item.ProductPlatformVM = new List (); var item1 = item; foreach (var plat in variant.Where(p => p.ProductID == item1.ProductID)) { item.ProductPlatformVM.Add(new ProductPlatformVM { Archived = plat.Archived, PlatformVariantID = plat.PlatformVariantID, PlatformVariantName = plat.PlatformVariantName }); } } return View(productNew); }

Kwasi Denkyira · Answer

Thanks. I will try that

Mukesh Kumar · Answer

Hi, Here you need to create a viewmodel for this and strongly bind it to treeview view. thanks