Boostrap Treeview with EF and MVC

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.

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);

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.