public IActionResult RequestDb() { ViewBag.IsRequestView = true; ViewBag.Requests = DbAnalyzer.GetMostExpensiveRequest(); ViewBag.ReadableTables = DbAnalyzer.GetReadableTables(); ViewBag.WritableTables = DbAnalyzer.GetWritableTables(); return(View("AdminPanel")); }
public IActionResult IndexDb() { ViewBag.IsIndexView = true; ViewBag.RequiredIndexes = DbAnalyzer.GetRequiredIndexes(); ViewBag.UnusedIndexes = DbAnalyzer.GetUnusedIndexes(); ViewBag.MostExpensiveIndexes = DbAnalyzer.GetMostExpensiveIndexes(); ViewBag.AlterIndexText = DbAnalyzer.GetAlterIndexesSql(); return(View("AdminPanel")); }