BannerDataDictionary.Controllers.HomeController.Index C# (CSharp) Method

        public ActionResult Index()
        {
            ViewBag.Message = "Oracle Linked Servers";
            using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString))
            {
                conn.Open();

                var loginId = User.Identity.Name;
                var bannerUserList = conn.Query(string.Format("SELECT LoginId FROM BannerLoginIds WHERE LoginId = '{0}'", loginId)).ToList();
                var includeBannerItems = bannerUserList.Count() == 1 ? true : false;
                var resultList =
                    conn.Query<LinkedServer>(
                        string.Format("EXEC usp_GetOracleLinkedServerNames @IncludeBannerItems = {0}",
                                      includeBannerItems)).ToList();

                if (!includeBannerItems)
                    TempData["Message"] = BannerMessage;

                 return View(resultList);
            }
        }