using System;

using System.Collections.Generic;

using System.Data;

using System.Data.Entity;

using System.Linq;

using System.Net;

using System.Web;

using System.Web.Mvc;

using DatabaseFirst.Models;

using DatabaseFirst.ViewModels;

​

namespace DatabaseFirst.Controllers

{

    public class tblReportsController : Controller

    {

        private DataDictionaryEntities db = new DataDictionaryEntities();

​

        // GET: tblReports

        public ActionResult Index()

        {

            return View(db.tblReports.ToList());

        }

​

        // GET: tblReports/Details/5

        public ActionResult Details(int? id)

        {

             ReportViewModel rvm = new ReportViewModel();

             tblReport Report = db.tblReports.Find(id);

             List<tblDBTablesUsed> DBTablesUsed = db.tblDBTablesUseds

                 .Where(x => x.fldReportID == Report.fldReportID).ToList(); //execute DB query using ToList()

             // I only need to return one report (with the id passed into the method, do we still need to use a list?

             List<tblReport> reports = db.tblReports

                 .Where(rep => DBTablesUsed.Select(x => x.fldReportID).Contains(rep.fldReportID)

                 .ToList(); // this line is erroring (red squiggly line in visual studio. see below for error message

             List<tblDBTable> tables= db.tblDBTables

                 .Where(rep => DBTablesUsed.Select(x => x.fldTableID).Contains(rep.fldTableID) //I have changed fldTableName to fldTableID here

                 .ToList(); //same error highlighted here

             rvm.report = reports;

             rvm.dbtables = tables;

             return View(rvm);

        }

    }

}

// ERROR MESSAGE: 'bool' does not contain a definition for 'ToList' and no extension method 'ToList' accepting a first argument type of 'bool' could be found (are you missing a using directive or assembly reference?)